Re: MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Posted by: Filipe Silva
Date: November 29, 2018 11:19AM

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.

Options: ReplyQuote

Written By
Re: MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
November 29, 2018 11:19AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.