I have TOAD for MySQL which I use to connect to my databases.<br /><br />I have noticed that the Procedures tab reports:<br />SELECT command denied to user [My remote user name is here] for table 'proc'<br /><br />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.<br /><br /><b>Added:</b><br /><br />Also noticed that when I create a Stored Procedure and then attempted to delete it (DROP PROCEDURE IF EXISTS `PROCEDURE_NAME`
<br />I received error:<br /> "alter routine command denied to user 'MY REMOTE USERNAME HERE' for routine 'DATABASE.PROCEDURE_NAME'<br /><br />(The proper UserName, Database and ProcedureName were listed in teh above error, I've hidden them for my own piece of mind)<!--content-->
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). <br /><br />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.<!--content-->
Yes, I did. That is why I am confused.<br />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.<br /><br />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.<!--content-->
<!--quoteo(post=217520:date=Dec 11 2007, 04:44 PM:name=erisande)--><div class='quotetop'>QUOTE (erisande @ Dec 11 2007, 04:44 PM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=217520"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->Yes, I did. That is why I am confused.<br />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.<br /><br />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.<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />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"?<br /><br />Thanks, Richard.<!--content-->
I am again attempting to work with stored procedures. I found some information that we need to have access to the 'proc' table<br /><a href="http://dev.mysql.com/doc/refman/5.0/en/stored-procedure-privileges.html" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/sto...privileges.html</a><br /><br />Is there any way we can open this ability on the site so I can begin writing some great code? <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /> I know I can make my application a bit better if I had access to this kind of thing.<br /><br />Thanks for responses!<!--content-->
This would be a question for the techs so please open a ticket and they will tell you. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="" border="0" alt="smile.gif" /><!--content-->
Alrighty, will do. Thanks! I feel I can do more proper coding with those SPs, so this will be cool!<br />Thanks!<!--content-->
<br />I received error:<br /> "alter routine command denied to user 'MY REMOTE USERNAME HERE' for routine 'DATABASE.PROCEDURE_NAME'<br /><br />(The proper UserName, Database and ProcedureName were listed in teh above error, I've hidden them for my own piece of mind)<!--content-->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). <br /><br />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.<!--content-->
Yes, I did. That is why I am confused.<br />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.<br /><br />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.<!--content-->
<!--quoteo(post=217520:date=Dec 11 2007, 04:44 PM:name=erisande)--><div class='quotetop'>QUOTE (erisande @ Dec 11 2007, 04:44 PM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=217520"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->Yes, I did. That is why I am confused.<br />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.<br /><br />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.<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />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"?<br /><br />Thanks, Richard.<!--content-->
I am again attempting to work with stored procedures. I found some information that we need to have access to the 'proc' table<br /><a href="http://dev.mysql.com/doc/refman/5.0/en/stored-procedure-privileges.html" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/sto...privileges.html</a><br /><br />Is there any way we can open this ability on the site so I can begin writing some great code? <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /> I know I can make my application a bit better if I had access to this kind of thing.<br /><br />Thanks for responses!<!--content-->This would be a question for the techs so please open a ticket and they will tell you. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /><!--content-->Alrighty, will do. Thanks! I feel I can do more proper coding with those SPs, so this will be cool!<br />Thanks!<!--content-->