Mysql8.02 / ubuntu 20 ERROR 1449 (HY000)

刚通过apt install mysql-server安装好mysql，就遇到了坑。查了好久终于找了答案，感谢网友。

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

进入mysql就报错，也不知道为啥原因。懵b

mysql> create user ' mysql.infoschema '@'% 'identified by' password ';
Query OK, 0 rows affected (0.01 sec)
mysql> grant all privileges on *.* to 'mysql.infoschema'@'%';
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

找了好久的答案。

参考原文
https://developpaper.com/error-1449-hy000-occurs-when-mysql-uses-show-tables/