- 卸載centos7自帶MariaDB
rpm –qa | grep mariadb
rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64
- 下載mysql版本 （等待下載完成）
wget http://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-5.6/MySQL-5.6.45-1.el7.x86_64.rpm-bundle.tar
wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.6/MySQL-5.6.45-1.el7.x86_64.rpm-bundle.tar
- 解壓文件
tar -xvf MySQL-5.6.42-1.el7.x86_64.rpm-bundle.tar
- 安裝
rpm -ivh MySQL-server-5.6.42-1.el7.x86_64.rpm
rpm -ivh MySQL-devel-5.6.42-1.el7.x86_64.rpm
rpm -ivh MySQL-client-5.6.42-1.el7.x86_64.rpm
- 啟動
service mysql start
- 打開mysql輸入
msyql
- 創(chuàng)建mysql用戶
grant all privileges on *.* to mysql@'%' identified by '123456' with grant option;
flush privileges;
- 如果有些配置不生效重啟mysql
service msyql restart;
所遇問題
安裝過程中如果需要依賴包請自行yum安裝
- 問題1
warning: MySQL-server-5.6.42-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
perl(Data::Dumper) is needed by MySQL-server-5.6.42-1.el7.x86_64
- 解決辦法：
cd /etc/pki/rpm-gpg
rpm --import /etc/pki/rpm-gpg/RPM-GPG-KEY*
yum -y install perl perl-devel perl-Data-Dumper
如果還不行：rpm -ivh MySQL-server-5.6.42-1.el7.x86_64.rpm --force --nodeps 強安裝
- 問題2：啟動時如果報錯：
Starting MySQL.Logging to '/var/lib/mysql/izuf66sgxgoyt19dbhtlqdz.err'.
.The server quit without updating PID file (/var/lib/mysql/[FAILED]xgoyt19dbhtlqdz.pid).
- 解決辦法：
cat /var/lib/mysql/izuf66sgxgoyt19dbhtlqdz.err
執(zhí)行： mysql_install_db --user=mysql --ldata=/var/lib/mysql/
