Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL username needs to include an underscore. Restoring from backup from another server.

Discussion in 'Database Discussion' started by nitdna, Jun 18, 2014.

  1. nitdna

    nitdna Member

    Joined:
    Nov 13, 2013
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Howdy

    I have a back up of an account from another server. This backup contains zipped public_html folders/files and the .sql Database. Site is Joomla.

    Problem is the database username contains an underscore (aco_net_mo) and this is referenced throughout multiple files.

    I have tried to find and edit the files that reference the DB username, but the site still will not load correctly, seems like I am missing some of the references.

    Is there a way I can use an underscore when creating the username for the Database?

    Would be much easier if I could keep the DB name and the username the same as before and hopefully site will display correctly.
     
    #1 nitdna, Jun 18, 2014
  2. nitdna

    nitdna Member

    Joined:
    Nov 13, 2013
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Just a quick update:

    Found the last reference to the DB username. It was in one of the tables in the Database. So working now!
    Would still like to know though if it is possible to include an underscore in the database username.
     
    #2 nitdna, Jun 19, 2014
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,856
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    You can rename databases and database usernames via the following options:

    "WHM Home » SQL Services » Manage Databases"
    "WHM Home » SQL Services » Manage Database Users"

    Note that internal case number 58454 is open to address the ability to create database users with underscores in the cPanel UI. There is currently no time frame on a resolution to that case, but feel free to monitor our change logs for it's inclusion.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 cPanelMichael, Jun 19, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL username needs
  1. tyuuu

    mysql_pconnect can not work after change password/username

    tyuuu, Jun 19, 2018, in forum: Database Discussion
    Replies:
    10
    Views:
    119
    cPanelLauren
    Jun 20, 2018
  2. MarkoTitel

    SOLVED Account restoration mysql username too long

    MarkoTitel, Apr 17, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    1,703
    MarkoTitel
    Apr 19, 2017
  3. DanH42

    MySQL username prefix not being truncated

    DanH42, Nov 1, 2016, in forum: Database Discussion
    Replies:
    6
    Views:
    591
    cPanelMichael
    Nov 7, 2016
  4. navhost

    reinstalling mysql

    navhost, Aug 16, 2018 at 3:32 PM, in forum: Database Discussion
    Replies:
    2
    Views:
    88
    cPanelMichael
    Aug 17, 2018 at 12:14 PM
  5. planetjoin

    From mysql 5.7 to MariaDB 10.0.34 manually

    planetjoin, Aug 11, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    107
    cPanelMichael
    Aug 16, 2018 at 10:26 AM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice