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

Question

I did set the MySQL path, but still, I'm getting the same error. Please let me know whether I followed it correctly or not.

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

In Windows, in the 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 correct, 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 is  D so I used D: , you can use C: or E:

If you want to learn more about SQL, Check out this SQL training online by Intellipaat.

For more information visit :