ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no )

Question

I'm trying to install queXS cati app on my Ubuntu desktop and I installed MySQL server and PHP 5 and I cannot login into MySQL server as root without password:

mysql -u root 

it says

ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no )

But it's okay when I enter mysql -u root -p

I can't figure out what the problem is.

Answer 1

Add switch -p for password based login:

mysql -u root -p

That is the normal behaviour. You set a root password for your database so from now on you can't access it without password. That is why it reports:

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

Obviously when you give the password with the -p switch you succeed.

Answer 2

In simple words your "root" session do not know password to mysql root user.

If you want to make easier to access your mysql

create .my.cnf in /root/

and put in it

[mysqladmin]
 user = root
 password = mysqlrootpassword
[mysql]
 user = root
 password = mysqlrootpassword
[mysqldump]
 user = root
 password = mysqlrootpassword

where offcourse mysqlrootpassword is your password for mysql's root password so when you execute mysql it uses this password

Remeber about safety of this file - put secure rights, so nobody on your server can read it!

Answer 3

Login to webmin and under servers, access the mySQLdatabase server.You will then be able to set the (user) password provided you have:

mysql -u (**user**) -p < /usr/share/doc/rsyslog-mysql-5.8.10/createDB.sql.

The web gui is easy but to be secure use the terminal.

cheers.