mysql 1449 : The user specified as a definer ('root&
发布时间:2020-12-12 00:50:02 所属栏目:MySql教程 来源:网络整理
导读:《mysql 1449 : The user specified as a definer (root@%) does not exist 解决方法Mys》要点: 本文介绍了mysql 1449 : The user specified as a definer (root@%) does not exist 解决方法Mys,希望对您有用。如果有疑问,可以联系我们。 导读:程序在
《mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法Mys》要点: 锚点mysql 1449 : The user specified as a definer ('montor'@'%') does not exist 经查,是权限问题,解决办法: 运行:grant all privileges on *.* to monitor@"%" identified by "."; 之后打开视图时便不会报错,程序调用也不会报错. 源地址的解释: 权限问题,授权 给 root? 所有sql 权限 MySQL> grant all privileges on *.* to root@"%" identified by "."; Query OK,0 rows affected (0.00 sec) mysql> flush privileges; Query OK,0 rows affected (0.00 sec) (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |