Php And Stored Procedures

[erisande]

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`

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 December 11, 2007 by erisande

[TCH-Andy]

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.

[erisande]

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.

[OpiumTrail]

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.

[erisande]

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!

[TCH-Thomas]

This would be a question for the techs so please open a ticket and they will tell you.

[erisande]

Alrighty, will do. Thanks! I feel I can do more proper coding with those SPs, so this will be cool!

Thanks!