刚通过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/