[SOLVED] mysql is not recognised as an internal or external command,operable program or batch

Issue

I had set the MySQL path, but still getting the same error. Please let me know whether I followed the correct one or not.

MySQL location is: C:\Program Files\MySQL\MySQL Server 5.0\bin

In Windows, system variables I had set the path as:

• variable name: MYSQL_HOME
• variable value: C:\Program Files\MySQL\MySQL Server 5.0\bin

For PATH setting:

• variable name: PATH
• variable value: .;%JAVA_HOME%\bin;%MYSQL_HOME%\bin...

If it is not the correct one, please let me know the correct path and its settings.

Solution

MYSQL_HOME variable value=> C:\Program Files\MySQL\MySQL Server 5.0\bin

%MYSQL_HOME%\bin

See the problem? This resolves to a path of C:\Program Files\MySQL\MySQL Server 5.0\bin\bin

Answered By – David Fells

Answer Checked By – Jay B. (BugsFixing Admin)