Zen Cart Logo
Forums / General Questions / Changing username in cPanel loses database

Changing username in cPanel loses database

Views: 505

Results 1 to 4 of 4
21 May 2013, 11:33 PM
#1
esugrue avatar

esugrue

Zen Follower

Join Date:
Jun 2004
Posts:
182
Plugin Contributions:
0

Changing username in cPanel loses database

Hi

I am moving hosting providers and did a cPanel migration (well they did); however as the username for the domain was already in use I had to change it to another hence the MySql database name changed eg:

oldsite_zcart13 to
newsite_zcart13

This means when I go to the site I now get a `If this is your first time ... message about not able to connect to database etc.

If I change the database name in the 2 places in each of the includes/ and admin/includes configure files should that fix the problem, or will it be easier to try and change the original domain to another and theis domain username back to `oldsite'.

Thanks
Ernie

21 May 2013, 11:46 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Changing username in cPanel loses database

Look in cpanel under the database icon

Use that db name in your 2 configure.php files

Also check the db user names & passwords and it might be best to create new user & pass

These also need to be updated in your configure files

22 May 2013, 12:17 AM
#3
esugrue avatar

esugrue

Zen Follower

Join Date:
Jun 2004
Posts:
182
Plugin Contributions:
0

Re: Changing username in cPanel loses database

Hi Kobra:

I did a backup of the new database just in case (as on my old provider I did something and the database now shows 0.00 Mb).

I replaced the old user with the new one - in both the database entries as well as the paths in the 2 configures.

I don't know if you can help with this one, but I have updated DNS and it seems to have propagated through, however in WHM under the DNS Zone it shows some remnants of the old NS entries - can I update these manually without messing things up?

22 May 2013, 2:41 AM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Changing username in cPanel loses database

That is a server issue and not a ZenCart Issue
Suggest that you look somewhere else for a solution