当前位置:网站首页>mysql 5.1升级到5.69
mysql 5.1升级到5.69
2022-04-23 14:06:00 【franket】
报错表明schema的结构有问题
但是尝试登录已经可以正常登录
并且发现已经是新的版本了
[root@upgrade-slave ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.27-75.0-log Percona Server (GPL), Release 75.0, Revision 8bb53b6
Copyright (c) 2009-2015 Percona LLC and/or its affiliates
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
解决schema的结构错误的方法是进行upgrade
进行mysql_upgrade
必须是实例正在运行的状态下使用upgrade
[root@upgrade-slave ~]# time mysql_upgrade -u root -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock'
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock'
Warning: Using a password on the command line interface can be insecure.
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Running 'mysql_fix_privilege_tables'...
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock'
Warning: Using a password on the command line interface can be insecure.
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock'
Warning: Using a password on the command line interface can be insecure.
huodongdb.delivered_emails OK
huodongdb.prepared_emails OK
testdb.space_diaries OK
...
...
feeddb.ux_order_stats OK
feeddb.ux_product_stats OK
feeddb.weight_changes OK
test.checksum OK
OK
real 2m4.418s
user 0m0.049s
sys 0m0.038s
[root@upgrade-slave ~]#
修复完成
版权声明
本文为[franket]所创,转载请带上原文链接,感谢
https://cloud.tencent.com/developer/article/1986104
边栏推荐
- 帆软调用动态传参的方法,在标题中设置参数
- Jmeter设置环境变量支持在任意终端目录输入jmeter直接启动
- nodejs通过require读取本地json文件出现Unexpected token / in JSON at position
- ActiveMq基础知识
- Wechat applet initializes Bluetooth, searches nearby Bluetooth devices and connects designated Bluetooth (I)
- 基于CM管理的CDH6.3.2集群集成Atlas2.1.0
- Request module
- 修改ddt生成的测试用例名称
- JDBC详解
- RecyclerView细节研究-RecyclerView点击错位问题的探讨与修复
猜你喜欢
RobotFramework 之 用例标签机制
微信小程序的订阅号开发(消息推送)
Use of WiFi module based on wechat applet
nodejs通过require读取本地json文件出现Unexpected token / in JSON at position
微信小程序获取登录用户信息、openid和access_token
查询2013年到2021年的数据,只查询到2020的数据,遇到了这个问题所进行的解决办法
Call wechat customer service applet
logback-logger和root
01-NIO基础之ByteBuffer和FileChannel
Pycharm连接远程服务器并实现远程调试
随机推荐
微信小程序通过低功耗蓝牙设备进行定位及测距(二)
某政务云项目业务系统迁移调研实践
On the multi-level certificate based on OpenSSL, the issuance and management of multi-level Ca, and two-way authentication
Use of WiFi module based on wechat applet
基于CM管理的CDH集群集成Phoenix
数据库DbVisualizer Pro报文件错误,导致数据连接失败
PySide2
Homebrew是什么?以及使用
Mysql个人学习总结
Restful WebService和gSoap WebService的本质区别
MYSQL 主从同步避坑版教程
烟雾传感器(mq-2)使用详细教程(基于树莓派3b+实现)
Detailed tutorial on the use of setinterval timing function of wechat applet
RecyclerView高级使用(二)-垂直拖拽排序的简单实现
修改ddt生成的测试用例名称
pthread_ Why does self() repeat
帆软中单元格中隔行变色以及数量大于100字体变大变红设置
Recyclerview advanced use (I) - simple implementation of sideslip deletion
leetcode--380. O (1) time insertion, deletion and acquisition of random elements
Understand the concepts of virtual base class, virtual function and pure virtual function (turn)