View previous topic :: View next topic |
Author |
Message |
Beetle B. Guru
Joined: 01 Mar 2003 Posts: 524
|
Posted: Sat Jun 30, 2012 5:26 pm Post subject: mysql password issue [SOLVED - KINDA] |
|
|
At some point in the past, the MySql server won't let me log in. If I do:
Code: |
mysqldump --add-drop-table -h localhost -u root --password='mypass' somedb > somefile |
It says:
Code: |
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
|
It used to work in the past. In fact, I can log in with that password using phpMyAdmin.
It stopped working in the middle of February. The last time I updated mysql was in December. I suppose it's possible I didn't reboot till February. Is there any log of my reboots somewhere...?
Ideas? _________________ Beetle B.
Please update the table of equivalents.
A Firefox guide.
Last edited by Beetle B. on Tue Jul 03, 2012 4:35 am; edited 1 time in total |
|
Back to top |
|
|
audiodef Watchman
Joined: 06 Jul 2005 Posts: 6639 Location: The soundosphere
|
|
Back to top |
|
|
Beetle B. Guru
Joined: 01 Mar 2003 Posts: 524
|
Posted: Tue Jul 03, 2012 4:35 am Post subject: |
|
|
Your command didn't work.
phpMyAdmin shows that root has all the privileges:
http://i.imgur.com/4R0zk.png
In any case, I just modified the command to use the user of that DB and it worked. _________________ Beetle B.
Please update the table of equivalents.
A Firefox guide. |
|
Back to top |
|
|
audiodef Watchman
Joined: 06 Jul 2005 Posts: 6639 Location: The soundosphere
|
|
Back to top |
|
|
|