mysql安裝

開外網

/etc/mysql/mysql.conf.d/mysqld.cnf

重啟

sudo systemctl restart mysql

安裝

sudo apt install mysql-server

進入

sudo mysql -u root -p

改密

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewRootPass';
FLUSH PRIVILEGES;

創建用戶

CREATE USER 'hacker'@'localhost' IDENTIFIED BY 'MyNewRootPass';

創建外網用戶

CREATE USER 'hacker'@'%' IDENTIFIED BY 'MyNewRootPass';
GRANT ALL PRIVILEGES ON *.* TO 'hacker'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

看權限

SHOW GRANTS FOR 'hacker'@'%';

創建數據庫

CREATE DATABASE aaaa CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

授權

GRANT ALL PRIVILEGES ON aaaa.* TO 'hacker'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'hacker'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;