ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 5
来源:互联网 发布:数控车床编程实例 简单 编辑:程序博客网 时间:2024/06/04 22:21
错误信息如下:
ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 50552, now running 50637. Please use mysql_upgrade to fix this error
错误是由于你曾经升级过数据库,升级完后没有使用 mysql_upgrade升级数据结构造成的。
解决办法:
使用mysql_upgrade命令修复
[root@localhost charsets]# mysql_upgrade -u root -p Enter password: Looking for 'mysql' as: mysqlLooking for 'mysqlcheck' as: mysqlcheckRunning 'mysqlcheck with default connection argumentsWarning: Using a password on the command line interface can be insecure.Running 'mysqlcheck with default connection argumentsWarning: Using a password on the command line interface can be insecure.mysql.columns_priv OKmysql.db OKmysql.event OKmysql.func OKmysql.general_log OKmysql.help_category OKmysql.help_keyword OKmysql.help_relation OKmysql.help_topic OKmysql.host OKmysql.ndb_binlog_index OKmysql.plugin OKmysql.proc OKmysql.procs_priv OKmysql.proxies_priv OKmysql.servers OKmysql.slow_log OKmysql.tables_priv OKmysql.time_zone OKmysql.time_zone_leap_second OKmysql.time_zone_name OKmysql.time_zone_transition OKmysql.time_zone_transition_type OKmysql.user OKRunning 'mysql_fix_privilege_tables'...Warning: Using a password on the command line interface can be insecure.Running 'mysqlcheck with default connection argumentsWarning: Using a password on the command line interface can be insecure.Running 'mysqlcheck with default connection argumentsWarning: Using a password on the command line interface can be insecure.OK
修复完成
阅读全文
0 0
- ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 5
- ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 5
- ERROR 3009 (HY000): Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 5
- ERROR 3009 (HY000): Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 5
- Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 5054
- 执行mysql添加权限语法,报错提示:ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 42, found 39. C
- MySQL新建存储过程出现:ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16. Create
- MySQL新建存储过程出现:ERROR 1558 (HY000): Column count of mysql.proc is wrong. Expected 20, found 16. Create
- Error Number : 1547 Error Message: Column count of mysql.proc is wrong. Expected 20, found 16. The
- Column count of mysql.proc is wrong. Expected 20, found 16.解决方法
- Column count of mysql.proc is wrong. Expected 20, found 16.解决方法
- System error:Column count of mysql.event is wrong.
- mysql遇见 column count of mysql.proc is wrong expected 20 found16
- mysql 1558 - Column count of mysql.proc is wrong 的解决
- java.lang.IllegalArgumentException: Tuple created with wrong number of fields. Expected 1 fields but
- ERROR 1289 (HY000): The 'partitioning' feature is disabled; you need MySQL built with '--with-plugin
- ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option
- mysql 导出数据到文件 ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so
- CASIA脱机汉字库数据提取工具
- lua 引用lua表元素时需要写完整名称
- 浮点数存储 0.1 0.2 实际偏大
- jquery day1
- Pat(A) 1073. Scientific Notation (20)
- ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 5
- 第三次面试总结
- MFC常用空间类别及说明
- Python实现大文件分片上传
- C++有趣的问题
- 初识python
- java动态/静态绑定以及双分派
- spring framework test3种方式
- Codeforces 785D Anton and School