I know of the potential risks.

The only "useful" thing I've been able to find after Google-ing is this, on the cPanel website, which has no context whatsoever.

Does anyone know how to do this?

My version of cPanel is 11.32.2 (build 28).

2 Answers 2


DB Prefixing is determined by the database_prefix value defined in /var/cpanel/cpanel.config.

  • • A value of “1” denotes that DB Prefixing is enabled and will emulate prefixing behavior prior to DB Mapping.

  • • A value of “0” denotes that DB Prefixing is disabled and all database resources created by cPanel accounts will be created literally as requested.

  • • The absence of a database_prefix definition will behave as if a value of “1” existed.

Manually modifying cpanel.config is HIGHLY DISCOURAGED and can produce unexpected behaviors. WHM provides the necessary UI for setting DB Prefixing to “0,” “Off” but forr Cpanel you have to do it manually .

PS :

Operating cPanel systems with Prefixing “Off” can introduce an artificially frequent occurrence of “name collision” when creating cPanel accounts and cpuser database resources. Because arbitrary names are allowed, the probability that common names are requested will increase and therefore the denial to use those names will also increase

  • That's fine. It's only me that has access to my website anyway. Do you happen to know how I gain access to the config file? I can't see the path through an FTP client. Commented Jun 4, 2012 at 21:59
  • If you are using sharing hosting , you probably can't access it. the admin will not allow you to access config file.
    – panindra
    Commented Jun 5, 2012 at 3:00
  • Nevermind. Apparently my hosting plan doesn't include access to WHM or these settings. Thanks anyway, though. Commented Jun 5, 2012 at 16:35

In WHM, there's a section of the menu called SQL Services.

Go into it, and then find: Disable Database Prefix.

This page has a screenshot of that screen: http://kb.iweb.com/entries/21073657-how-can-i-repair-my-databases

  • Edit: Nevermind. It didn't occur to me straight away that WHM is its own site. Thanks, I'll try that now. Commented Jun 4, 2012 at 21:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.