mysql odbc用户_MySql错误：ERROR 1449 (HY000) 解决办法

最新推荐文章于 2024-03-07 18:00:27 发布

weixin_39787606

最新推荐文章于 2024-03-07 18:00:27 发布

阅读量349

点赞数

文章标签： mysql odbc用户

本文链接：https://blog.csdn.net/weixin_39787606/article/details/111698006

版权

报错信息如下

ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist

复制代码

现象是登录后敲命令报错，实际是这样：

$ mysql -uroot -p12345678
$ mysql> show databases;
ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist

解决方法：

$ mysql> SET GLOBAL innodb_fast_shutdown = 1;
Query OK, 0 rows affected (0.01 sec)
$ mysql> quit
Bye
$ mysql_upgrade -uroot -p12345678
mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Upgrading system table data.
Checking system database.
mysql.columns_priv OK
mysql.component OK
……
yn.roles OK
yn.users OK
Upgrade process completed successfully.
Checking if update is needed.