Testing the MySQL Community Server 


MySQL.png apg

In this part of this tutorial we will teach you how to test the MySQL Community Server on port 3306, by default.


 Desktop -> mysqld.exe - Shortcut 

If it is not already open,

Double-click

the

mysqld.exe - Shortcut

to open the

MySQL Community Server

my20.png apb


 MySQL Community Server Terminal is Open 

MySQL Community Server Terminal

is open.

my23.png apb

We have talked about this before, but it is worth repeating, the

MySQL Community Server Terminal

should remain open, but minimized on the

Taskbar

while in use.

So minimize it


 First Verification 

In the start menu click on

Windows PowerShell

my24.png apb


 Second Verification 

Click now on

Run as Administrator

my25.png apb


 Start -> Windows PowerShell 

The

Windows PowerShell

will open.

my26.png apb


 Windows PowerShell 

Type the following command:

mysqlshow -u root -p [ENTER]

my27.png apb


 Windows PowerShell 

Press:

ENTER

when the

Enter passord:

prompt appears.


Our

MySQL Community Server

installation was done so that you don't need a password initially.

Soon, we will correct this inconvenience.

my28.png apb


 Windows PowerShell 

A table with the default

MySQL Community Server Databases

should be displayed.

my29.png apb


 Windows PowerShell 

Other commands can be tested in

Windows PowerShell

however, for now, this is enough.

The

Windows PowerShell

can be closed.


The traditional method of closing can be used, however, to increase security, enter with

exit

and then

ENTER

my30.png apb




From now on the set: Apache Server on port 80, PHP and MySQL Community Server on port 3306 will simply be called a Server by us.



In the next parts of this tutorial, we will learn how to install and configure a PHP code editor and an application to handle the Databases generated by the MySQL Community Server, leaving the installation and configuration of the tool for FTP at your own risk.



 Fundamental Applications for the Whole System 


Following, we will instruct you how to install an application to edit scripts in PHP, css, js, SQL, txt, etc.

Code editor