MySQL远程连接

[mysqld]

bind-address = 0.0.0.0 # 表示允许任何主机登陆

MySQL port=3306 # 表示MySQL运行端口为3306

 

admin用户对应的host不为%，则修改用户权限

mysql> GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY 'adminpwd' WITH GRANT OPTION;

Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.00 sec)

import pymysql

conn = pymysql.connect(host="192.168.9.9", port=3306, user="admin", passwd="pwd", db="mysql", charset="utf8")
cur = conn.cursor()
sql = "select Host,User from user"
cur.execute(sql)
results = cur.fetchall()