dbeaver mysql access denied

Question

Can anyone tell me why I got an alert with the access denied error? I tried to create a mysql database and I confidently sure I entered the correct password for root yet I still got this error.

However, based on the mysql documentation for troubleshooting, my error specified that I did not enter the correct password which in fact I did not.

Mysql documentation

https://dev.mysql.com/doc/refman/5.5/en/problems-connecting.html

Also , I tried to run this command sudo mysql -u root -pand it also show me the same error.

Here is the error

P.S Because my reputation is too low, I can't attach the full image.

Is your server running? If so, is it on the same computer where you are running this command? — JNevill, Jul 11 '18 at 15:41
`I confidently sure I entered the correct password....` how much confident you are about that? — Nimeshka Srimal, Jul 11 '18 at 17:44
During the process of reseting my password, I encounter this problem for mysql.service failed because the control process exited with error code. @JNevill. Can you help me with this? — Wolver Ing, Jul 16 '18 at 09:06

score 5 · Answer 1 · answered Nov 08 '20 at 06:54

5

might be check you are currently connect with the correct password plugin, use the following Command, SELECT user, authentication_string, plugin, host FROM mysql.user;

If your are login with root, check whether plugin is "mysql_native_password" if not, change as it is with the following command.

ALTER USER 'root'@'localhost IDENTIFIED WITH mysql_native_password BY 'Password@123'

answered Nov 08 '20 at 06:54

Eranda J.

490
5
7

This is the correct answer Followed your instructions and it worked!!! Thank you. – lemmy njaria Mar 21 '22 at 07:41

score 1 · Answer 2 · answered Apr 04 '21 at 09:31

You may get this error when your mysqld is configured to accept connection only from localhost.

In such case, you need to modify bind-address property in /etc/mysql/mysql.conf.d/mysqld.cnf. You can allow only your ip or from the whole internet(0.0.0.0).

Make sure to restart the mysql server.

sudo systemctl restart mysql.

That's not it. You also need to allow connection on port 3306 using commands like ufw or iptables.

score 1 · Answer 3 · answered Feb 13 '22 at 15:02

I had this problem on Beekeeper and DBeaver. It was driving me INSANE. I literally copied the password and was testing the connections manually and it was working perfectly. Annoyingly this server was working perfectly with MySQL workbench on Windows before I migrated over to Fedora.

So I needed to set the "SSH" section so that it would log me in to the other device. That test connection worked perfectly. But STILL no success. "Password failure" an incredibly inaccurate error message...

Turns out after enabling the SSH connection I forgot to change the "Server host" variable from it's IP (192...) to 'localhost'. Now it works perfectly.

score 1 · Answer 4 · answered Dec 19 '22 at 17:08

For anyone struggling with SSH tunnel. I found that sometimes 127.0.0.1 is not being translated back to localhost before privileges are being check.

Try setting up a grant for 127.0.0.1 with the following.

GRANT ALL PRIVILEGES ON *.* TO 'user'@`127.0.0.1`;

This did the trick for me.

score 0 · Answer 5 · edited Jun 20 '20 at 09:12

0

Please enter these configurations in connection window

edited Jun 20 '20 at 09:12

Community

1
1

answered Apr 02 '20 at 10:57

user2015398

536
4
10

might be check you are currently connect with the correct password plugin, use the following Command, – Eranda J. Nov 08 '20 at 06:31

score 0 · Answer 6 · edited Jun 25 '22 at 23:56

It Could be various things try this:

In main configuration username="root" password="YOUR_PASSWORD" As in no need to put the actual password, only copy "YOUR_PASSWORD"
If it still doesn´t work leave the database bank
Check that your IP address is added to the server permissions/security
Check that the DB is available and that public connection is allowed
If using Windows allow connections to the port 3306 on the Firewall Defender(control panel, security, firewall defender, advanced setting, add inbound rule, port, 3306, allow)

dbeaver mysql access denied

6 Answers6