According to you before some of the summary, will have two accounts root password authentication with Adam (i.e., the plugin fields) modified to mysql_native_password, but at this time the following problems:
Using root can normal connection
> The db=pymysql. Connect (" 127.0.0.1 ", "root", "password", "exercise_1")
>

But problems when using other accounts will be:
> Db=pymysql. Connect (" localhost ", "Adam", "Adam" and "exercise_1");

Error: pymysql. Err. OperationalError: (1045, "Access denied for user 'Adam' @ 'localhost' (using password: NO)")

Has been troubled for a long time, could you tell me where is the problem?

CodePudding user response:

1, password mistake,
2, the user didn't access to the database,

CodePudding user response:

reference 1st floor wmxcn2000 response:

1, password mistake,
2, the user didn't access to the database,

These problems are considered, not these reasons, the unloading mysql8 versions, changed to 5.7 then there will be no problems related to the...

CodePudding user response:

The mysql database user table corresponding to the admin host to try %

CodePudding user response:

This kind of circumstance, need you to log on to the mysql, the permission to let go,,

Because mysql kinds of permissions, is not only a user name + password, and when you log into mysql, the IP address of the machine

CodePudding user response:

reference 4 floor yupeigu response:

this kind of circumstance, need you log into mysql, the permission to let go,,

Because mysql kinds of permissions, is not only a user name + password, and when you log into mysql, the IP address of the machine

It is perhaps for this reason, however, I don't have this problem after installed version 5.7...

CodePudding user response:

https://blog.csdn.net/dandanben/article/details/88964109

CodePudding user response:

User table instead of the host or % is likely to be empty

CodePudding user response:

Mysql8 control of the permissions changes happened