Introduction:

To use MySQL server on the command line, you must have the correct system path. This is usually done automatically.

Requirements:

MySQL server was installed

Procedure:

Locating mysql.exe:

Locate your mysql.exe

The example I will be using has mysql.exe in the below directory:
C:\Program Files\MySQL\MySQL Server 5.6\binClick the start toolbar

Right click “My Computer”

Click “Properties”

Select “Advanced”

Click “Environment Variables”

Locate “System variables”

Select the “Path” variable

Click “Edit”

Keep what was before the following the same, and then add the stuff between the quotes to the end:

…”;C:\Program Files\MySQL\MySQL Server 5.6\bin”