使用root用戶登錄mysql
mysql -u root -p
新增一個用戶
use mysql;
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
給新用戶添加權(quán)限
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
flush privileges;
quit
修改mysql配置文件
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
找到bind-address = 127.0.0.1
修改為 bind-address = 0.0.0.0
:wq
重啟mysql
service mysql restart
開放3306端口
服務(wù)器需要配置安全組規(guī)則
有防火墻需要開放3306
sudo ufw allow 3306
