How can i remove the database prefix when creating a database in mysql?

Category: Cpanel

wesley
Asked:
2013-06-21 12:38 pm EST

Hits: 1,176

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

You must login before you can submit an answer.

for shared hosting. (the business plan)
wesley
8 Points
2013-06-21 12:44 pm EST

OTHER ANSWERS

0

Arn
Staff
16,801 Points
2013-06-21 1:21 pm EST
Hello Wesley,

Thanks for your question. Unfortunately, the database prefix cannot be removed. It is required as part of making the database unique on a shared server.

If you have any further questions or concerns please let us know.

Regards,
Arnel C.

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

I am aware that you can change it on cpanel using the cpanel.config file. Is there a cpanel-config file for users on a shared server?
wesley
8 Points
2013-06-21 2:10 pm EST
Hello Wesley,

The cpanel config file cannot be modified by users on a shared server, and the cpanel username is part of the database prefix, for example:
userna99_

You can however, create separate cPanel accounts on a reseller account (VPS or Dedicated Server), and each cpanel can have a different username and database prefix to match.

Also, with a VPS or Dedicated server with Root access, or MySQL Root access, you have the ability to change the database prefix, or created databases. You can request MySQL root by sending an email request to live support at: support@inmotionhosting.com, be sure to include either your current Amp password, or the last 4 digits of the current credit card that we have on file for verification.

If you have any further questions, feel free to post them below.
Thank you,

-John-Paul
johnpaulb-imhs1
8,991 Points
Staff
2013-06-24 10:51 am EST
Like this Question?

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!