CentOS 6.5/6.6 安装mysql 5.7

Step1: 检测系统是否自带安装mysql

  
  
   
   de  >
   
   # yum list installed | grep mysql
de>
  
  

Step2: 删除系统自带的mysql及其依赖
命令：

  
  
   
   de  >
   
   # yum -y remove mysql-libs.x86_64
de>
  
  

  
  
   
   de  >
   
   注：用de>
   
    yum -y remove xxx【
   
   xxx是你第一步骤命令的输出
   
   】，这个步骤不能省略，不然下面会出现一堆莫名其妙的问题；
  
  

Step3: 给CentOS添加rpm源，并且选择较新的源
命令：

  
  
   
   de  >
   
   # wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm

   
   # yum localinstall mysql-community-release-el6-5.noarch.rpm

   
   # yum repolist all | grep mysql

   
   # yum-config-manager --disable mysql55-community

   
   # yum-config-manager --disable mysql56-community

   
   # yum-config-manager --enable mysql57-community-dmr

   
   # yum repolist enabled | grep mysql
de>
  
  

  
  
   
   de  >
   
   注：如果de>
   
   yum-config-manager这个命令没有，直接yum 
   
   yum-*即可
  
  

Step4:安装mysql 服务器
命令：

  
  
   
   de  ># yum 
   
   install mysql-community-server
de>
  
  

Step5: 启动mysql
命令:

  
  
   
   de  >
   
   # service mysqld start
de>
  
  

Step6: 查看mysql是否自启动,并且设置开启自启动
命令:

  
  
   
   de  >
   
   # chkconfig --list | grep mysqld

   
   # chkconfig mysqld on
de>
  
  

Step7: 获取mysql初始密码：

#######从mysql进程日志中获取root用户的初始密码：ra%yk7urCBIh

  
  
   
   de style="box-sizing: border-box; padding: 0px; border-radius: 0px; overflow-wrap: normal; background-image: none; background-attachment: initial; background-color: initial; background-size: initial; background-origin: initial; background-clip: initial; background-; background-repeat: initial;"  >
   
   
[root@typecodes ~]# grep "password" /var/log/mysqld.log
2016-02-03T10:42:17.272166Z 1 [Note] A temporary password is generated for root@localhost: ra%yk7urCBIh
2016-02-03T10:42:36.776875Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2016-02-03T10:42:52.063138Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2016-02-03T10:42:57.564373Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2016-02-03T10:43:01.477007Z 5 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2016-02-03T10:46:03.642008Z 6 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2016-02-03T10:46:11.217889Z 7 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2016-02-03T10:47:44.755199Z 0 [Note] Shutting down plugin 'validate_password'
2016-02-03T10:47:46.505844Z 0 [Note] Shutting down plugin 'sha256_password'
2016-02-03T10:47:46.505851Z 0 [Note] Shutting down plugin 'mysql_native_password'


  
  

   
   
    
    
Step8: mysql安全设置
命令：# mysql_secure_installation
step9:登陆mysql，创建用户，数据库等
参照：http://cyxinda.blog.163.com/blog/static/36596186201503162841301/
 step10:
MySQL的配置文件依然是
       
       
        
        de style="box-sizing: border-box; font-size: 12px; padding: 2px 4px; color: rgb(199, 37, 78); white-space: nowrap; border-radius: 2px; overflow: auto; background-color: rgb(249, 242, 244);"  >/etc/my.cnf
        
        de>
        
        ，其它安装信息可以通过
        
        
         
         de style="box-sizing: border-box; font-size: 12px; padding: 2px 4px; color: rgb(199, 37, 78); white-space: nowrap; border-radius: 2px; overflow: auto; background-color: rgb(249, 242, 244);"  >mysql_config
         
         de>
         
         命令查看。其中，动态库文件存放在
         
         
          
          de style="box-sizing: border-box; font-size: 12px; padding: 2px 4px; color: rgb(199, 37, 78); white-space: nowrap; border-radius: 2px; overflow: auto; background-color: rgb(249, 242, 244);"  >/usr/lib64/mysql
          
          de>
          
          目录下。
         
         
        
        
       
       
调优mysql参数：http://cyxinda.blog.163.com/blog/static/365961862016066020391/
[root@master2 ~]# mysql_config