Re: MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[Filipe Silva]

Hi Willians,

Assuming that the weird concatenation in the `password` is a mistake in your reply here, I would recommend you to check what password plugin do you have for the user `root` (select user, host, plugin, ssl_type from mysql.user), then try to connect using a mysql client using the option --protocol=TCP to avoid using unix sockets or so. The `ssl_type` will tell you if this user requires secure connections in order to authenticate or not.

If this works and the mysql client is reading this same my.cnf, it means that it is not using secure connections. In that case you could also try adding the option `sslMode=DISABLED` in your connection string to try to replicate the same conditions.

Please share your findings. We may be able to help you some more if you provide more details about your setup.