- mysql安装
sudo yum update
sudo yum install https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
yum install mysql-server
- mysql启动
sudo systemctl restart mysqld
USE mysql;
SELECT user, host, authentication_string FROM user;
ALTER USER 'username'@'host' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
- mysql远程主机授权
CREATE USER 'root'@'%|ip' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%|ip' WITH GRANT OPTION;
FLUSH PRIVILEGES;
