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.