close

伺服端:

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

arrow
arrow
    全站熱搜

    程式小試身手 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄