ERROR 3009 (HY000): Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 5
mysql Error of is with HY000 user found
2023-09-14 09:07:45 时间
ERROR 3009 (HY000): Column count of mysql.user is wrong. Expected 45, found 43. Created with MySQL 5的解决方案。
错误是由于你曾经升级过数据库,升级完后没有使用
mysql_upgrade升级数据结构造成的。
解决办法:
使用mysql_upgrade命令
root@localhost ~]# mysql_upgrade -u root -p 13456
相关文章
- 【Mysql异常】[HY000][1030] Got error 28 from storage engine
- mysql 添加索引 mysql 如何创建索引
- mysql load data infile的使用 和 SELECT into outfile备份数据库数据
- MySQL查看数据库性能常用命令
- Error: Failed to connect to MySQL server: DBI connect(';
- mySql ERROR 1046(3D000): No Datab
- MySQL Workbench update语句错误Error Code: 1175.
- ERROR 2003 (HY000): Can't connect to MySQL server
- Linux重置Mysql密码_解决MySQL for Linux错误 ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost
- error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
- SQL Editor and reconnect【mysql(workbench)更新数据时候的一个异常】【Error Code:1175】
- mysql登录报错 ERROR 1045 (28000)
- 在SQL注入中利用MySQL隐形的类型转换绕过WAF检测
- 91.第十九章 MySQL数据库 -- 数据库原理(一)
- 【MySQL案件】ERROR 1418
- jdbc链接mysql转
- MySQL报错`ERROR: No query specified`
- MySQL生成随机数
- MySql查询的生命周期和性能优化思路