Navicat-MySQL报错1449 - The user specified as a definer (‘mysqlinfoschema‘@‘localhost‘) does not exist

问题：ubuntu20.04虚拟机部署了Mysql8.0.32，本机Navicat连接mysql，测试连接成功，但是确定后连接报错：1449 - The user specified as a definer ('mysqlinfoschema'@'localhost') does not exist。

解决方案：‘mysql.infoschema’@‘localhost’ 是一个用户，检查时该用户可以查询到已经存在，但是show tables报错，并不存在，不能创建此用户，需要先删除再次创建，并且赋予权限给这个用户后，Navicat尝试连接，连接成功，完美。

执行过程如下：

root@ubuntu:~$ sudo mysql -u root -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 542Server version: 8.0.32-0ubuntu0.20.04.2 (Ubuntu)Copyright (c) 2000, 2023, Oracle and/or its affiliates.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> use mysql;Database changedmysql> show tables;ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not existmysql> drop user 'mysql.infoschema'@'localhost';Query OK, 0 rows affected (0.01 sec)mysql> show tables;ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not existmysql> select user,host from user;+------------------+-----------+| user             | host      |+------------------+-----------+| root             | %         || debian-sys-maint | localhost || mysql.session    | localhost || mysql.sys        | localhost |+------------------+-----------+5 rows in set (0.00 sec)mysql> flush prvileges;ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'prvileges' at line 1mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> create user 'mysql.infoschema'@'localhost' identified by '123456'; Query OK, 0 rows affected (0.00 sec)mysql> select user,host from user;+------------------+-----------+| user             | host      |+------------------+-----------+| root             | %         || debian-sys-maint | localhost || mysql.infoschema | localhost || mysql.session    | localhost || mysql.sys        | localhost |+------------------+-----------+6 rows in set (0.01 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> grant all privileges on *.* to 'mysql.infoschema'@'localhost' with grant option;Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)mysql> show tables;+------------------------------------------------------+| Tables_in_mysql          |+------------------------------------------------------+| columns_priv             || component                || db                       || default_roles            || engine_cost              || func                     || general_log              || global_grants            || gtid_executed            || help_category            || help_keyword             || help_relation            || help_topic               || innodb_index_stats       || innodb_table_stats       || password_history         || plugin                   || procs_priv               || proxies_priv             || replication_asynchronous_connection_failover         || replication_asynchronous_connection_failover_managed || replication_group_configuration_version              || replication_group_member_actions                     || role_edges               || server_cost              || servers                  || slave_master_info        || slave_relay_log_info     || slave_worker_info        || slow_log                 || tables_priv              || time_zone                || time_zone_leap_second    || time_zone_name           || time_zone_transition     || time_zone_transition_type|| user                     |+------------------------------------------------------+37 rows in set (0.00 sec)mysql> 

 总结：删除该提示用户，再次创建该用户，赋予权限，Navicat连接成功。

来源地址：https://blog.csdn.net/weixin_59518897/article/details/130341917