How To Disable Database Prefix
From Old Thread:
Quote: "found out, basically need to remove the prefix in WHM settings."
Where exactly is that setting?
Yeah......I know it's an old thread....but information like this doesn't go out of style....most information doesn't go out of style
And Bing seems to think it's relevant since it's the 3rd result.
database prefix cpanel - Bing
Let's see if old thread trolls live on this forum or not........lol
z
Pls don't send me to some white paper where I have to read a million pages....to find an answer to a simple question.
And believe me I've looked for it pretty hard so far.......hence this thread.
z
-
Hello, The following option is available under the "SQL" tab in "WHM >> Tweak Settings": Require a username prefix on names of new databases and database users Per it's description: When this option is enabled, the system will require that the name of each new database or database user from a cPanel session begin with the first eight characters of the system username and an underscore (_). This makes it easier to tell which user owns a given database, but it also restricts the number of characters that users can use for names of databases and database users. Note that if the username changes at a later point, the name of the database or database user does NOT change. Also, while older cPanel API calls automatically add this prefix, newer API calls expect the caller to add it.
Thank you.0 -
1. Login to WHM 2. Select 'Server Configuration' > 'Tweak Settings' 3. Select the 'SQL' tab 4. At the very bottom, there's an option that will fix your issue: 'Require a username prefix on names of new databases and database users' I wouldn't recommend removing it on a shared server, though. 0 -
Hello, Could you run the following commands and let us know the output? cat /usr/local/cpanel/version mysql --version grep database_prefix /var/cpanel/cpanel.config
Thank you.0 -
The version of WHM that your server is provisioned with does not have the option to disable database prefix in its interface.
Can you confirm which version of cPanel is installed on your system? It's found in the upper right header of WHM or by running the following command:cat /usr/local/cpanel/version
Thank you.0 -
Hello, You'd run that command while logged in as the "root" user via SSH. Or, as mentioned in the previous response, it's found in the upper right header of WHM. Thank you. 0
Please sign in to leave a comment.
Comments
5 comments