Linux- Centos7 安装mysql详细步骤与问题解决

0 yum list

1 yum -y install wget

2 wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

3 yum -y install mysql57-community-release-el7-10.noarch.rpm

4 yum -y install mysql-community-server(如执行出现报错“No package mysql-server available)
在CentOS7上安装mysql时，出现了以下的提示：
“No package mysql-server available
原因是：

CentOS7带有MariaDB而不是MySQL，MariaDB和MySQL一样也是开元的数据库，您可以使用yum -y install mariadb-server mariadb命令安装

解决方案：

如果必须要安装MySQL，首先必须添加mysql社区repo通过输入命令：sudo rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
再重新执行第4步

5 service mysqld start

6 netstat -nltp | grep 3306

7 grep “password” /var/log/mysqld.log 查看原始密码

grep ‘password’ /var/log/mysqld.log
2020-06-24T07:21:25.731630Z 1 [Note] A temporary password is generated for root@localhost: Apd>;WYEc2Ir
2020-06-24T07:21:48.097350Z 2 [Note] Access denied for user ‘root’@‘localhost’ (using password: NO)

8 登录 mysql -uroot -pWYEc2Ir

9 修改密码

mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;   这个两个设置以后 密码很简单不会报错

ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘root’;