Transferred DB to New Host, Help!

Discussion in 'MySQL' started by mohms, Sep 11, 2008.

  1. #1
    Hi all, I don't know much about mysql, and I have a question. I transferred my site to a new host along with the database using the cpanel backups. The account info from my old host to my new is different. The old user was mohms_mohms, and the new is mattohms_mohms.

    The script/database is still looking for the user mohms_mohms. Is there a way I can change it to mattohms_mohms without reinstalling the script?

    Thanks
     
    mohms, Sep 11, 2008 IP
  2. wootty

    wootty Peon

    Messages:
    447
    Likes Received:
    22
    Best Answers:
    0
    Trophy Points:
    0
    #2
    depends on what script you're using but somewhere it will almost certainly have a config file where the database connection parameters have been specified (config.php for example). You would need to find this file, and edit it to reflect the new database name, username, password etc.
     
    wootty, Sep 11, 2008 IP
    mohms likes this.
  3. mohms

    mohms Active Member

    Messages:
    291
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    58
    #3
    THANKS WOOTY!!! You just got a green ;)

    Cant believe it was that easy.
     
    mohms, Sep 11, 2008 IP