Re: ERROR 1045 (28000) Access denied for user

[James Preston]

OK, went back to using mysql_native_password and turned off require_secure_transport as a test that basic remote connection still worked. I am able to connect using mysql_native_password and no SSL (YEA!!!). Turning on SSL, require_secure_transport=on with mysql_native_password and able to connect using SSL. So SSL seems to be solved. However turning on caching_sha2_password causes Access denied.

I had created a problem in the mysql.user table by adding the same user with the host set to ip address in attempting to solve connection problem.

'user1'@'%' AND 'user1'@'xxx.xxx.xxx.xxx' in user table. Dropped 'user1'@'%'.

So remaining problem is caching_sha2_password.