使用yum安装MySQL

操作系统：CentOS 7.8
MySQL版本：5.7

• 安装MySQL的yum源

rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-5.noarch.rpm

• 查询yum安装包 yum repolist all | grep mysql

[root@VM-0-3-centos bootstrap3]# yum repolist all | grep mysql 
Repository epel is listed more than once in the configuration
mysql-cluster-7.5-community/x86_64 MySQL Cluster 7.5 Community      禁用
mysql-cluster-7.5-community-source MySQL Cluster 7.5 Community - So 禁用
mysql-cluster-7.6-community/x86_64 MySQL Cluster 7.6 Community      禁用
mysql-cluster-7.6-community-source MySQL Cluster 7.6 Community - So 禁用
mysql-cluster-8.0-community/x86_64 MySQL Cluster 8.0 Community      禁用
mysql-cluster-8.0-community-source MySQL Cluster 8.0 Community - So 禁用
mysql-connectors-community/x86_64  MySQL Connectors Community       启用:    230
mysql-connectors-community-source  MySQL Connectors Community - Sou 禁用
mysql-tools-community/x86_64       MySQL Tools Community            启用:    138
mysql-tools-community-source       MySQL Tools Community - Source   禁用
mysql-tools-preview/x86_64         MySQL Tools Preview              禁用
mysql-tools-preview-source         MySQL Tools Preview - Source     禁用
mysql57-community/x86_64           MySQL 5.7 Community Server       禁用
mysql57-community-source           MySQL 5.7 Community Server - Sou 禁用
mysql80-community/x86_64           MySQL 8.0 Community Server       启用:    321
mysql80-community-source           MySQL 8.0 Community Server - Sou 禁用

• 发现默认的安装源为mysql80-community版本.如果想安装5.7版本。则可以做如下操作

yum-config-manager --disable mysql80-community
yum-config-manager --enable mysql57-community

• 如果出现yum-config-manager: 未找到命令这样的问题， 则需要安装yum-utils yum -y install yum-utils
• 然后可以看到，默认安装源变更为mysql57-community yum repolist all | grep mysql

Repository epel is listed more than once in the configuration
mysql-cluster-7.5-community/x86_64 MySQL Cluster 7.5 Community      禁用
mysql-cluster-7.5-community-source MySQL Cluster 7.5 Community - So 禁用
mysql-cluster-7.6-community/x86_64 MySQL Cluster 7.6 Community      禁用
mysql-cluster-7.6-community-source MySQL Cluster 7.6 Community - So 禁用
mysql-cluster-8.0-community/x86_64 MySQL Cluster 8.0 Community      禁用
mysql-cluster-8.0-community-source MySQL Cluster 8.0 Community - So 禁用
mysql-connectors-community/x86_64  MySQL Connectors Community       启用:    230
mysql-connectors-community-source  MySQL Connectors Community - Sou 禁用
mysql-tools-community/x86_64       MySQL Tools Community            启用:    138
mysql-tools-community-source       MySQL Tools Community - Source   禁用
mysql-tools-preview/x86_64         MySQL Tools Preview              禁用
mysql-tools-preview-source         MySQL Tools Preview - Source     禁用
mysql57-community/x86_64           MySQL 5.7 Community Server       启用:    564
mysql57-community-source           MySQL 5.7 Community Server - Sou 禁用
mysql80-community/x86_64           MySQL 8.0 Community Server       禁用
mysql80-community-source           MySQL 8.0 Community Server - Sou 禁用

• 接下来就正常安装MySQL即可

yum install mysql-server -y

service mysql start

- 服务首次启动成功后，会生成一个随机的密码。可以通过日志文件 /var/log/mysqld.log来查看生成的密码 grep password /var/log/mysqld.log

[Note] A temporary password is generated for root@localhost: 7s8JCj_xe6bd

• 通过mysql指令，登录mysql mysql -uroot -p7s8JCj_xe6bd
• 第一次登录mysql，除了修改密码，不能做别的操作。 ALTER USER 'root'@'localhost' IDENTIFIED BY 'you password !!';

  这里的新密码不能太简单，因为mysql默认对密码有复杂度要求

MySQL的官方文档