Procedure support MySQL

Category: Databases

Xtreem0
Asked:
2012-06-29 2:00 am EST

Hits: 607
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.

Hi
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...
Shubham_myworkforce
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.
JeffMa
4,058 Points
2014-01-08 09:31 am EST

OTHER ANSWERS

0

Scott
Staff
10,078 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?
Write New!
Do you want to publish a tutorial to our support center?

News / Announcements

SSL Certficate Warnings
Updated 2014-04-14 11:34 am EST
Hits: 2170
Heartbleed 0-day OpenSSL security bug
Updated 2014-04-14 04:43 pm EST
Hits: 5565

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

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: support@InMotionHosting.com
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!