mysql yum安装(2022.04.12最新测试可行)

安装数据库
rpm -i https://dev.mysql.com/get/mysql80-community-release-el7-5.noarch.rpm
yum install mysql-server # 默认安装8.0
systemctl start mysqld

默认安装mysql8.0
[root@localhost yum.repos.d]# yum repolist all | grep mysql

mysql-cluster-7.5-community/x86_64 MySQL Cluster 7.5 Community   disabled
mysql-cluster-7.5-community-source MySQL Cluster 7.5 Community - disabled
mysql-cluster-7.6-community/x86_64 MySQL Cluster 7.6 Community   disabled
mysql-cluster-7.6-community-source MySQL Cluster 7.6 Community - disabled
mysql-cluster-8.0-community/x86_64 MySQL Cluster 8.0 Community   disabled
mysql-cluster-8.0-community-source MySQL Cluster 8.0 Community - disabled
mysql-connectors-community/x86_64  MySQL Connectors Community    enabled:    230
mysql-connectors-community-source  MySQL Connectors Community -  disabled
mysql-tools-community/x86_64       MySQL Tools Community         enabled:    138
mysql-tools-community-source       MySQL Tools Community - Sourc disabled
mysql-tools-preview/x86_64         MySQL Tools Preview           disabled
mysql-tools-preview-source         MySQL Tools Preview - Source  disabled
mysql57-community/x86_64           MySQL 5.7 Community Server    enabled:    564
mysql57-community-source           MySQL 5.7 Community Server -  disabled
mysql80-community/x86_64           MySQL 8.0 Community Server    disabled
mysql80-community-source           MySQL 8.0 Community Server -  disabled
 

yum修改为mysql5.7
yum install yum-utils -y
yum-config-manager --enable mysql57-community-dmr
yum-config-manager --disable mysql80-community

修改用户密码
systemctl start mysqld
systemctl enable mysqld
#  grep -i 'pass' /var/log/mysqld.log # mysql 5.7 密码

mysql5.7密码规则修改
set global validate_password_policy=0;
set global validate_password_length=1;

修改密码

mysql>ALTER USER USER() IDENTIFIED BY 'passWD';
# mysqladmin -uroot -p password

远程登录访问

mysql >use mysql;

 mysql >update user set host = '%' where user = 'root';