1.进入mysql: mysql -u root -p
2.删除之前的视图表: drop user mysql.infoschema
@“localhost”;
3.刷新权限: flush privileges;
4.创建缺少的视图表:加粗样式。('123456’为自己的数据库的连接密码):
create user mysql.infoschema
@“localhost” identified by ‘123456’;
5.再刷新权限: flush privileges;
6.使用数据库:use mysql;
7.设置权限: update user set Select_priv = ‘Y’ where User = ‘mysql.infoschema’;
8.刷新权限: flush privileges;
连接成功
MySQL连接时,错误1449 : The user specified as a definer (‘root‘@‘%‘) does not exist 解决方法
于 2022-02-10 16:07:12 首次发布