0
2.1K
ViewsAccess denied for user 'root'@'localhost' in dbeaver
When I do a test connection in DBeaver in Ubuntu 18.04, I get an error:
Access denied for user 'root'@'localhost'
I do not understand how to solve this. I can connect to mysql in terminal by sudo mysql.
I have also left the database field empty.
3 answers
Answer question0
Experienced a similar issue. Maybe this advice will help you to solve the error. Your user’s password should not contain any special characters. In my case, ’~’ in password was the whole reason of problem.
0
It works with Mariadb too. You must check the syntax of step 3, in MariaDB is:
ALTER USER 'rot'@'localhost' IDENTIFIED VIA mysql_native_password USING PASSWORD('password');
Thanks @gasgen.
If this problem keeps happening to someone, the reason is that Ubuntu Mint (and other distros) no longer come with a 'blank' password by default. So, we need to reset it:
sudo mysql_secure_installation
Select the password level you want, write it, and then yes (Y) to all. Then:
sudo mysql
And execute (change the word password with the password you have written before):
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
That's all, now you can configure local DB in DBeaver with the new password. Hope this works for you.
0
If this problem keeps happening to someone, the reason is that Ubuntu, Mint (and other distros) they no longer come with a 'blank' password for default. So, we need to reset it:
sudo mysql_secure_installation
Select the password level you want, write it and then yes (Y) to all. Then:
sudo mysql
And execute (change the word password with the password you have written before):
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
That's all, now you can configure local DB in DBeaver with the new password. Hope this works for you.