在centos7.3中安装mysql5.6

接上文,开始安装mysql5.6。

1. 通过yum在线安装mysql
   1. 如果没有安装yum-utils包,运行命令

   yum -y install yum-utils 
   

   2. 检测系统是否自带安装mysql

   yum list installed | grep mysql
   

   3. 删除系统自带的mysql及其依赖

   yum -y remove mysql-libs.x86_64
   

   4. 给CentOS添加rpm源，并且选择较新的源

   # wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
   # yum localinstall mysql-community-release-el6-5.noarch.rpm
   查看mysql安装源
   # yum repolist all | grep mysql
   禁用低版本安装源
   # yum-config-manager --disable mysql55-community
   开启高版本安装源
   # yum-config-manager --enable mysql56-community
   # yum-config-manager --enable mysql57-community-dmr
   查看已开启版本安装源
   # yum repolist enabled | grep mysql
   

   可以修改vim /etc/yum.repos.d/mysql-community.repo源，改变默认安装的mysql版本。比如要安装5.6版本，将5.7源的enabled=1改成enabled=0。然后再将5.6源的enabled=0改成enabled=1即可。
   5. 安装mysql服务器

   yum install mysql-community-server
   

   6. 启动mysql

   service mysqld start
   

   7. 登录mysql

   	mysql -uroot -p 
   	不需要输入密码
   	SET PASSWORD = PASSWORD('ieforever');
   

2. 设置远程访问：

       1.创建用户
       create user 'crbchqimis'@'%' identified by 'crbchqimis';
       2.赋予权限
       grant all privileges on *.* to 'crbchqimis' @'%' identified by 'crbchqimis'; 
       grant all privileges on *.* to 'crbchqimis' @'localhost' identified by 'crbchqimis'; 
       3.刷新权限
       flush privileges;
   

3. 查看用户

   use mysql;
   SELECT DISTINCT CONCAT('User: [', user, '''@''', host, '];') AS USER_HOST FROM user;
   +------------------------------------+
   | USER_HOST                          |
   +------------------------------------+
   | User: [ieforever'@'%];             |
   | User: [mysql.session'@'localhost]; |
   | User: [mysql.sys'@'localhost];     |
   | User: [root'@'localhost];          |
   +------------------------------------+
   

4. 设置编码和不区分大小写

   vim /etc/my.cnf
   在[mysqld] 下添加
   lower_case_table_names=1
   character_set_server=utf8
   重启服务
   service mysqld restart
   

   以上mysql5.6已经安装成功，下面开启访问端口：
   1. 查看已开放的端口(默认不开放任何端口)
      firewall-cmd --list-ports
   2. 开启3306端口
      firewall-cmd --zone=public(作用域) --add-port=3306/tcp(端口和访问类型) --permanent(永久生效)
   3. 重启防火墙
      firewall-cmd --reload