In the local IP using the mysql command - h - 3307 - P uusername - ppassword this command to connect to the remote server ERROR, ERROR 1045 (28000) : Access denied for user 'mersea_w' @ '10.6.19.35:53597' (using password: Yes),
Local mysql version after demotion to the latest version 5.7, to use the command can be the connection is successful, eliminate command error and the server configuration problem,
Should be mysql8 to mysql5.6 connection configuration problems, may be associated with password encryption? Ask any great god know is what reason,
Should modify my. CNF related configuration?
CodePudding user response:
[mysqld]Default_authentication_plugin=mysql_native_password
CodePudding user response:
1/f, positive solution