前言
數(shù)據(jù)庫系統(tǒng)期末實(shí)驗(yàn)報(bào)告要設(shè)計(jì)一個(gè)數(shù)據(jù)庫稍味，想在本地用Navicat這類軟件嘗試連接阿里云上的mysql-server服務(wù)器
可是
image.png
解決方案
修改配置文件
$ nono /etc/mysql/mysql.conf.d/mysqld.cnf
把 bind-address = 127.0.0.1 改成 0.0.0.0
改后效果圖.png
然后執(zhí)行以下操作
Log in to the MySQL server.
Log in to MySQL with the command mysql -u root -p
Type the MySQL root user password.
Issue the MySQL command:
Flush the MySQL privileges with the command FLUSH PRIVILEGES;
Exit out of the MySQL prompt with the command exit;
具體操作
CREATE USER 'scauos'@'%' IDENTIFIED BY '123456';
flush privilege;
grant all on *.* to 'wendy'@'%';
flush privilege;
大吉大利谆刨，今晚吃雞
最后使用Navicat連接
??.png
