Jump to content

Php And Stored Procedures


Recommended Posts

I have TOAD for MySQL which I use to connect to my databases.

 

I have noticed that the Procedures tab reports:

SELECT command denied to user [My remote user name is here] for table 'proc'

 

The goal for me was to use Toad for easier database control. Is there any chance I could have that functionality added, or am I just missing something easy? I am well versed in TOAD when connecting to ORACLE DBs, so I am confused. Thanks! Once i can get to using Procedures in MySQL, life will be so much easier.

 

Added:

 

Also noticed that when I create a Stored Procedure and then attempted to delete it (DROP PROCEDURE IF EXISTS `PROCEDURE_NAME`:rolleyes:

I received error:

"alter routine command denied to user 'MY REMOTE USERNAME HERE' for routine 'DATABASE.PROCEDURE_NAME'

 

(The proper UserName, Database and ProcedureName were listed in teh above error, I've hidden them for my own piece of mind)

Edited by erisande
Link to post
Share on other sites

Have you added the username you are using to the users allowed full access to your database ? ( You can do that in cpanel, in the database section).

 

You will also need to enable remote access there, but as long as you are accessing some of the tables ( which it sounds as if you have) then you have enabled remote access.

Link to post
Share on other sites

Yes, I did. That is why I am confused.

The oddity is that I can create SPs using in the SQL editor, but I can't seem to delete them unless I go in through MyPHPAdmin. I am going to try and write a SP and use it in my site just to assure it is all possible, but it would make it easier if I could use TOAD.

 

I know you are (most likely) not specialists with TOAD, but I was hoping someone may figure something out which I may be missing. Thanks for any help you can provide! If you have other suggestions on DB visualizers/apps, let me know! Toad just gives me some cool tools to use, and I am used to the app which helps tremendously.

Link to post
Share on other sites
  • 3 weeks later...
Yes, I did. That is why I am confused.

The oddity is that I can create SPs using in the SQL editor, but I can't seem to delete them unless I go in through MyPHPAdmin. I am going to try and write a SP and use it in my site just to assure it is all possible, but it would make it easier if I could use TOAD.

 

I know you are (most likely) not specialists with TOAD, but I was hoping someone may figure something out which I may be missing. Thanks for any help you can provide! If you have other suggestions on DB visualizers/apps, let me know! Toad just gives me some cool tools to use, and I am used to the app which helps tremendously.

 

I've found similar behaviour without using TOAD. I can create procedures but cannot drop them except through phpMyAdmin. Is there any way to grant this privilege so I can drop tables through the MySQL command-line client "mysql"?

 

Thanks, Richard.

Link to post
Share on other sites
  • 3 months later...

I am again attempting to work with stored procedures. I found some information that we need to have access to the 'proc' table

http://dev.mysql.com/doc/refman/5.0/en/sto...privileges.html

 

Is there any way we can open this ability on the site so I can begin writing some great code? :) I know I can make my application a bit better if I had access to this kind of thing.

 

Thanks for responses!

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...