Search code examples
mysqldatabasephpmyadmin

CREATE ALGORITHM=UNDEFINED DEFINER

I make a backup of some database from distance server, and I had an problem on my local server when I trying to import that backup. I get an error in this line:

CREATE ALGORITHM=UNDEFINED DEFINER=root@% SQL SECURITY DEFINER VIEW tematics_field AS select.....

Both server have a mysql 5.5.2x. And users are different in that two servers.

Solution

  • You need to put the hostname (or wildcard in this case) in single-quotes:

    CREATE ALGORITHM=UNDEFINED DEFINER=root@'%' SQL SECURITY DEFINER VIEW tematics_field AS 
select.....