centos 7 install mysql server

1. 首先我们要去community 去download Yum repository. download mysql 5.7 然后install

wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

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

1. 我们这个时候要去用yum install mysql-server 了

sudo yum install mysql-server

1. install 完成以后，我们就要去启动mysql server 了

systemctl restart mysqld
systemctl status mysqld

1. 然后我们要到/var/log/mysqld.log 下面去找到root 的初始passwd:

[Note] A temporary password is generated for root@localhost: X>H%_tlGK1Xp

1. 这个时候我们要去改passwd, 于是我们可以run:

mysql_secure_installation

但是报错： Error: : ‘Access denied for user ‘root’@’localhost’

1. 如果遇到上面的错误，我们可以执行下面的命令：

open  /etc/my.cnf
Add skip-grant-tables under [mysqld]
Restart Mysql
You should be able to login to mysql now using the below command mysql -u root -p
Run mysql> flush privileges;
Set new password by ALTER USER 'root'@'localhost' IDENTIFIED BY 'your new passwd';
Go back to /etc/my.cnf and remove/comment skip-grant-tables
Restart Mysql
Now you will be able to login with the new password mysql -u root -p

好了，应该可以work了。