前言

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