《mysql 1449 ： The user specified as a definer ('root'@'%') does not exist 解決方法Mys》要點(diǎn)：
本文介紹了mysql 1449 ： The user specified as a definer ('root'@'%') does not exist 解決方法Mys，希望對(duì)您有用。如果有疑問(wèn)，可以聯(lián)系我們。
導(dǎo)讀：程序在調(diào)用到數(shù)據(jù)庫(kù)的視圖時(shí)報(bào)錯(cuò),直接在數(shù)據(jù)庫(kù)中打開(kāi)視圖時(shí)也報(bào)錯(cuò),類似：錨點(diǎn)mysql 1449 ： The user specified as a definer (...
程序在調(diào)用到數(shù)據(jù)庫(kù)的視圖時(shí)報(bào)錯(cuò),直接在數(shù)據(jù)庫(kù)中打開(kāi)視圖時(shí)也報(bào)錯(cuò),類似：
錨點(diǎn)mysql 1449 ： The user specified as a definer ('montor'@'%') does not exist
經(jīng)查,是權(quán)限問(wèn)題,解決辦法：
運(yùn)行：grant all privileges on *.* to monitor@"%" identified by ".";
之后打開(kāi)視圖時(shí)便不會(huì)報(bào)錯(cuò),程序調(diào)用也不會(huì)報(bào)錯(cuò).
源地址的解釋：
權(quán)限問(wèn)題,授權(quán) 給 root? 所有sql 權(quán)限
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)
轉(zhuǎn)載請(qǐng)注明本頁(yè)網(wǎng)址：
http://www.snjht.com/jiaocheng/5576.html
