| [root@mysql-0001 mysql] |
| mysql-community-client-5.7.42-1.el7.x86_64 |
| mysql-community-libs-5.7.42-1.el7.x86_64 |
| mysql-community-server-5.7.42-1.el7.x86_64 |
| mysql-community-common-5.7.42-1.el7.x86_64 |
| mysql-community-libs-compat-5.7.42-1.el7.x86_64 |
清华地址:https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/
mysql 官网:https://downloads.mysql.com/archives/community/
| |
| mysqldump -u$MYSQL_ADMIN_USER -p $MYSQL_ADMIN_PASSWOR --all-databases --default-character-set=utf8 > /data/backup/databases.sql |
| |
| cp /etc/my.cnf /etc/my.cnf.bak |
| systemctl stop mysqld.service |
| rpm -qa | grep -i mysql | xargs rpm -ev --nodeps |
| mkdir mysql |
| cd mysql/ |
| |
| tar –xvf mysql-5.7.44-1.el7.x86_64.rpm-bundle.tar |
或
| |
| rpm -ivh mysql-community-common-5.7.44-1.el7.x86_64.rpm |
| rpm -ivh mysql-community-libs-5.7.44-1.el7.x86_64.rpm |
| rpm -ivh mysql-community-libs-compat-5.7.44-1.el7.x86_64.rpm |
| rpm -ivh mysql-community-devel-5.7.44-1.el7.x86_64.rpm |
| rpm -ivh mysql-community-client-5.7.44-1.el7.x86_64.rpm |
| rpm -ivh mysql-community-server-5.7.44-1.el7.x86_64.rpm |
| |
| cp /etc/my.cnf.bak /etc/my.cnf |
| systemctl start mysqld.service |
mysql_upgrate进行系统数据库表检测,检测是否兼容,若发现问题,尝试对其进行修复
| mysql_upgrade -u$MYSQL_ADMIN_USER -p $MYSQL_ADMIN_PASSWOR |
| mysql -u$MYSQL_ADMIN_USER -p $MYSQL_ADMIN_PASSWOR |
| mysql> select version(); |
| +-----------+ |
| | version() | |
| +-----------+ |
| | 5.7.44 | |
| +-----------+ |
如果发现问题,则使用备份的文件进行数据恢复
是因为高版本自动开启了 ssl 链接
在 /etc/my.cnf 中设置
或
| [mysqld] |
| ssl-ca=/path/to/ca-cert.pem |
| ssl-cert=/path/to/server-cert.pem |
| ssl-key=/path/to/server-key.pem |
并在客户端连接时开启
jdbc:mysql://[host]:[port]/[database]?useSSL=true&requireSSL=true