mysql is not recognised as an internal or external command,operable program or batch
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.
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:
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