HELP! mysql db's dont show after username modification

[kappler0]

Hi-
(using WHM - I have a reseller account - no root access)

We modified a clients username per his request - the problem is that none of his mysql db's show in cpanel - nor will they appear in phpmyadmin

They are somewhere though - the sites still work using the db's information, but we just cant get to them-

please advise what we can do to get to them to at least create back-ups.... thanks
Scott

 

[bamasbest]

Hmm... a few options come to mind that would probably work.

1. cPanel ties the databases for users with their usernames. Your Host can change the username for database access to reflect your user's new name. This WILL probably entail your user having to edit his scripts to point to the new database name.

2. They should be able to install their own phpmyadmin in their own space, configured to point to the old databasename with the old database passwords.

There may be other solutions as well. But this would be the appropriate punishment for your user for wanting to change their name and not just their password

 

[fishfreek]

cpanel prefixes the username on any database owned by that user. In the change name script it appears that the databases didnt get changed.

In the directory that holds the acutal mysql database files you can rename the databases to change the name from oldusername_datbasename to newusername_databasename.

This should allow the databases to now appear in cpanel properly. Your client will then have to edit all their scripts to point to the new datbase name.