Daily Archives: November 7, 2012

When moving mysql databases between machines. It is best if all stored procedures, functions, and views need to have the following line after their create statement: DEFINER=CURRENT_USER SQL SECURITY INVOKER Example: CREATE OR REPLACE DEFINER=CURRENT_USER SQL SECURITY INVOKER VIEW MYVIEW … Continue reading →