Windows cannot remotely access liunx's mysql solution (version 8.0.27)
1. After installing mysql, it is found that the windows cannot be accessed normally, and the error is as follows:
Whether it is navicat software, or use python's pymsql to connect
1. The navicat software is as follows: "Access denied for user 'root'@'192.168.37.1' (using password: YES)"
2. pycharm reports the following error: pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'192.168.37.1' (using password: YES)")
Local but can connect normally:
Second, the solution:
1. Refer to the previous article to recharge mysql password settings
https://www.cnblogs.com/mrwhite2020/p/15522071.html
2. The statement in the sixth step will modify the permissions.
mysql> ALTER USER ' root ' @ ' % ' IDENTIFIED BY ' Mrwhite@2021 ' ;
3. Follow the next steps to continue
Both navicat and pymysql can be connected normally:
atorvastatin 40mg cheap & lt;a href="https://lipiws.top/"& gt;buy atorvastatin& lt;/a& gt; lipitor 10mg pill
Ibgmds
2024-03-08