I do not want to use prefixes with the MySQL database or user

Category: Databases

2013-09-19 7:48 pm EST

Hits: 993
I need to create databases without the built in prefixes.
I need to create users without the built in prefixes
I need to be able to grant priviledges to users
I can see no way to do this in cpanel or phpMyAdmin
Where can these things be done?

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

You must login before you can submit an answer.



10,527 Points
2013-09-19 7:59 pm EST
Hello ASI_it,

Thanks the question! Unfortunately, the only way you can do this would be to have root access on a dedicated or VPS server. You can already edit user privileges in the MySQL manager in cPanel. You will not be able to avoid using user name or database prefixes because your account is capable of hosting multiple accounts that can have multiple databases and users. The prefix system is used to account for these possibilities.

I hope this helps to answer your question! Please let us know if you have any further questions or comments.

Arnel C.

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

I am on a dedicated server and it was my understanding we would not be sharing our database or anything else. If this is not so we will have to cancel the account.
I will call sales tomorrow
26 Points
2013-09-19 8:06 pm EST
Hello ASI_it,

As per my answer, this is definitely possible on a dedicated server. I couldn't find an account based on your Support Center login, so I had no way of determining if you were on a dedicated server or vps.

If your account is a Dedicated server, then you will need to Login to WHM, go to the SQL services, and select the DISABLE DATABASE PREFIX option. After this option is set, you can go into your cPanel and setup the database without the prefix.

I hope this helps to clarify the issue.

Arnel C.
10,527 Points
2013-09-19 9:14 pm EST

Just to explain further: Dedicated servers and VPS accounts are capable of hosting multiple accounts. That is why the prefix system is in place. If you are on a dedicated server, it is possible to disable the prefix system. Shared server accounts require the prefix system so that multiple databases under one account can be identified.

Arnel C.
10,527 Points
2013-09-19 9:19 pm EST
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: 2037
Heartbleed 0-day OpenSSL security bug
Updated 2014-04-14 04:43 pm EST
Hits: 5358

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: 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!