InMotion Hosting Support Center

Procedure support MySQL

Category: Databases

2012-06-29 2:00 am EST

Hits: 835
My site currently uses procedures in mysql to do mutli querys etc, When i try to create one in the MySQL server in inMotion I get the message that I need super admin status. Is there any way around this issue?

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

You must login before you can submit an answer.

i have my site hosted on inmotion server and it uses mysql procedures to access database bt now m unable to alter my procedures through mysql workbench i have got this problem previously and it was resolved by changing ip but now it doesn't seems to be same its not working
Plz reply if anyone can help...
0 Points
2014-01-08 03:02 am EST
Hello Shubham_myworkforce,

As Scott said in the answer below, MySQL procedures will not work within a shared hosting environment and you will need root access to use them. If you are on a VPS or dedicated server, be sure that you are using the correct credentials to connect to MySQL as root.
11,186 Points
2014-01-08 09:31 am EST



43,761 Points
2012-06-29 9:06 am EST
Hello Xtreem0,

There are some things that do indeed require Super Admin status for MySQL such as procedures, triggers, etc. These are not available on shared servers as that access is not allowed on our shared servers. It can be done, however, on our VPS and Dedicated server plans.

I hope this answers your question. If you have any more questions or information specific to the issue please leave a comment below so we can further assist you.

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!