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).
DB Preﬁxing is determined by the database_preﬁx value deﬁned in /var/cpanel/cpanel.conﬁg.
• A value of “1” denotes that DB Preﬁxing is enabled and will emulate preﬁxing behavior prior to DB Mapping.
• A value of “0” denotes that DB Preﬁxing is disabled and all database resources created by cPanel accounts will be created literally as requested.
• The absence of a database_preﬁx deﬁnition will behave as if a value of “1” existed.
Manually modifying cpanel.conﬁg is HIGHLY DISCOURAGED and can produce unexpected behaviors. WHM provides the necessary UI for setting DB Preﬁxing to “0,” “Off” but forr Cpanel you have to do it manually .
Operating cPanel systems with Preﬁxing “Off” can introduce an artiﬁcially 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
In WHM, there's a section of the menu called
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