search

Home >Database >Mysql Tutorial >mysql error 1370解决办法_MySQL

mysql error 1370解决办法_MySQL

WBOY
WBOYOriginal
2016-06-01 13:45:543563browse

bitsCN.com

调用存储过程时报了下面的错误
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;

bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql 性能优化方案_MySQLNext article：同机MySQL主从同步设置_MySQL

Related articles

See more