linux安装MySql5.5

1.首先卸载系统中已经存在的mysql

• rpm -qa|

  grep

  -i mysql  #查看当前系统中的mysql

       MySQL-client-5.5.25a-1.rhel5

       MySQL-server-5.5.25a-1.rhel5

• 停止mysql服务、删除之前安装的mysql，如下：

rpm -ev MySQL-client-5.5.25a-1.rhel5  #此处就是上面查询到的mysql包

    rpm -ev MySQL-server-5.5.25a-1.rhel5  #同上

• 删除mysql目录  

  find

  / -name mysql

  /var/lib/mysql

  /var/lib/mysql/mysql

  /usr/lib64/mysql

• 将上面的目录统统删除

2.安装mysql5.5

• 安装yum源

  rpm -ivh http://repo.mysql.com/yum/mysql-5.5-community/el/6/x86_64/mysql-community-release-el6-5.noarch.rpm
             

• 编辑yum源文件，路径为：/etc/yum.repos.d/mysql-community.repo，修改下划线部分

  # 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=1
  gpgcheck=1
  gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
  
  # 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=0
  gpgcheck=1
  gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
             

• 安装mysql

  yum install mysql-community-client mysql-community-devel mysql-community-server php-mysql
             

• 修改MySQL密码

         mysql -u root -p

         use mysql;

         GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '新密码';

         flush privileges;