Ubuntu 18.04 安裝 MySQL 5.7 并配置遠端連接配接

01 安裝

sudo apt install mysql-server
           

02 進入mysql

sudo mysql
           

03 改密碼，允許遠端

use mysql;
update user set plugin='mysql_native_password' where user='root';
update user set authentication_string=PASSWORD('123456') where user='root';
update user set host='%' where user='root';
flush privileges;
quit;
           

04 允許遠端

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
注釋掉 bind-address = 127.0.0.1
           

05 重新開機服務

sudo service mysql restart