How do I disable username prefixes on mySQL databases?

Question

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).

Answer 1

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

Answer 2

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