mysql 离线升级_mysql8.0.21离线安装

由于mysql5.1.71存在大量的漏洞，本文记录如何从5.1.71升级到mysql80.21

1、查看mysql的安装

sudo -s

rpm -qa|grep mysql

2、卸载安装及清理配置

rpm -e --nodeps 上述查看到的安装

whereis mysql

rm /etc/my.cnf

rm /etc/my.cnf.rpmsave

rm -rf /var/lib/mysql

rm -rf /usr/lib64/mysql

rm /var/log/mysqld.log

find / -name mysql

所有查询到的都删除

3、离线安装mysql

tar -xvf mysql-8.0.21-1.el6.x86_64.rpm-bundle.tar

rpm -ivh mysql-community-common-8.0.21-1.el6.x86_64.rpm

rpm -ivh mysql-community-libs-8.0.21-1.el6.x86_64.rpm

rpm -ivh mysql-community-client-8.0.21-1.el6.x86_64.rpm

rpm -ivh mysql-community-server-8.0.21-1.el6.x86_64.rpm

rpm -qi mysql-community-server-8.0.21-1.el6.x86_64

vim /etc/my.cnf

datadir=/data/var/lib/mysql

socket=/data/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'

max_connections=1000

innodb_flush_log_at_trx_commit=0

innodb_autoextend_increment=128

innodb_buffer_pool_size=4g

innodb_log_file_size=1g

max_allowed_packet=64m

tmp_table_size = 1024M

max_heap_table_size = 1024M

character-set-server = utf8

collation-server = utf8_general_ci

##设置不区分大小写

lower_case_table_names=1

##设置时区(不设置可能导致select now()与当前时间不一致)

default_time_zone=+8:00

[client]

default-character-set = utf8

socket=/data/var/lib/mysql/mysql.sock

service mysqld start

service mysqld status

#/etc/init.d/mysqld {start|stop|status|restart|condrestart|try-restart|reload|force-reload}

chkconfig mysqld on

4、初始化及配置账号

grep 'temporary password' /var/log/mysqld.log

mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码'

ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

use mysql;

select host,user,authentication_string,plugin from user;

CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '密码';

ALTER USER 'root'@'%' PASSWORD EXPIRE NEVER;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

quit