centos安装mysql

欢迎访问我的个人博客网站：http://www.yanmin99.com/

一、检查mysql是否安装

• 第一种方式查看

  [root@iZ2ze3nze2sw4quaa8xor9Z yanmin]# rpm -qa | grep -i mysql
  php-mysql-5.3.3-49.el6.x86_64
  mysql-libs-5.1.73-8.el6_8.x86_64

• 第二种方式查看

  [root@iZ2ze3nze2sw4quaa8xor9Z yanmin]# yum list installed | grep mysql
  mysql-libs.x86_64      5.1.73-8.el6_8   @base
  php-mysql.x86_64       5.3.3-49.el6     @base

二、卸载mysql

• 1、通过yum卸载

  yum -y remove mysql mysql-server mysql-libs

• 2、查看是否卸载干净

  A、通过find / -name mysql查看

  [root@iZ2ze3nze2sw4quaa8xor9Z yanmin]# find / -name mysql
  /var/lib/mysql
  /var/lib/mysql/mysql

  B、删除残留文件

  [root@iZ2ze3nze2sw4quaa8xor9Z yanmin]# rm -rf /var/lib/mysql/

三、yum和RPM安装

• 1、通过yum安装

  • 通过yum安装

    yum install  mysql mysql-server mysql-libs;

  • 通过yum卸载

    yum remove  mysql mysql-server mysql-libs;

• 2、通过RPM安装

  • A、直接选择一个版本到repos文件夹中

    • 1、查看mysql是否存在/etc/yum.repos.d/文件夹中
      

      yum repolist all | grep mysql

  • 2、在/etc/yum.repos.d/mysql-community.repo添加mysq5.6版本

    //MySQL5.6版本
    
    # Enable to use MySQL 5.6
    
    [mysql56-community]
    name=MySQL 5.6 Community Server
    baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/
    enabled=1
    gpgcheck=1
    gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
    
    //MySQL5.7版本
    [mysql57-community]
    name=MySQL 5.7 Community Server
    baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
    enabled=1
    gpgcheck=1
    gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

    enabled=0 禁用 enabled=1 启用

  • 3、查看源是否添加成功

    yum repolist enabled | grep mysql

    enabled查看启用列表

  • 4、安装

    sudo yum install mysql-community-server

• B、通过下载版本，本地安装

  • 1、下载MySQL Yum Repository

    wget --no-check-certificate  https://repo.mysql.com//mysql57-community-release-el6-11.noarch.rpm

  • 2、添加 MySQL Yum Repository

    rpm -ivh mysql57-community-release-el6-11.noarch.rpm

    通过执行rpm -ivh，其实在/etc/yum.repos.d/文件夹中生成了mysql-community.repo和mysql-community-source.repo文件。

  • 3、验证下是否添加成功

    yum repolist all | grep mysql

  • 4、选择要启用 MySQL 版本

    • mysql-community.repo有常用版本，可以通过enable=1指定安装版本。

    • mysql-community.repo文件如下：

      [mysql-connectors-community]
       name=MySQL Connectors Community
       baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/6/$basearch/
       enabled=1
       gpgcheck=1
       gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
      
       [mysql-tools-community]
       name=MySQL Tools Community
       baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/6/$basearch/
       enabled=1
       gpgcheck=1
       gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
      
       # Enable to use MySQL 5.5
       [mysql55-community]
       name=MySQL 5.5 Community Server
       baseurl=http://repo.mysql.com/yum/mysql-5.5-community/el/6/$basearch/
       enabled=0
      gpgcheck=1
      gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql        

  • 5、安装

    sudo yum install mysql-community-server

<script type="text/javascript"> $(function () { $('pre.prettyprint code').each(function () { var lines = $(this).text().split('\n').length; var $numbering = $('<ul/>').addClass('pre-numbering').hide(); $(this).addClass('has-numbering').parent().append($numbering); for (i = 1; i <= lines; i++) { $numbering.append($('<li/>').text(i)); }; $numbering.fadeIn(1700); }); }); </script>