InMotion Hosting Support Center

Modifying a MySQL View in phpMyAdmin

Category: Databases

2013-01-08 2:25 pm EST

Hits: 1,580
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.


You must login before you can ask a follow up question.

You must login before you can submit an answer.

Best answer chosen by User


43,761 Points
2013-01-08 2:38 pm EST
Hello Jeff,

That may be possible depending on the type of server the site is on. You will want to post this type of question to our support department. To do so, please email them at with the domain name so they can check the server. Any other details regarding the phpMyAdmin, Table, View, etc would be helpful. Also, to make any necessary changes, you will need to verify the account with either the current AMP password or the last 4 digits of the credit car on file.

Best Regards,
Scott M

You must login before you can post a comment about this answer.

Like this Question?

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!