SQL Error 1227:access denied; You need the SUPER privilege for this operation

Today, my colleague told me that the view he had built on MySQL was not able to be changed, and the following error was reported:

SQL Error 1227:access denied; You need the SUPER privilege for this operation

At first, I thought it was the authority of the question, checked for a half-day, the authority is clearly some, added the following two licensing conditions, or not:

Grant Operation MySQL View, view source code permissions:
Grant CREATE view on testdb.* to [email protected]' 192.168.0.% ';
Grant Show view on testdb.* to [email protected]' 192.168.0.% ';

In the end, there is no way to create a new view, can be created successfully, but also can change their own newly created view, which indicates that the user's permissions are not a problem; the last thought of that should be to create the view definition of the problem of people, to look at, sure enough, these views are created with the same user name, But previously authorized is the original company's public network IP, recently the company's public network IP has been caused, changed the definition of the person, after the fix, such as:

650) this.width=650; "title=" QQ picture 20140919173812.jpg "alt=" wkiol1qb-cbcywgpaaf5yyaseje925.jpg "src="/http S3.51cto.com/wyfs02/m02/49/da/wkiol1qb-cbcywgpaaf5yyaseje925.jpg "/>

This article is from the "Square Hill" blog, please be sure to keep this source http://63638790.blog.51cto.com/513514/1555264

SQL Error 1227:access denied; You need the SUPER privilege for this operation