Linux install mysql 在Linux安裝Mysql

1.0 install mysql

?

1 2 3 4

sudo apt purge mysql-server mysql-common sudo apt autoremove mysql-server mysql-common sudo apt-get update sudo apt-get install mysql-server

　　安裝mysql-server

2.0 change to old password

?

1 2 3 4 5

sudo mysql -u root USE mysql; UPDATE user SET plugin='mysql_native_password' WHERE User='root'; FLUSH PRIVILEGES; exit;

　　使用舊版的密碼

3.0 bind port

?

1	sudo vi /etc/mysql/mysql.cnf

　　修改mysql.cnf

?

1 2 3 4 5

[mysql] bind-address = 0.0.0.0   [mysqld] bind-address = 0.0.0.0

　　bind port

?

1	sudo /etc/init.d/mysql restart

　　restart mysql

4.0 add new user

新增權限

5.0 connect

可在外網連接