: How do I disable username prefixes on mySQL databases? 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

@Rivera981

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

Vote Up Vote Down

@Cugini213

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: kb.iweb.com/entries/21073657-how-can-i-repair-my-databases

Vote Up Vote Down