程式小試身手

伺服端:

MySQL 5.7 Command Line Client輸入指令

mysql>GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
mysql>GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.6'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

mysql>FLUSH PRIVILEGES;

mysql>EXIT;

重新啟動MySQL(注意防火牆要可通過3306)

客戶端:

db = pymysql.connect("IP","myuser","mypassword","db_name")

cursor = db.cursor()