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;