Centos7下 yum安装mysql

如果没有安装过mysql 忽略 1 2 步骤

1、先检查是否有安装过旧版本的MySQL

rpm -qa | grep mysql
如果没有权限，用 sudo 执行

2、如果有安装，将就版本全部卸载

yum -y remove mysql-xx-xx
如果没有权限，用 sudo 执行

3、下载 mysql rpm 源

在root权限下、任意目录下执行该操作

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

4、 添加 yum mysql 的仓库

rpm -Uvh mysql57-community-release-el7-11.noarch.rpm

5、 自定义 mysql 安装的版本

• 5.1、查看当前可安装版本

  yum repolist all | grep mysql
  

  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-connectors-community/x86_64  MySQL Connectors Community       启用:     95
  mysql-connectors-community-source  MySQL Connectors Community - Sou 禁用
  mysql-tools-community/x86_64       MySQL Tools Community            启用:     84
  mysql-tools-community-source       MySQL Tools Community - Source   禁用
  mysql-tools-preview/x86_64         MySQL Tools Preview              禁用
  mysql-tools-preview-source         MySQL Tools Preview - Source     禁用
  mysql55-community/x86_64           MySQL 5.5 Community Server       禁用
  mysql55-community-source           MySQL 5.5 Community Server - Sou 禁用
  mysql56-community/x86_64           MySQL 5.6 Community Server       禁用
  mysql56-community-source           MySQL 5.6 Community Server - Sou 禁用
  mysql57-community/x86_64           MySQL 5.7 Community Server       启用:    427
  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 禁用
  
  

  enabled,表示默认安装版本， 默认为5.7

• 5.2、修改安装版本

  关闭5.7版本安装
  yum-config-manager --disable mysql57-community
  

  打开5.5版本安装 、如果要安装其他版本的mysql  自行修改
  yum-config-manager --enable mysql55-community 
  

• 5.3、验证版本

  yum repolist enabled | grep mysql
  

  mysql-connectors-community/x86_64  MySQL Connectors Community     启用:     95
  mysql-tools-community/x86_64       MySQL Tools Community      启用:    84
  mysql55-community/x86_64           MySQL 5.5 Community Server     启用:    427
  

• 5.4、安装 mysql 5.5

  yum install mysql-community-server
  

6、成功安装之后重启mysql服务

	service mysqld restart

7、初次安装mysql是root账户是没有密码的。设置密码的方法

	使用命令	mysql -uroot  进入mysql
	
	mysql> set password for ‘root’@‘localhost’ = password(‘password’);
	mysql> exit