Menu
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.
828
by Archana Sreenivas | Feb 4, 2020. Oops!! Frustrated with ‘Access denied for user ‘root’@’localhost’ (using password yes) in MySQL? This error may occur due to many reasons which include insufficient privileges for the user to access the database, and when MySQL root password is wrong and so on. At Bobcares, we often get requests ...
If you get the “access denied” error, one way to solve it is by using sudo to log in to mysql and change the root password. Step 1: Open the command line on your system. Step 2: Open mysql using the sudo command: Step 3: Enter the password for this account.
Select the password level you want, write it and then yes (Y) to all. Then: And execute (change the word password with the password you have written before): That's all, now you can configure local DB in DBeaver with the new password. Hope this works for you.
When you install MySQL and try to access it on the local machine with the root user, the command you use is: mysql -u root -p. In most cases, you will receive the error message Access denied for user ‘root’@’localhost’. You can enable access for root using one MySQL command.
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.
186
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
