执行mysql添加权限语法,报错提示:ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 42, found 39. C
来源:互联网 发布:淘宝开店要注册公司吗 编辑:程序博客网 时间:2024/06/05 07:10
提示报错:ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 42, found 39. Created with MySQL 50173, now running 50555. Please use mysql_upgrade to fix this error.
查找原因说说因为升级不当导致,执行以下命令即可正常执行命令
[root@localhost ~]# mysql_upgrade -uroot -p(密码)
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Running 'mysqlcheck with default connection arguments
cacti.cdef OK
cacti.cdef_items OK
cacti.colors OK
cacti.data_input OK
cacti.data_input_data OK
cacti.data_input_fields OK
cacti.data_local OK
cacti.data_template OK
cacti.data_template_data OK
cacti.data_template_data_rra OK
cacti.data_template_rrd OK
cacti.graph_local OK
cacti.graph_template_input OK
cacti.graph_template_input_defs OK
cacti.graph_templates OK
cacti.graph_templates_gprint OK
cacti.graph_templates_graph OK
cacti.graph_templates_item OK
cacti.graph_tree OK
cacti.graph_tree_items OK
cacti.host OK
cacti.host_graph OK
cacti.host_snmp_cache OK
cacti.host_snmp_query OK
cacti.host_template OK
cacti.host_template_graph OK
cacti.host_template_snmp_query OK
cacti.plugin_config OK
cacti.plugin_db_changes OK
cacti.plugin_hooks OK
cacti.plugin_realms OK
cacti.poller OK
cacti.poller_command OK
cacti.poller_item OK
cacti.poller_output OK
cacti.poller_reindex OK
cacti.poller_time OK
cacti.rra OK
cacti.rra_cf OK
cacti.settings OK
cacti.settings_graphs OK
cacti.settings_tree OK
cacti.snmp_query OK
cacti.snmp_query_graph OK
cacti.snmp_query_graph_rrd OK
cacti.snmp_query_graph_rrd_sv OK
cacti.snmp_query_graph_sv OK
cacti.user_auth OK
cacti.user_auth_perms OK
cacti.user_auth_realm OK
cacti.user_log OK
cacti.version OK
hi_aj.hi_tj OK
hi_db.hi_tb OK
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'...
OK
再重新执行赋权语句,执行正常
- 执行mysql添加权限语法,报错提示:ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 42, found 39. C
- 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
- 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.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 5054
- 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 的解决
- 执行mysql命令报错,提示:mysql:command not found
- MySQL数据库删除用户报错:ERROR 1054 (42S22): Unknown column 'User' in 'where clause'
- MySQL 启动报错-ERROR 2002 (HY000)
- mysql 报错ERROR 1290 (HY000):
- http服务器的简单使用
- selenium登录知乎并且输出一些首页的标题demo
- 依赖注入 Dependency Injection (DI)
- 这些年我原来是做系统和协议的
- spring-boot怎么更改默认的端口号
- 执行mysql添加权限语法,报错提示:ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 42, found 39. C
- CDH 升级到5.12 /etc/alternatives 仍然指向旧版本的CDH
- android studio中,拉下分支,修改包名和相关信息之后,工程类名标红,不报错,也可以编译运行,怎么回事?
- ViewPager+Fragment使用FragmentPageAdapter时app与v4下FragmentManager冲突的解决
- Spring依赖注入(DI)详解
- Java第六章:动物声音“模拟器”(接口)
- 【银行】2014年中信银行IT类笔试回忆版
- 适配器模式
- Mybatis学习总结(二