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

MYSQL_HOME:

C:\Program Files\MySQL\MySQL Server 5.0

Path:

%MYSQL_HOME%\bin;

Here is what I DO on my PC, I install all software that I usually used in G: partition not C: if my operating system is fall (win 10), Do not need to reinstall them again and lose time, Then How windows work it update PATH automatic if you install any new program or piece of software,

SO

I must update PATH like these HERE! all the software I usually used 1- I created a folder called Program Files 2- I install all my programs data in this folder 3-and then going to PATH and add it Don't forget ;

%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;G:\HashiCorp\Vagrant\bin;G:\xampp\php;G:\xampp\mysql\bin;G:\Program Files (x86)\heroku\bin;G:\Program Files (x86)\Git\bin;G:\Program Files (x86)\composer;G:\Program Files (x86)\nodejs;G:\Program Files (x86)\Sublime Text 3;G:\Program Files (x86)\Microsoft VS Code\bin;G:\Program Files (x86)\cygwin64\bin

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

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

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

For User variable for user:

• Click Path ---> NEW ---> C:\Program Files\MySQL\MySQL Server 8.0.25\bin

• Click OK

• Now check with cmd (mysql -V)

  You may get a command like this

  mysql  Ver 8.0.25 for Win64 on x86_64 (MySQL Community Server - GPL)
  

You're DONE.

I am using xampp. For me best option is to change environment variables. Environment variable changing window is shared by @Abu Bakr in this thread

I change the path value as C:\xampp\mysql\bin; and it is working nice

In my case, it turned out to be a simple case of spacing.

Turns out, i had a space inserted after the last ; and before ""C:\Program Files\MySQL\MySQL Server 5.7" For this very simple reason, no matter what i did, MySql was still not being recognized.

Once i eliminated the spaces before and after path, it worked perfectly.

In retrospect, seems like a very obvious answer, but nobody's mentioned it anywhere.

Also, i'm new to this whole windows thing, so please excuse me if it sounds very simple.

If you use wamp server add C:\wamp64\bin\mysql\mysql5.7.31\bin to environment variables PATH

To make it easier to invoke MySQL programs in CMD, you can add the path name of the MySQL bin directory to your Windows system PATH environment variable:

follow the below link.

https://dev.mysql.com/doc/mysql-windows-excerpt/5.7/en/mysql-installation-windows-path.html

You only have to set path in the system variables and you are done with the job. Here I will show you step by step:

Step1: Go the start taskbar and write environment and click on the edit system environment option:

Step2: After clicking a dialog box namely System Properties Will occur like this:

Step3: Click on environment variables and then inside system variables in which there is written path, double click on path a new dialog box namely edit environment variables will be pop up as shown:

Then add the address of the MySql bin in windows C the path by clicking new path option, in my laptop MySql was here so added this path C:\Program Files\MySQL\MySQL Server 8.0\bin, thats it click ok and run on command prompt mysql --version command and it will show the actual version of mysql installed at your pc

In my case changing the directory to

cd C:\Program Files\MySQL\MySQL Server 8.0\bin

I have noticed no changes but when I wrote mysql

It ran perfectly

In my case, I resolved it by adding this path C:\xampp\mysql\bin to system variables path and then restarted pash/cmd.

Note: Click me if you don't know how to set the path and system variables.