Ubuntu – ERROR 1045(28000) : Access denied for user ‘root@localhost’ (using password: no )

MySQLpermissions

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.

Best Answer

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.

Related Solutions

Ubuntu – MySQL Access denied for user ‘root’@’localhost’

If you're running n localhost, just type the command below in terminal:

mysql -u root -p

If you're using an external server, enter the host IP (xxx.xxx.xxx.xxx) as well:

mysql -hxxx.xxx.xxx.xxx -uroot -p

You will be prompted for your password, enter it and you will be able to access your MySQL prompt.

You can also look at this answer on how to reset your MySQL password.

Ubuntu – MySQL – access denied for user root@localhost

You can try the regular recovery procedure:

Stop MySQL service
Run the service using:
```
sudo mysqld_safe --skip-grant-tables &
```
Connect (password won't be required):
```
mysql -uroot
```
Revert your changes (be careful this time and check with select what is the current state, host should be 202.54.10.20):
```
use mysql;
update user set Host='localhost' where user='root';
flush privileges;
```
Restart MySQL the regular way

Best Answer

Related Solutions

Ubuntu – MySQL Access denied for user ‘root’@’localhost’

Ubuntu – MySQL – access denied for user root@localhost

Related Question