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

Question

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.

Answer 1

Simply type in command prompt :

set path=%PATH%;D:\xampp\mysql\bin;

Here my path started from D so I used D: , you can use C: or E:

Answer 2

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