`

mysql --------for routine错

 
阅读更多
调用存储过程时报了下面的错误
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;
分享到：
| mysql存储--游标
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    Devart dbForge Studio for MySQL Professional Edition v7.1.13

    dbForge Studio for MySQL is a universal GUI for managing, developing and administrating MySQL and MariaDB databases. The tool allows to create and execute queries, develop and debug routines, automate...

    MySQL for Visual Studio 2.0.4官方版

    MySQL for Visual Studio provides access to MySQL objects and data using Microsoft Visual Studio. MySQL for Visual Studio provides: Design Time Support Query Designer Stored Routine Debugging Entity ...

    Pro.MySQL.NDB.Cluster

    Database administrators and developers who are looking into deploying MySQL NDB Cluster, or who already have a cluster in production and want to increase their knowledge and ability to handle routine ...

    Beginning PHP and MySQL: From Novice to Professional, 5th Edition

    Gain skills in MySQL’s fundamental features, including supported data types, database management syntax, triggers, views, stored routine syntax, and import/export capabilities Work with hundreds of...

    Foundations for Analytics with Python O-Reilly-2016-Clinton W. Brownley

    By scheduling your scripts to run on a routine basis, you don’t ever forget to run a script and you can scale beyond what’s possible when you’re running scripts manually on the command line. ...

    sqlmap (懂的入)

    * Full support for MySQL, Oracle, PostgreSQL and Microsoft SQL Server database management system back-end. Besides these four DBMS, sqlmap can also identify Microsoft Access, DB2, Informix and ...

    2017_Pro MySQL NDB Cluster.pdf

    The book has been written for database administrators who are looking into deploying MySQL NDB Cluster or already have a cluster in production and want to increase their knowledge to be able to handle...

    drupal 6.12

    line are available in INSTALL.mysql.txt (for MySQL) or INSTALL.pgsql.txt (for PostgreSQL). To create a database using PHPMyAdmin or a web-based control panel consult the documentation or ask your...

    MySQL存储过程的深入讲解（in、out、inout）

    一、简介 从 5.0 版本才开始支持，是一组为了完成特定功能的SQL语句集合（封装），比传统SQL速度更快、执行效率更高。 存储过程的优点 1、执行一次后，会将生成的二进制代码驻留缓冲区（便于下次执行），提高执行...

    Learning Linux Shell Scripting 2nd Edition pdf

    Finally, you'll get to grips with taking backup, using other language scripts in Shell Scripts as well as automating database administration tasks for MySQL and Oracle. By the end of this book, you ...

Magicbox
Global site tag (gtag.js) - Google Analytics