当前位置:网站首页>Upgrade MySQL 5.1 to 5.69
Upgrade MySQL 5.1 to 5.69
2022-04-23 15:38:00 【franket】
Error indication schema There is something wrong with the structure of
But you can log in normally after trying to log in
And found that it is a new version
[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>
solve schema The method of structural error is to carry out upgrade
Conduct mysql_upgrade
Must be used when the instance is running 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 ~]#
Repair completed
版权声明
本文为[franket]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204231406039231.html
边栏推荐
- MySQL installation process (steps for successful installation)
- PHP operators
- s16.基于镜像仓库一键安装containerd脚本
- Functions (Part I)
- Advantages, disadvantages and selection of activation function
- 北京某信护网蓝队面试题目
- Today's sleep quality record 76 points
- Connect PHP to MSSQL via PDO ODBC
- 通过 PDO ODBC 将 PHP 连接到 MSSQL
- Special analysis of China's digital technology in 2022
猜你喜欢
Openstack theoretical knowledge
现在做自媒体能赚钱吗?看完这篇文章你就明白了
Knn,Kmeans和GMM
Detailed explanation of redirection and request forwarding
多生成树MSTP的配置
Differential privacy (background)
函数(第一部分)
cadence SPB17.4 - Active Class and Subclass
How did the computer reinstall the system? The display has no signal
Mysql database explanation (10)
随机推荐
Collation of errors encountered in the use of redis shake
计算某字符出现次数
Openstack theoretical knowledge
Go并发和通道
The El tree implementation only displays a certain level of check boxes and selects radio
如果conda找不到想要安装的库怎么办PackagesNotFoundError: The following packages are not available from current
北京某信护网蓝队面试题目
ICE -- 源码分析
多生成树MSTP的配置
2022年中国数字科技专题分析
【递归之数的拆分】n分k,限定范围的拆分
shell脚本中的DATE日期计算
Mumu, go all the way
PHP PDO ODBC将一个文件夹的文件装载到MySQL数据库BLOB列,并将BLOB列下载到另一个文件夹
Krpano panorama vtour folder and tour
移动app软件测试工具有哪些?第三方软件测评小编分享
el-tree实现只显示某一级复选框且单选
怎么看基金是不是reits,通过银行购买基金安全吗
Sword finger offer (1) -- for Huawei
通過 PDO ODBC 將 PHP 連接到 MySQL