Access denied for user 'root@localhost' (using password:NO)

Question

I am attempting to install a network management package called cacti onto Ubuntu running under Windows Virtual PC. I attempted to install MySQL as it is one of cacti's dependencies. I can install and start the MySQL server, but whenever I try to access it in any other way, such as to change the password, I get the error message Access denied for user 'root@localhost' (using password:NO). I would like to know what is causing this and how to fix it.

Edit: (just in case my comments are not visible) The answers from HD and Devin Ceartas did not work for me.

I seem to get a connection and then it says Connection closed by foreign host — murgatroid99, Aug 19 '09 at 15:27

score 7 · Accepted Answer · answered Aug 19 '09 at 15:26

7

You might try reseting the password with these instructions.

answered Aug 19 '09 at 15:26

Kyle Brandt

83,619
74
305
448

score 2 · Answer 2 · answered Aug 19 '09 at 15:03

2

You're trying to connect to the MySQL server without a password. If you forgot it, you could try with:

sudo dpkg-reconfigure mysql-server

A dialog box will ask you for a new root user password. If you're connecting with the mysql client you need to try:

mysql -p

This command will ask you for the password, you enter before.

answered Aug 19 '09 at 15:03

hdanniel

4,293
23
25

When I tried the first, nothing happened after I put in my sudo password. When I tried the second, it gave me "Access denied for user 'root@localhost' (using password:YES)." I do not remember ever setting a root password – murgatroid99 Aug 19 '09 at 15:10
Which version of mysql-server have you installed? – hdanniel Aug 19 '09 at 15:16
How do I find this out? – murgatroid99 Aug 19 '09 at 15:18
dpkg -l | grep -i mysql-server – hdanniel Aug 19 '09 at 15:24
version 5.0.51a – murgatroid99 Aug 19 '09 at 15:25
Try sudo dpkg-reconfigure mysql-server-5.0 . Also in ubuntu, there is an admin user you can find it in /etc/mysql/debian.cnf (with the password) – hdanniel Aug 19 '09 at 15:29

score 1 · Answer 3 · answered Aug 19 '09 at 15:20

1

If you have never set a root password for MySQL, and you are in a fresh install normally the server does not require a password at all for connecting as root.
To setup root password for first time, use mysqladmin command at shell prompt as follows:


$ mysqladmin -u root password NEWPASSWORD

However, if you want to change (or update) a root password:


$ mysqladmin -u root -p'OLDPASSWORD' password NEWPASSWORD

If you lose the mysql server password you can use dpkg-reconfigure.

answered Aug 19 '09 at 15:20

Ali Mezgani

3,850
2
24
36

When I do this I get: mysqladmin: connect to server at 'localhost' failed Access denied for user 'root@localhost' (using password:NO) – murgatroid99 Aug 19 '09 at 15:22
mean that the root password was set, if you have root privilege please refer to ~/.mysql_history file, it must contain the history of sql commands – Ali Mezgani Aug 19 '09 at 18:12

score 0 · Answer 4 · edited Nov 26 '12 at 22:30

0

This is wrong:

shell> mysqladmin --user=root create cacti

Instead, create the MySQL database:

shell> mysqladmin --user=root --password create cacti

then type your password for the mysql root user.

edited Nov 26 '12 at 22:30

Michael Hampton

244,070
43
506
972

answered May 20 '11 at 09:59

Magikon

1

Access denied for user 'root@localhost' (using password:NO)

4 Answers4

Linked