How To Disable Database Prefix

Zardiw

• September 22, 2017 15:53

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

• 

  cPanelMichael

  • September 22, 2017 21:43

  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
• 

  DennisMidjord

  • September 23, 2017 09:12

  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
• 

  cPanelMichael

  • September 25, 2017 17:57

  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
• 

  cPanelMichael

  • September 27, 2017 15:56

  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
• 

  cPanelMichael

  • October 09, 2017 16:35

  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.