Ubuntu
mysql-dfsg-5.1 package

Cannot access mySQL - password issue

Asked by Esther Strom

I installed xampp and am now trying to access mySQL, either via terminal or the phpMyAdmin interface. I did set a password during the install, but apparently it didn't take, and now no matter what I do, I can't log in.

When I try just running mysql from the terminal, here's what I get:

esther@esther-linux:~$ mysql
ERROR 1045 (28000): Access denied for user 'esther'@'localhost' (using password: NO)

I've also tried adding the -p flag for password, and get this:

esther@esther-linux:~$ mysql -p
Enter password:
ERROR 1045 (28000): Access denied for user 'esther'@'localhost' (using password: YES)

I'm positive that the password I'm entering is the correct one. Is there a way to reset the password? (I've also tried running sudo mysql so that it would log me in as root, but I still get the same errors.)

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu mysql-dfsg-5.1 Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
David Mawdsley (dm-madmod) said : 		#1

You may be able to get some help from https://help.ubuntu.com/community/MysqlPasswordReset

Revision history for this message
Esther Strom (esthermstrom-gmail) said : 		#2

Thanks. I tried that process, but at the following line:

mysql> SET PASSWORD FOR root@'localhost' = PASSWORD('password');

I get this error:

ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

Revision history for this message
David Mawdsley (dm-madmod) said : 		#3

I don't know what to advise on this error. However, I searched for 'mysql ERROR 1290' and saw among others a forum page that might be useful at http://www.bigresource.com/MYSQL-Error-1290-server-running-with-skip-grant-tables-COWy2XXa.html

Another page from the search gave a general error page at http://phpro.org/articles/MySQL-Error-Codes.html

That's all I can help you with on this.

Revision history for this message
Ankit Singhaniya (ankit-singhaniyaz) said : 		#5

try this:
$mysql -u root -p
password:

The password you created was for your roor user not your current administrator/limited account. So manually specify the user and you will be fine. Hope that helps.

Can you help with this problem?

Provide an answer of your own, or ask Esther Strom for more information if necessary.

To post a message you must log in.