Testing the MySQL Community Server 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-clickthe
mysqld.exe - Shortcutto open the
MySQL Community Server
MySQL Community Server Terminal is Open MySQL Community Server Terminalis open.
We have talked about this before, but it is worth repeating, the
MySQL Community Server Terminalshould remain open, but minimized on the
Taskbarwhile in use.
So minimize it
First Verification
In the start menu click on
Windows PowerShell
Second Verification
Click now on
Run as Administrator
Start -> Windows PowerShell The
Windows PowerShellwill open.
Windows PowerShell Type the following command:
mysqlshow -u root -p [ENTER]
Windows PowerShell Press:
ENTERwhen the
Enter passord:prompt appears.
Our
MySQL Community Serverinstallation was done so that you don't need a password initially.
Soon, we will correct this inconvenience.
Windows PowerShell A table with the default
MySQL Community Server Databasesshould be displayed.
Windows PowerShell Other commands can be tested in
Windows PowerShellhowever, for now, this is enough.
The
Windows PowerShellcan be closed.
The traditional method of closing can be used, however, to increase security, enter with
exitand then
ENTER
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