MySQL
PPG007 ... 2022-2-26 Less than 1 minute
# MySQL
install mysql on ubuntu20.04 (opens new window)。
# isntall mysql
sudo apt install mysql-server
# run security script and config root user
sudo mysql_secure_installation
# til now, command mysql must run with sudo, create a user to resolve this
# first connect to mysql server with root
# create user
CREATE USER 'koston'@'localhost' IDENTIFIED BY 'koston.localhost';
# grant all privileges
GRANT ALL PRIVILEGES ON *.* TO 'koston'@'localhost' WITH GRANT OPTION;
# flush
FLUSH PRIVILEGES;
# exit
exit;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
2
3
4
5
6
7
8
9
10
11
12
13
14