Hendrik Posted May 24, 2011 Share Posted May 24, 2011 Hi Support, Server: johnny Domain: ngs.is Username: tazan About 2 weeks ago i had no problems with dropping stored procedures in the database, but now i cannot drop my procedures. Why is that so? Best Regards, Hendrik Quote Link to comment Share on other sites More sharing options...
Guest Geoff Posted May 24, 2011 Share Posted May 24, 2011 What are the procedures you are trying to drop? Quote Link to comment Share on other sites More sharing options...
Hendrik Posted May 25, 2011 Author Share Posted May 25, 2011 What are the procedures you are trying to drop? I was trying to drop stored procedures. EDIT: I get the following error: #1370 - alter routine command denied to user 'tazan_ngsis'@'localhost' for routine 'tazan_ngsis.new_routine' Hendrik Quote Link to comment Share on other sites More sharing options...
Golden Chang Posted May 25, 2011 Share Posted May 25, 2011 Hi, I google it and found this: http://webyog.com/faq/content/26/28/en/why...n-sql_file.html This is a privilege issue. You will probably get the error 1044 "Access denied ..." or 1370 "Alter routine command denied to user ...". Data are imported OK, Views too, but Stored Procedures and Functions are not. The reason is that the user does not have the CREATE ROUTINE or ALTER ROUTINE privileges as of MySQL 5.x. On some MySQL version those privileges are not available as global privileges (except for 'root'@'localhost'). This has been reported as a bug with early MySQL 5.0 versions. I'm not really sure how to solve this, but I think there is something wrong with your privileges. Maybe you should try giving all privileges to your MySQL user of that database. Quote Link to comment Share on other sites More sharing options...
Hendrik Posted May 25, 2011 Author Share Posted May 25, 2011 It was actually working about 2 weeks ago, when i could drop the tables from phpAdmin, but not alter the tables from the MySQL Workbench Quote Link to comment Share on other sites More sharing options...
Golden Chang Posted May 25, 2011 Share Posted May 25, 2011 Hi, I have tried to drop and alter the tables from both MySQL Workbench & phpAdmin and it work perfectly from my end. I think it's not the privileges problem because I still can drop my table from phpAdmin though I didn't give the DROP privilege to my MySQL user. Quote Link to comment Share on other sites More sharing options...
Guest Geoff Posted May 25, 2011 Share Posted May 25, 2011 Try creating a new user and granting all privileges. Quote Link to comment Share on other sites More sharing options...
Hendrik Posted May 26, 2011 Author Share Posted May 26, 2011 I see that i accidentally wrote that i can't drop tables in my previous post, but that ain't the case. It is the stored procedures i cannot drop, which i could do 2 weeks ago. For some reason back then i could not drop the procedures from MySQL Workbench but i could do it from phpAdmin, therefore i had no problems, but now i cannot drop them even from control panel phpAdmin. I know that you have previously mentioned that it is due to some sort of a MySQL 5.x bug. But what confuses me is that why was i able to do the dropping before anyway even though there was a bug :S Quote Link to comment Share on other sites More sharing options...
Hendrik Posted May 26, 2011 Author Share Posted May 26, 2011 thanks for your help guys. i have found the problem, it was from my side thank you for your patience Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.