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.

score 124 · Answer 1 · answered Jul 28 '15 at 06:17

124

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:

answered Jul 28 '15 at 06:17

Pratik Joshi

11,485
7
41
73

3

it is temporary solution, though it work nice. If you close the command prompt and reopen it . It will not work – Rajib Dec 10 '18 at 12:14
1

@Rajib permanant solution is given by the accepted answer(one with Green tick :) ) – Pratik Joshi Dec 10 '18 at 12:52

score 92 · Accepted Answer · edited Feb 15 '22 at 08:33

92

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

edited Feb 15 '22 at 08:33

Shahzad Barkati

2,532
6
25
33

answered May 07 '11 at 09:11

David Fells

6,678
1
22
34

@ David Fells...Thanks alot for ur prompt reply...i have remmoved bin from variable value...when i type mysql -version...it showing error like:C:\>mysql -version ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N O)....so where i went wrong...?? am novice in mysql...please dont mine ..if i ask simple questions.. – hari May 07 '11 at 09:24
2

If the above solution doesn't work, add `C:\Program Files\MySQL\MySQL Server 5.6\bin %MYSQL_HOME%\bin` to `Path` instead – Minh Triet Oct 16 '13 at 03:45
It's 2020 and FWIW, I had to use `C:\Program Files\MySQL\MySQL Server 5.7\bin\`` and `%MYSQL_HOME%\bin\`` to get it to work (Note the trailing '\'). I tried following the solution outlined above without the \ and with a ; , but the only thing that worked was with the \ – globalSchmidt Sep 03 '20 at 15:20

score 28 · Answer 3 · answered Nov 11 '14 at 14:09

28

MYSQL_HOME:

C:\Program Files\MySQL\MySQL Server 5.0

Path:

%MYSQL_HOME%\bin;

answered Nov 11 '14 at 14:09

Emmanuel Osimosu

5,625
2
38
39

score 15 · Answer 4 · edited Aug 28 '21 at 08:36

15

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.

edited Aug 28 '21 at 08:36

Sabito stands with Ukraine

4,271
8
34
56

answered Jun 10 '21 at 10:55

Hazlitt Vasudevan

151
1
2

This worked. Thank you. I put MySQL Server 8.0/bin instead of MySQL Server 8.025 – Eray T Aug 07 '21 at 17:22
You may need to restart as well. – Federico Baù May 30 '23 at 17:06

score 11 · Answer 5 · edited Dec 09 '21 at 12:54

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

score 4 · Answer 6 · answered Dec 10 '18 at 12:12

4

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

answered Dec 10 '18 at 12:12

Rajib

392
4
16

Yea just needs to add this address into the path of system environment , thanks – Hesam Moosapour Jul 25 '21 at 20:08

score 3 · Answer 7 · answered Jul 27 '22 at 15:49

3

You can fix in 3 steps

you have to change course by first > Copy file path

   *my path is E:\Program\xampp\mysql\bin*

next in CMD I write the followin

that

set path=%PATH%;set path=%PATH%;E:\Program\xampp\mysql\bin

Don't forget to change PATH

answered Jul 27 '22 at 15:49

khaled mohamed ram

61
4

score 2 · Answer 8 · answered Jan 10 '17 at 05:42

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.

What a great catch. This was driving me mad - thanks much! – Edward Mar 06 '21 at 07:36 — Edward, Mar 06 '21 at 07:36

score 2 · Answer 9 · edited Mar 25 '22 at 02:30

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

score 1 · Answer 10 · answered Oct 04 '21 at 07:23

1

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

answered Oct 04 '21 at 07:23

Swaleh Matongwa

698
9
16

score 0 · Answer 11 · answered Mar 11 '22 at 13:50

0

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

answered Mar 11 '22 at 13:50

sanuja

1

This does not provide an answer to the question. Once you have sufficient [reputation](https://stackoverflow.com/help/whats-reputation) you will be able to [comment on any post](https://stackoverflow.com/help/privileges/comment); instead, [provide answers that don't require clarification from the asker](https://meta.stackexchange.com/questions/214173/why-do-i-need-50-reputation-to-comment-what-can-i-do-instead). - [From Review](/review/late-answers/31266600) – geertjanvdk Mar 15 '22 at 06:12

score 0 · Answer 12 · edited Aug 20 '23 at 20:16

0

In my case changing the directory to

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

.\mysql.exe -u root -p

I have noticed no changes but when I wrote mysql.exe

It ran perfectly

edited Aug 20 '23 at 20:16

JayRizzo

3,234
3
33
49

answered Mar 26 '22 at 20:18

Abdullah Habashy

1

score 0 · Answer 13 · answered Jul 08 '22 at 06:40

0

If the error isn't solved after setting the system variables and path, check the path specified in User Variables. If the path is not set in user variables, add it. This worked for me.

answered Jul 08 '22 at 06:40

Sakshi Katara

1

1

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Jul 09 '22 at 06:18

Shivam Singh · Answer 14 · 2022-08-11T21:01:24.533

This worked for me(Windows):

Firstly in cmd type: where{space}MySQL{enter}--->It gives something like this: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
Add path=C:\Program Files\MySQL\MySQL Server 8.0\bin to System variable. How to set path to system variable ?
Close and restart your Command prompt. After that write from anywhere in cmd: mysql --version

It will give results: mysql Ver 8.0.28 for Win64 on x86_64 (MySQL Community Server - GPL)

score 0 · Answer 15 · answered Apr 12 '23 at 07:50

I read all answers above and its really confusing and harder sometimes if it will not work.

So If you want a runtime solution

just go to your MySQL path wherever it has been stored.
And open terminal. there is a bin folder.
Go to that folder by cd bin
Done ! now you can use MySQL in the terminal using mysql -u root -p

in my case, I have a path like this

C:\wamp65\bin\mysql\mysql8.0.31\bin

saee · Answer 16 · 2020-08-24T12:21:30.183

-1

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.

edited Aug 24 '20 at 12:21

answered Oct 27 '18 at 04:29

saee

433
1
3
15

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

16 Answers16

Linked