paddyhaig Posted June 7, 2010 Share Posted June 7, 2010 What's going on here. I have a local mySQL database and a remote mySQL database both use to sync just fine, but now I am getting this error. Can antone tell me why and how I can stop it? I have been syncing this db for weeks without any problems. Error SQL query: Documentation /*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`oninacom_onina`@`localhost` SQL SECURITY DEFINER VIEW `test` AS (select `auth`.`id` AS `id`,`auth`.`first_name` AS `first_name`,`auth`.`last_name` AS `last_name`,`auth`.`login` AS `login`,`auth`.`password` AS `password`,`auth`.`privilege` AS `privilege` from `auth`) */; MySQL said: Documentation #1227 - Access denied; you need the SUPER privilege for this operation Link to comment https://forums.phpfreaks.com/topic/204083-1227-access-denied-you-need-the-super-privilege-for-this-operation/ Share on other sites More sharing options...
trq Posted June 7, 2010 Share Posted June 7, 2010 The error is pretty self explanatory. The user you are using doesn't have sufficient permissions to execute the query Link to comment https://forums.phpfreaks.com/topic/204083-1227-access-denied-you-need-the-super-privilege-for-this-operation/#findComment-1068918 Share on other sites More sharing options...
paddyhaig Posted June 7, 2010 Author Share Posted June 7, 2010 I remember know what it is!!! I had experimented with views on my local system and had an experimental view in the views folder and had forgotten about it. I guess my remote db provider doesn't like views. So when I came to sync the two data bases, I was getting rejected because of the view. How's that look??? Link to comment https://forums.phpfreaks.com/topic/204083-1227-access-denied-you-need-the-super-privilege-for-this-operation/#findComment-1068990 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.