mysql is not recognised as an internal or external command,operable program or batch
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
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 FilesMySQLMySQL Server 5.0bin
In Windows, system variables I had set the path as:
- variable name:
MYSQL_HOME
- variable value:
C:Program FilesMySQLMySQL Server 5.0bin
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.
mysql mysql-error-1064
add a comment |
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 FilesMySQLMySQL Server 5.0bin
In Windows, system variables I had set the path as:
- variable name:
MYSQL_HOME
- variable value:
C:Program FilesMySQLMySQL Server 5.0bin
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.
mysql mysql-error-1064
add a comment |
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 FilesMySQLMySQL Server 5.0bin
In Windows, system variables I had set the path as:
- variable name:
MYSQL_HOME
- variable value:
C:Program FilesMySQLMySQL Server 5.0bin
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.
mysql mysql-error-1064
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 FilesMySQLMySQL Server 5.0bin
In Windows, system variables I had set the path as:
- variable name:
MYSQL_HOME
- variable value:
C:Program FilesMySQLMySQL Server 5.0bin
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.
mysql mysql-error-1064
mysql mysql-error-1064
edited Feb 10 '18 at 16:29
Community♦
11
11
asked May 7 '11 at 9:09
harihari
2561816
2561816
add a comment |
add a comment |
7 Answers
7
active
oldest
votes
MYSQL_HOME variable value:C:Program FilesMySQLMySQL Server 5.0bin
%MYSQL_HOME%bin
See the problem? This resolves to a path of C:Program FilesMySQLMySQL Server 5.0binbin
@ 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 7 '11 at 9:24
1
If the above solution doesn't work, addC:Program FilesMySQLMySQL Server 5.6bin %MYSQL_HOME%bin
toPath
instead
– Minh Triet
Oct 16 '13 at 3:45
add a comment |
Simply type in command prompt :
set path=%PATH%;D:xamppmysqlbin;
Here my path started from D so I used D: , you can use C: or E:
1
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 C Joshi
Dec 10 '18 at 12:52
add a comment |
MYSQL_HOME:
C:Program FilesMySQLMySQL Server 5.0
Path:
%MYSQL_HOME%bin;
add a comment |
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 FilesMySQLMySQL 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.
add a comment |
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%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;G:HashiCorpVagrantbin;G:xamppphp;G:xamppmysqlbin;G:Program Files (x86)herokubin;G:Program Files (x86)Gitbin;G:Program Files (x86)composer;G:Program Files (x86)nodejs;G:Program Files (x86)Sublime Text 3;G:Program Files (x86)Microsoft VS Codebin;G:Program Files (x86)cygwin64bin
add a comment |
In my case, I resolved it by adding this C:xamppmysqlbin
path in system variables
then restarted cmd
.
Note: Click me if you don't know how to set the path and system variables.
add a comment |
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:xamppmysqlbin;
and it is working nice
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f5920136%2fmysql-is-not-recognised-as-an-internal-or-external-command-operable-program-or-b%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
7 Answers
7
active
oldest
votes
7 Answers
7
active
oldest
votes
active
oldest
votes
active
oldest
votes
MYSQL_HOME variable value:C:Program FilesMySQLMySQL Server 5.0bin
%MYSQL_HOME%bin
See the problem? This resolves to a path of C:Program FilesMySQLMySQL Server 5.0binbin
@ 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 7 '11 at 9:24
1
If the above solution doesn't work, addC:Program FilesMySQLMySQL Server 5.6bin %MYSQL_HOME%bin
toPath
instead
– Minh Triet
Oct 16 '13 at 3:45
add a comment |
MYSQL_HOME variable value:C:Program FilesMySQLMySQL Server 5.0bin
%MYSQL_HOME%bin
See the problem? This resolves to a path of C:Program FilesMySQLMySQL Server 5.0binbin
@ 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 7 '11 at 9:24
1
If the above solution doesn't work, addC:Program FilesMySQLMySQL Server 5.6bin %MYSQL_HOME%bin
toPath
instead
– Minh Triet
Oct 16 '13 at 3:45
add a comment |
MYSQL_HOME variable value:C:Program FilesMySQLMySQL Server 5.0bin
%MYSQL_HOME%bin
See the problem? This resolves to a path of C:Program FilesMySQLMySQL Server 5.0binbin
MYSQL_HOME variable value:C:Program FilesMySQLMySQL Server 5.0bin
%MYSQL_HOME%bin
See the problem? This resolves to a path of C:Program FilesMySQLMySQL Server 5.0binbin
edited May 29 '17 at 12:56
Kumar Rakesh
2,29321236
2,29321236
answered May 7 '11 at 9:11
David FellsDavid Fells
5,2141731
5,2141731
@ 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 7 '11 at 9:24
1
If the above solution doesn't work, addC:Program FilesMySQLMySQL Server 5.6bin %MYSQL_HOME%bin
toPath
instead
– Minh Triet
Oct 16 '13 at 3:45
add a comment |
@ 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 7 '11 at 9:24
1
If the above solution doesn't work, addC:Program FilesMySQLMySQL Server 5.6bin %MYSQL_HOME%bin
toPath
instead
– Minh Triet
Oct 16 '13 at 3:45
@ 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 7 '11 at 9:24
@ 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 7 '11 at 9:24
1
1
If the above solution doesn't work, add
C:Program FilesMySQLMySQL Server 5.6bin %MYSQL_HOME%bin
to Path
instead– Minh Triet
Oct 16 '13 at 3:45
If the above solution doesn't work, add
C:Program FilesMySQLMySQL Server 5.6bin %MYSQL_HOME%bin
to Path
instead– Minh Triet
Oct 16 '13 at 3:45
add a comment |
Simply type in command prompt :
set path=%PATH%;D:xamppmysqlbin;
Here my path started from D so I used D: , you can use C: or E:
1
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 C Joshi
Dec 10 '18 at 12:52
add a comment |
Simply type in command prompt :
set path=%PATH%;D:xamppmysqlbin;
Here my path started from D so I used D: , you can use C: or E:
1
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 C Joshi
Dec 10 '18 at 12:52
add a comment |
Simply type in command prompt :
set path=%PATH%;D:xamppmysqlbin;
Here my path started from D so I used D: , you can use C: or E:
Simply type in command prompt :
set path=%PATH%;D:xamppmysqlbin;
Here my path started from D so I used D: , you can use C: or E:
answered Jul 28 '15 at 6:17
Pratik C JoshiPratik C Joshi
9,20153060
9,20153060
1
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 C Joshi
Dec 10 '18 at 12:52
add a comment |
1
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 C Joshi
Dec 10 '18 at 12:52
1
1
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
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
1
@Rajib permanant solution is given by the accepted answer(one with Green tick :) )
– Pratik C Joshi
Dec 10 '18 at 12:52
@Rajib permanant solution is given by the accepted answer(one with Green tick :) )
– Pratik C Joshi
Dec 10 '18 at 12:52
add a comment |
MYSQL_HOME:
C:Program FilesMySQLMySQL Server 5.0
Path:
%MYSQL_HOME%bin;
add a comment |
MYSQL_HOME:
C:Program FilesMySQLMySQL Server 5.0
Path:
%MYSQL_HOME%bin;
add a comment |
MYSQL_HOME:
C:Program FilesMySQLMySQL Server 5.0
Path:
%MYSQL_HOME%bin;
MYSQL_HOME:
C:Program FilesMySQLMySQL Server 5.0
Path:
%MYSQL_HOME%bin;
answered Nov 11 '14 at 14:09
eosimosueosimosu
1,3431627
1,3431627
add a comment |
add a comment |
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 FilesMySQLMySQL 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.
add a comment |
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 FilesMySQLMySQL 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.
add a comment |
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 FilesMySQLMySQL 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.
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 FilesMySQLMySQL 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.
answered Jan 10 '17 at 5:42
SahasraSahasra
111
111
add a comment |
add a comment |
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%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;G:HashiCorpVagrantbin;G:xamppphp;G:xamppmysqlbin;G:Program Files (x86)herokubin;G:Program Files (x86)Gitbin;G:Program Files (x86)composer;G:Program Files (x86)nodejs;G:Program Files (x86)Sublime Text 3;G:Program Files (x86)Microsoft VS Codebin;G:Program Files (x86)cygwin64bin
add a comment |
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%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;G:HashiCorpVagrantbin;G:xamppphp;G:xamppmysqlbin;G:Program Files (x86)herokubin;G:Program Files (x86)Gitbin;G:Program Files (x86)composer;G:Program Files (x86)nodejs;G:Program Files (x86)Sublime Text 3;G:Program Files (x86)Microsoft VS Codebin;G:Program Files (x86)cygwin64bin
add a comment |
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%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;G:HashiCorpVagrantbin;G:xamppphp;G:xamppmysqlbin;G:Program Files (x86)herokubin;G:Program Files (x86)Gitbin;G:Program Files (x86)composer;G:Program Files (x86)nodejs;G:Program Files (x86)Sublime Text 3;G:Program Files (x86)Microsoft VS Codebin;G:Program Files (x86)cygwin64bin
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%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;G:HashiCorpVagrantbin;G:xamppphp;G:xamppmysqlbin;G:Program Files (x86)herokubin;G:Program Files (x86)Gitbin;G:Program Files (x86)composer;G:Program Files (x86)nodejs;G:Program Files (x86)Sublime Text 3;G:Program Files (x86)Microsoft VS Codebin;G:Program Files (x86)cygwin64bin
answered Nov 25 '18 at 8:37
Abu BakrAbu Bakr
155210
155210
add a comment |
add a comment |
In my case, I resolved it by adding this C:xamppmysqlbin
path in system variables
then restarted cmd
.
Note: Click me if you don't know how to set the path and system variables.
add a comment |
In my case, I resolved it by adding this C:xamppmysqlbin
path in system variables
then restarted cmd
.
Note: Click me if you don't know how to set the path and system variables.
add a comment |
In my case, I resolved it by adding this C:xamppmysqlbin
path in system variables
then restarted cmd
.
Note: Click me if you don't know how to set the path and system variables.
In my case, I resolved it by adding this C:xamppmysqlbin
path in system variables
then restarted cmd
.
Note: Click me if you don't know how to set the path and system variables.
answered Oct 27 '18 at 4:29
latifa saeelatifa saee
2171212
2171212
add a comment |
add a comment |
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:xamppmysqlbin;
and it is working nice
add a comment |
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:xamppmysqlbin;
and it is working nice
add a comment |
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:xamppmysqlbin;
and it is working nice
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:xamppmysqlbin;
and it is working nice
answered Dec 10 '18 at 12:12
RajibRajib
5919
5919
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f5920136%2fmysql-is-not-recognised-as-an-internal-or-external-command-operable-program-or-b%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown