ERROR 1370 (42000): execute command denied to user backupAccount@'localhost' for routine 'databaseNa
来源:互联网 发布:智联招聘 java开发 编辑:程序博客网 时间:2024/06/09 15:44
调用存储过程时报了下面的错误
ERROR 1370 (42000): execute command denied to user backupAccount@'localhost' for routine 'databaseName.spName'
解决办法
对该账户授予执行存储过程的权限
mysql> grant execute on procedure databaseName.spName to 'backupAccount'@'localhost';
mysql> flush privileges;
0 0
- ERROR 1370 (42000): execute command denied to user backupAccount@'localhost' for routine 'databaseNa
- 1370 (42000): grant command denied to user ''@'localhost' for routine 'test.f1'
- ERROR 1142 (42000): INSERT command denied to user 'radius'@'localhost' for table 'radcheck'
- [Err] 1370 - execute command denied to user
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database
- ERROR 1044 (42000): Access denied for user ”@’localhost’ to database
- execute command denied to user...
- ERROR 1142 (42000) at line 6688: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for t
- mysqldump: Got error: 1142: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table
- mysql root 进入出现ERROR 1044(42000):Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ubuntu mysql root 进入出现ERROR 1044(42000):Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
- 【leetcode】Isomorphic Strings
- php设计模式之策略模式
- 软件项目估算之代码行估算方法
- Cassandra in Spring
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解决方法
- ERROR 1370 (42000): execute command denied to user backupAccount@'localhost' for routine 'databaseNa
- JAVA随记(3)
- HTM中的TComPicYuv和TVideoIOYuv类(二)
- 力所能及之ireport 启动错误cannot find java.exe
- #if, #elif, #else, #endif 使用
- scanf、sscanf中的正则表达式
- 再水一道并查集,hdu1856
- The 2015 Concise List of Hacker Tools and videos
- 简单讲述java过滤器在netbeans上的实现