centos7系统通过yum源安装mysql_检查mysql源是否安装成功 $ yum repolist enabled

本文链接：https://blog.youkuaiyun.com/K_Lily/article/details/106126178

本文详细介绍了在CentOS7系统中如何通过yum源安装MySQL，包括下载安装包、安装、验证、启动服务、设置开机启动、开放端口及修改root密码的步骤。在修改root密码过程中，还解决了因密码策略导致的错误问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.下载mysql源安装包

$ wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

2.安装mysql源

$ yum localinstall mysql57-community-release-el7-8.noarch.rpm

3.检查mysql源是否安装成功

$ yum repolist enabled | grep "mysql.*-community.*"

4.安装MySQL

$ yum install mysql-community-server

这一步很久

5.启动MySQL服务并设置开机启动

$ systemctl start mysqld
$ systemctl enable mysqld
$ systemctl daemon-reload

6.端口开放

$ firewall-cmd --zone=public --add-port=3306/tcp --permanent
$ firewall-cmd --reload

7.修改root本地登录密码

1）查看mysql密码

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

localhost:后面的所有都是密码

2）连接mysql

$mysql -uroot -p

3）修改密码【注意：后面的分号一定要跟上】

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

或者：

mysql> set password for 'root'@'localhost'=password('MyNewPass4!');

退出quit;

Bye

修改密码问题

注意，出现下列错误如何解决

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

解决办法：

首先，修改validate_password_policy参数的值

mysql> set global validate_password_policy=0;

再修改密码的长度

mysql> set global validate_password_length=1;

再次执行修改密码就可以了

mysql>ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root123';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)

mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.00 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
Query OK, 0 rows affected (0.06 sec)

mysql>

授权其他机器登陆

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

FLUSH  PRIVILEGES;