默認CentOS yum源安裝的最高版本為5.1.73,針對低版本MySQL出現(xiàn)的漏洞违寿,對服務器MySQL進行升級湃交,具體步驟如下:
1、檢測系統(tǒng)是否自帶安裝mysql
yum list installed | grep mysql
2藤巢、刪除系統(tǒng)自帶的mysql及其依賴
yum -y remove mysql-libs.x86_64
刪除系統(tǒng)文件
rm -rf /var/lib/mysql
rm /etc/my.cnf
#查看是否還有mysql軟件:
rpm -qa|grep mysql
3搞莺、給CentOS添加rpm源,并且選擇較新的源
前往站點選擇自己需要的版本(這里以MySQL8為例)
wget http://repo.mysql.com/yum/mysql-8.0-community/el/7/x86_64/mysql80-community-release-el7-1.noarch.rpm
導入源
yum localinstall mysql80-community-release-el7-1.noarch.rpm
4掂咒、查看
yum repolist all | grep mysql
看倒'mysql80-community-source'(具體視版本而定)說明導入成功
5腮敌、安裝MySQL
yum install mysql-community-server
6、啟動MySQL
service mysqld start
7俏扩、查看初始密碼
[root@***centos ~]# grep "password" /var/log/mysqld.log
2019-03-20T07:06:42.101302Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: aDu7U&Yi0D?l
8、使用初始密碼登陸MySQL并修改密碼
bash> mysql -u root -p
mysql> alter user 'root'@'localhost' identified by 'password';
mysql> flush privileges;
9弊添、查看mysql是否自啟動,并且設置開啟自啟動
chkconfig --list | grep mysqld
chkconfig mysqld on
注:
針對 bash: yum-config-manager: command not found
yum -y install yum-utils
針對MySQL ERROR 1045
在 /etc/my.cnf的[mysql]下添加如下一行
skip-grant-tables
保存重啟mysql