Ubuntu – Mariadb non-root user

mariadbMySQLroot

I have installed mariadb and when as a Linux root user, I can run mysql command to access the database. But when I try to login as a normal Linux user and run mysql -u root -p, I am getting error:

ERROR 1698 (28000): Access denied for user 'root'@'localhost'.

I tried several methods like reset password for the mysql root user, but no use.

Any help will be great.

Best Answer

I had the same problem, it was caused by a "plugin" value in "mysql.user" table.

Have you tried with this answer: https://askubuntu.com/a/636579/299538

Here is an explanation for that: https://superuser.com/a/1071043/592085

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