centos mysql

1、下载 MySQL yum包

wget http://repo.mysql.com/mysql57-community-release-el7-9.noarch.rpm

2、安装MySQL源

rpm -ivh mysql57-community-release-el7-9.noarch.rpm

3、安装mysql

yum -y install mysql-server

4、启动数据库

systemctl start mysqld

5、查看默认密码

grep 'temporary password' /var/log/mysqld.log

6、进入数据库

mysql -uroot -p

7、设置密码

ALTER USER 'root'@'%' IDENTIFIED BY 'pwd';

8、添加账户、赋权

grant all privileges on *.* to 'user'@'%' identified by 'pwd';

flush privileges;

9、加入开机启动

systemctl enable mysqld