安裝mysql
sudo apt update
sudo apt install mysql-server
驗(yàn)證
service mysql status
配置遠(yuǎn)程連接 注釋掉bind-address=127.0.0.1
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
登錄到數(shù)據(jù)庫(kù)修改遠(yuǎn)程連接用戶(hù)
use mysql;
update user set host='%' where user='root';
GRANT ALL ON *.* TO 'root'@'%';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'admin';
FLUSH PRIVILEGES;
重啟mysql
sudo systemctl restart mysql.service
