Results 1 to 5 of 5
  1. #1
    Join Date
    May 2008
    Posts
    259
    I've been at it for a while, but I just can't seem to get the syntax right on granting execute permission on stored procedures to my MySQL user.
    I've tried to track down examples online, and tried to figure it out from the MySQL website docs, but I still can't seem to get it to work.
    I'm trying to do something like this inside the MySQL Query Browser:
    grant execute on *.* to 'my_username'
    If I try a wildcard, I get the error 1045 - Access denied for (insert user here)
    If I try it on a specific stored procedure, I get the error 1144 - Illegal GRANT/REVOKE command.
    I'm an MSSQL guy, and this is my first go at using MySQL, so bear with me gang
    Thanks for any help you can provide.

  2. #2
    Join Date
    May 2008
    Location
    FL
    Posts
    337
    What user are you using to grant the permissions?

  3. #3
    Join Date
    May 2008
    Posts
    259
    What user are you using to grant the permissions?
    Executing a query inside of the code window in MySQL Query Browser

  4. #4
    Join Date
    Jun 2006
    Posts
    1,111
    Which user are you logged in as when using MySQL query browser though? I don't use the application myself so can't tell you how to find out on there, but run this query:
    status
    then, look at "Current user:"

  5. #5
    Join Date
    May 2008
    Posts
    259
    I executed "status" and it threw an error as well. Maybe query browser isn't the right place to do this? It seems very similar to MS Sql Query Analyzer, so it seems the proper place to execute commands like this.
    But like I said, I'm just getting started with MySQL. I haven't had any problems yet using Administrator to build tables and such, but I'm a bit stuck at this point. I definitely want to use stored procs, so I'll keep digging, the answer is out there somewhere
    But do directly answer your question, I'm using the only user that I created for the database.

  6. Newsletters

    Subscribe Now & Get The WHT Quick Start Guide!

Related Posts from theWHIR.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •