How to Testing your MySQL Installation
When using MySQL with PHP, you’ll issue the same types of commands, only within the context of the PHP code.
Starting MySQL
To start MySQL manually, go to the Windows Start menu, choose Run, type
c:\Program Files\MySQL\MySQL Server 5.6\bin\mysql-nt.exe
And press Enter.
The MySQL process will now be running in the background. you can now connect to MySQL and create database and tables.
Creating a Test Database
Before going any further, you should know the following :
- A database is a collection of tables.
- A table contains a set of records, also referred to as rows.
- All records have the same number of fields.
- Each fields categorizes a piece of a data.