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

nitdna

Member
Nov 13, 2013
17
0
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.
 

nitdna

Member
Nov 13, 2013
17
0
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
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.