Modifying a MySQL View in phpMyAdmin
I am trying to fix a client website and I believe the problem is his views were created with a definer that is no longer in the system. From what I can tell there is no way I can alter a view through phpMyAdmin based on inmotion's security settings. How can I change the definer on the view (or the security type)? Thanks.