Ubuntu18安裝Mysql

1.更新套件

sudo apt update

2.安裝Mysql

sudo apt install mysql-server

3.設置

sudo mysql_secure_installation

按提示設定

 

4.設置root password

sudo mysql

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

更新權限

FLUSH PRIVILEGES;