• notice
  • Congratulations on the launch of the Sought Tech site

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)"

1767782-20220619173509780-473022118.png

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:

 


Tags

Technical otaku

Sought technology together

Related Topic

1 Comments

author

atorvastatin 40mg cheap & lt;a href="https://lipiws.top/"& gt;buy atorvastatin& lt;/a& gt; lipitor 10mg pill

Ibgmds

2024-03-08

Leave a Reply

+