Install MySQL on Ubuntu 18.04

7 ต.ค. 2020 , 2,849 Views , หมวดหมู่ Linux MySQL โค๊ดดิ้ง , ป้ายกำกับ:install, mysql, Ubuntu 18.04

Step 1 — Installing MySQL

sudo apt update

1	sudo apt update

sudo apt install mysql-server

1	sudo apt install mysql-server

sudo mysql_secure_installation

1	sudo mysql_secure_installation

sudo mysql

1	sudo mysql

Next, check which authentication method each of your MySQL user accounts use with the following command:

SELECT user,authentication_string,plugin,host FROM mysql.user;

1	SELECT user,authentication_string,plugin,host FROM mysql.user;

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

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

FLUSH PRIVILEGES;

1	FLUSH PRIVILEGES;

ที่มา : https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-18-04

ป้ายกำกับ:install, mysql, Ubuntu 18.04