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

User · Answer

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

SO

I must update PATH like these HERE! all my software i usually used 1- I created folder called Programe Files 2- I install all my programe data in these folder 3-and then going to PATH and add it Dont 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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

MYSQL HOME   C  Program Files MySQL MySQL Server 5 0   Path    MYSQL HOME  bin

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

Examples related to mysql

Examples related to mysql-error-1064