The user specified as a definer ('wx_root'@'%') does not exist 解決方案
今天專案優化過程中,mysql有個問題The user specified as a definer ('wx_root'@'%') does not exist
查了一下,意思是執行sql無許可權。 看了下資料庫使用者是quoters 而sql沒有所屬權。那就找原因了。發現sql執行過程中,呼叫了一個儲存過程
而這個儲存過程的建立者是wx_root 。 所以在執行的時候,quoters沒有許可權
解決方案和操作:
1、檢視儲存過程的所屬物件: 右鍵儲存過程函式——>選擇物件屬性——>檢視函式建立和所屬是不是當前登入的使用者
2、如果不是,備份原有的儲存過程函式,複製儲存過程函式裡面所有內容,新建一個儲存過程,命名跟原來一樣。
3、這樣建立者就是屬於當前登入使用者了。原來的函式可刪可留了(如果不確定,最好先保留)
另外還有其他原因可能導致這個錯誤,例如執行mysql檢視無許可權
檢視無許可權解決方案如下:
The user specified as a definer ('root'@'%') does not exist。
一般是由於root使用者對全域性host無訪問許可權。因此只要給root使用者新增一個訪問許可權即可。
解決辦法:
登陸mysql ,執行
mysql -u root -pPasswd
mysql >grant all privileges on *.* to root@"%" identified by "Passwd"
mysql >flush privileges
相關文章
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解決方法MySql
- expdp ORA-31626: job does not exist 解決方案
- Error: The directory named as part of the path ./log/supervisord.log does not exist解決方案Error
- ORA-24756: transaction does not exist問題解決
- ORA-27101 Shared memory realm does not exist錯誤解決方案
- 模擬ORA-04043並解決(dba_* does not exist)
- yii2接入pgSQL(查詢不到表The table does not exist: {{%user}})SQL
- asmcmd does not exist in directoryASM
- IMP 時的 ORA-01435 user does not exist 處理
- The operation, ‘DecodeJpeg/contents‘, does not exist in the graph.錯誤解決方法
- Oracle ORA - 01720 grant option does not exist for..報錯解決Oracle
- The file '/MasterPage.master' does not exist. 類錯誤解決方法AST
- javax.media does not existJava
- Android解決The APK file app-debug.apk does not exist on disk.AndroidAPKAPP
- o2cb_ctl: Cluster "ocfs2" does not exist 錯誤解決
- [20211231]ORA-01418 specified index does not exist.txtIndex
- IBM x-346 "planar PCI does not respond or is disabled by user" 解決方法IBM
- Property [title] does not exist on this collection instance
- Waring: /dev/centos/swap does not existdevCentOS
- PatchObject constructor:Input file does not existObjectStruct
- git中出現”the requested upstream branch ‘origin/master‘ does not exist“問題的解決GitAST
- 解決Spark讀取Hive分割槽表出現Input path does not exist的問題SparkHive
- The specified JRE installation does not exist m2eclipse build Maven專案報錯的問題EclipseUIMaven
- 安裝kernel...src.rpm錯誤:warning: user mockbuild does not exist - using rootMockUI
- Kill all sessions of a specified user nameSession
- PSQLexception: ERROR : type "signed" does not existSQLExceptionError
- Laravel Class env does not exist 問題排查Laravel
- SNMP TABLE ERROR : Requested table is empty or does not existError
- ORA-00942: table or view does not existView
- FAQ:Field DATABASE does not exist; see long textDatabase
- Check table 169P: entry XXXX does not exist的解決
- No input file specified 解決方法
- relation with OID 637165 does not exist
- Xlib: connection to ":0.0" refused by server Xlib: No protocol specified解決方案ServerProtocol
- VSFTPD錯誤的解決 500 OOPS: vsftpd: cannot locate user specified in ftp_usernaFTPOOP
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解決辦法ErrorMySql
- ORA-04043: object DBA_DATA_FILES does not existObject
- ORA-04042 procedure, function, package, or package body does not existFunctionPackage