Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MySQL behaves inconsistently
Posted on 2011-09-02
I need to modify stored procedure that I created myself, and I get this error using MySQL Workbench on Windows:
Error Code 1227 Acees Denied; you need the SUPER priviledge for this operation.
I can do this with no problem from a UNIX machine. Any idea?
Error Code 1227 Acees Denied; you need the SUPER priviledge for this operation.
I can do this with no problem from a UNIX machine. Any idea?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
3
9 Comments
Active 2 days ago
What credentials are you using to connect with through MySQL Workbench and is that set to proper permissions? i.e., is it possible permissions are accidentally set allowing some operations, but not others.
Here is a reference on the individual permissions:
http://dev.mysql.com/doc/refman/5.5/en/privileges-provided.html
If these were recently changed, you may simply need to run FLUSH PRIVILEGES and try again.
Here is a reference on the individual permissions:
http://dev.mysql.com/doc/refman/5.5/en/privileges-provided.html
If these were recently changed, you may simply need to run FLUSH PRIVILEGES and try again.
It is the same MySQL account as what I use on UNIX. Does MySQL Workbench do anything special with permissions that would cause error above? I can't see any evidence pointing to this from its GUI.
Active 2 days ago
Where is the physical MySQL server located? i.e., is it Windows or MySQL. When you say the same account, it makes me think we are talking about querying the same exact MySQL server just once from a UNIX client and other from a Windows one, is that right?
My initial read was you previously had MySQL server setup on UNIX and now you have it on Windows and it is behaving differently. Operating System login and privileges are not the same as MySQL privileges; therefore, I was curious if that was the root cause.
If on the other hand, it is something in the stored procedure that making a call to underlying file system and it is literal meaning UNIX SUPER user, then may need to look at the actual stored procedure code to find your issue. I have not seen that, but then again I am not a heavy UNIX user. If the MySQL server is hosted on the same UNIX box that this works on, maybe the user there has su privileges and so whatever process the procedure invokes has rights it needs versus coming from Windows it does not. I would not think that would matter as it would run as whatever account is running the MySQL daemon, but again I am not anywhere close to an UNIX Expert.
My initial read was you previously had MySQL server setup on UNIX and now you have it on Windows and it is behaving differently. Operating System login and privileges are not the same as MySQL privileges; therefore, I was curious if that was the root cause.
If on the other hand, it is something in the stored procedure that making a call to underlying file system and it is literal meaning UNIX SUPER user, then may need to look at the actual stored procedure code to find your issue. I have not seen that, but then again I am not a heavy UNIX user. If the MySQL server is hosted on the same UNIX box that this works on, maybe the user there has su privileges and so whatever process the procedure invokes has rights it needs versus coming from Windows it does not. I would not think that would matter as it would run as whatever account is running the MySQL daemon, but again I am not anywhere close to an UNIX Expert.
Active 2 days ago
Okay, here is a reference that supports my original question on credentials.
http://mark.koli.ch/2010/05/mysql-triggers-and-super-privileges-access-denied-you-need-the-super-privilege-for-this-operation.html
I am pretty sure that is what we are dealing with her, but the UNIX bit is throwing me off since SUPER user means something there also. :) I would stay in the MySQL realm, though, and recheck the permissions. Or better yet, reapply them since this worked at one point.
http://mark.koli.ch/2010/05/mysql-triggers-and-super-privileges-access-denied-you-need-the-super-privilege-for-this-operation.html
I am pretty sure that is what we are dealing with her, but the UNIX bit is throwing me off since SUPER user means something there also. :) I would stay in the MySQL realm, though, and recheck the permissions. Or better yet, reapply them since this worked at one point.
Active 2 days ago
Sorry for the extra e-mail. Another possible cause along same line is if you set the DEFINER (I tend not to), that connecting remotely with same user may still result in error if the connection is not being interpreted as the exact same scope, i.e., if defined as 'you'@'localhost'; 'you'@'windows PC' is a totally different person. This was mentioned with SSH and shared hosting environment, but might be worth looking at. I am having no difficulties on my Windows machine with MySQL; however, I do not create my procedures with DEFINER specified typically as I am typing query directly versus using a GUI and so that is more keystrokes. *smile*
Reference: http://www.hostingrails.com/MySQL-Error-1227-Access-Denied-you-need-SUPER-privilege-for-this-operation
Reference: http://www.hostingrails.com/MySQL-Error-1227-Access-Denied-you-need-SUPER-privilege-for-this-operation
Featured Post
It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.
See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar.
Int…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 6 hours left to enroll
635 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.