The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

HELP! mysql db's dont show after username modification

Discussion in 'General Discussion' started by kappler0, Mar 21, 2004.

  1. kappler0

    kappler0 Member

    Joined:
    Mar 21, 2004
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  2. bamasbest

    bamasbest Well-Known Member

    Joined:
    Jan 10, 2004
    Messages:
    531
    Likes Received:
    0
    Trophy Points:
    16
    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

    ;)
     
  3. fishfreek

    fishfreek Well-Known Member

    Joined:
    Jan 2, 2004
    Messages:
    238
    Likes Received:
    0
    Trophy Points:
    16
    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.
     
Loading...

Share This Page