mysqldump: Got error: 1045: Access denied for user (using password: YES) when trying to connect serverbrew install mysql on mac osMySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: NO)error: 1045: Access denied for user 'user'@'123.10.123.123' (using password: NO) when trying to connectMySQL Access Denied #1045mysqldump Error 1045 Access denied despite correct passwords etcError 1045 Access denied for user 'root'@'localhost' (using password: NO)) in connectmysqldump: Got error: 1045: Access denied when using password in my.cnf1045 - Access denied for user after executing queryphpMyAdmin access denied error
Hexagonal Grid Filling
Do Rabbis admit emotional involvement in their rulings?
Integral with DiracDelta. Can Mathematica be made to solve this?
Probability of taking balls without replacement from a bag question
I might have messed up in the 'Future Work' section of my thesis
Why do unstable nuclei form?
A Latin text with dependency tree
Has there been evidence of any other gods?
if i accidentally leaked my schools ip address and someone d doses my school am i at fault
Publishing an article in a journal without a related degree
Best species to breed to intelligence
Do Monks gain the 9th level Unarmored Movement benefit when wearing armor or using a shield?
Is there an idiom that means "revealing a secret unintentionally"?
How can I test a shell script in a "safe environment" to avoid harm to my computer?
How long can fsck take on a 30 TB volume?
What's the difference between "ricochet" and "bounce"?
how to find out if there's files in a folder and exit accordingly (in KSH)
Is there a need for better software for writers?
How to get MAX value using SOQL when there are more than 50,000 rows
What can cause an unfrozen indoor copper drain pipe to crack?
How to handle DM constantly stealing everything from sleeping characters?
Gain of Non-Inverting Amplifier Does Not vary with Resistor Values
How is Arya still alive?
Are there vaccine ingredients which may not be disclosed ("hidden", "trade secret", or similar)?
mysqldump: Got error: 1045: Access denied for user (using password: YES) when trying to connect server
brew install mysql on mac osMySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: NO)error: 1045: Access denied for user 'user'@'123.10.123.123' (using password: NO) when trying to connectMySQL Access Denied #1045mysqldump Error 1045 Access denied despite correct passwords etcError 1045 Access denied for user 'root'@'localhost' (using password: NO)) in connectmysqldump: Got error: 1045: Access denied when using password in my.cnf1045 - Access denied for user after executing queryphpMyAdmin access denied error
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I use the following query when I want to copy a MySQL database:
mysqldump --opt -h HOSTNAME -u USERNAME -p PASSWORD DATABASENAME| gzip > name.sql
But I get this error:
mysqldump: Got error: 1045: Access denied for user (using password: YES) when trying to connect server
When I was looking for a solution I found a lot of answers, but in every case the problem appears on localhost - I have this problem in my hosting...could anyone help?
mysql
edited Jun 22 '17 at 15:57
vich
6,577134258
asked Jun 22 '17 at 15:47
chichi
813
add a comment |
I use the following query when I want to copy a MySQL database:
mysqldump --opt -h HOSTNAME -u USERNAME -p PASSWORD DATABASENAME| gzip > name.sql
But I get this error:
mysqldump: Got error: 1045: Access denied for user (using password: YES) when trying to connect server
When I was looking for a solution I found a lot of answers, but in every case the problem appears on localhost - I have this problem in my hosting...could anyone help?
mysql
edited Jun 22 '17 at 15:57
vich
6,577134258
asked Jun 22 '17 at 15:47
chichi
813
Sorry for my English, as you can see I'm not expert :(
– chi
Jun 22 '17 at 16:08
add a comment |
I use the following query when I want to copy a MySQL database:
mysqldump --opt -h HOSTNAME -u USERNAME -p PASSWORD DATABASENAME| gzip > name.sql
But I get this error:
mysqldump: Got error: 1045: Access denied for user (using password: YES) when trying to connect server
When I was looking for a solution I found a lot of answers, but in every case the problem appears on localhost - I have this problem in my hosting...could anyone help?
mysql
edited Jun 22 '17 at 15:57
vich
6,577134258
asked Jun 22 '17 at 15:47
chichi
813
I use the following query when I want to copy a MySQL database:
mysqldump --opt -h HOSTNAME -u USERNAME -p PASSWORD DATABASENAME| gzip > name.sql
But I get this error:
mysqldump: Got error: 1045: Access denied for user (using password: YES) when trying to connect server
When I was looking for a solution I found a lot of answers, but in every case the problem appears on localhost - I have this problem in my hosting...could anyone help?
mysql
mysql
edited Jun 22 '17 at 15:57
vich
6,577134258
asked Jun 22 '17 at 15:47
chichi
813
edited Jun 22 '17 at 15:57
vich
6,577134258
asked Jun 22 '17 at 15:47
chichi
813
edited Jun 22 '17 at 15:57
vich
6,577134258
edited Jun 22 '17 at 15:57
vich
6,577134258
edited Jun 22 '17 at 15:57
vich
6,577134258
6,577134258
asked Jun 22 '17 at 15:47
chichi
813
asked Jun 22 '17 at 15:47
chichi
813
asked Jun 22 '17 at 15:47
chichi
813
813
Sorry for my English, as you can see I'm not expert :(
– chi
Jun 22 '17 at 16:08
add a comment |
Sorry for my English, as you can see I'm not expert :(
– chi
Jun 22 '17 at 16:08
Sorry for my English, as you can see I'm not expert :(
– chi
Jun 22 '17 at 16:08
Sorry for my English, as you can see I'm not expert :(
– chi
Jun 22 '17 at 16:08
add a comment |
2 Answers
2
active
oldest
votes
Try to remove the space between -p and PASSWORD
mysqldump --opt -h 127.0.0.1 -u root -proot DATABASENAME| gzip > name.sql
User: root
Password: root
The password parameter must be concatenated to the parameter.
Anyway, check your credentials too!
PS: name.sql should be name.sql.zip
answered Jun 22 '17 at 15:57
RyosakuRyosaku
366313
yeah, remove space works!!!
– chi
Jun 22 '17 at 16:09
add a comment |
There could be some special char like:
$ & ! [ ] < > `
on your password. test with a simple password if it works then increase the password complexity
The other way to test is add -p on your command which will prompt the password. if you provide on prompt it will work for sure if the password is correct.
mysqldump -uroot -h localhost dbname -p | gzip -c > /backup/ac.gz
edited Jul 31 '18 at 1:07
Stephen Rauch
31k153862
answered Jul 31 '18 at 0:43
Kannan ChandrasekaranKannan Chandrasekaran
1
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%2f44704094%2fmysqldump-got-error-1045-access-denied-for-user-using-password-yes-when-tr%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try to remove the space between -p and PASSWORD
mysqldump --opt -h 127.0.0.1 -u root -proot DATABASENAME| gzip > name.sql
User: root
Password: root
The password parameter must be concatenated to the parameter.
Anyway, check your credentials too!
PS: name.sql should be name.sql.zip
answered Jun 22 '17 at 15:57
RyosakuRyosaku
366313
yeah, remove space works!!!
– chi
Jun 22 '17 at 16:09
add a comment |
Try to remove the space between -p and PASSWORD
mysqldump --opt -h 127.0.0.1 -u root -proot DATABASENAME| gzip > name.sql
User: root
Password: root
The password parameter must be concatenated to the parameter.
Anyway, check your credentials too!
PS: name.sql should be name.sql.zip
answered Jun 22 '17 at 15:57
RyosakuRyosaku
366313
yeah, remove space works!!!
– chi
Jun 22 '17 at 16:09
add a comment |
Try to remove the space between -p and PASSWORD
mysqldump --opt -h 127.0.0.1 -u root -proot DATABASENAME| gzip > name.sql
User: root
Password: root
The password parameter must be concatenated to the parameter.
Anyway, check your credentials too!
PS: name.sql should be name.sql.zip
answered Jun 22 '17 at 15:57
RyosakuRyosaku
366313
Try to remove the space between -p and PASSWORD
mysqldump --opt -h 127.0.0.1 -u root -proot DATABASENAME| gzip > name.sql
User: root
Password: root
The password parameter must be concatenated to the parameter.
Anyway, check your credentials too!
PS: name.sql should be name.sql.zip
answered Jun 22 '17 at 15:57
RyosakuRyosaku
366313
answered Jun 22 '17 at 15:57
RyosakuRyosaku
366313
answered Jun 22 '17 at 15:57
RyosakuRyosaku
366313
answered Jun 22 '17 at 15:57
RyosakuRyosaku
366313
366313
yeah, remove space works!!!
– chi
Jun 22 '17 at 16:09
add a comment |
yeah, remove space works!!!
– chi
Jun 22 '17 at 16:09
yeah, remove space works!!!
– chi
Jun 22 '17 at 16:09
yeah, remove space works!!!
– chi
Jun 22 '17 at 16:09
add a comment |
There could be some special char like:
$ & ! [ ] < > `
on your password. test with a simple password if it works then increase the password complexity
The other way to test is add -p on your command which will prompt the password. if you provide on prompt it will work for sure if the password is correct.
mysqldump -uroot -h localhost dbname -p | gzip -c > /backup/ac.gz
edited Jul 31 '18 at 1:07
Stephen Rauch
31k153862
answered Jul 31 '18 at 0:43
Kannan ChandrasekaranKannan Chandrasekaran
1
add a comment |
There could be some special char like:
$ & ! [ ] < > `
on your password. test with a simple password if it works then increase the password complexity
The other way to test is add -p on your command which will prompt the password. if you provide on prompt it will work for sure if the password is correct.
mysqldump -uroot -h localhost dbname -p | gzip -c > /backup/ac.gz
edited Jul 31 '18 at 1:07
Stephen Rauch
31k153862
answered Jul 31 '18 at 0:43
Kannan ChandrasekaranKannan Chandrasekaran
1
add a comment |
There could be some special char like:
$ & ! [ ] < > `
on your password. test with a simple password if it works then increase the password complexity
The other way to test is add -p on your command which will prompt the password. if you provide on prompt it will work for sure if the password is correct.
mysqldump -uroot -h localhost dbname -p | gzip -c > /backup/ac.gz
edited Jul 31 '18 at 1:07
Stephen Rauch
31k153862
answered Jul 31 '18 at 0:43
Kannan ChandrasekaranKannan Chandrasekaran
1
There could be some special char like:
$ & ! [ ] < > `
on your password. test with a simple password if it works then increase the password complexity
The other way to test is add -p on your command which will prompt the password. if you provide on prompt it will work for sure if the password is correct.
mysqldump -uroot -h localhost dbname -p | gzip -c > /backup/ac.gz
edited Jul 31 '18 at 1:07
Stephen Rauch
31k153862
answered Jul 31 '18 at 0:43
Kannan ChandrasekaranKannan Chandrasekaran
1
edited Jul 31 '18 at 1:07
Stephen Rauch
31k153862
edited Jul 31 '18 at 1:07
Stephen Rauch
31k153862
edited Jul 31 '18 at 1:07
Stephen Rauch
31k153862
31k153862
answered Jul 31 '18 at 0:43
Kannan ChandrasekaranKannan Chandrasekaran
1
answered Jul 31 '18 at 0:43
Kannan ChandrasekaranKannan Chandrasekaran
1
answered Jul 31 '18 at 0:43
Kannan ChandrasekaranKannan Chandrasekaran
1
1
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%2f44704094%2fmysqldump-got-error-1045-access-denied-for-user-using-password-yes-when-tr%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
Sorry for my English, as you can see I'm not expert :(
– chi
Jun 22 '17 at 16:08