好記性真不如爛筆頭

修改mysql配置文件

本人 mysql5.7配置文件 /etc/mysql/mysql.conf.d/mysqld.cnf

bind-address = 0.0.0.0 # 所有地址都可以訪問

mysq用戶

root權(quán)限進入 mysql

GRANT ALL PRIVILEGES ON <數(shù)據(jù)庫>.* TO '<用戶>'@'<遠程ip>' IDENTIFIED BY '<密碼>' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON db_dev.* TO 'zqw'@'1.1.1.1' IDENTIFIED BY '12345' WITH GRANT OPTION;

FLUSH PRIVILEGES;

select Host, User, authentication_string from mysql.user ;

重啟mysql

sudo service mysql restart

防火墻

測試

mysql -uremote -h 1.1.1.1. -p