If you are using cPanel, and your username has changed during the switch, most likely the mySQL database details changed.
Go into your wpconfig.php file and edit your database name & username
(ex. whatever_wordpress [whatever is the new username]) to reflect your new username.
Message back if that dosen’t work 🙂
i’m having the same difficult with the “Error establishing a database connection” error. i’ve tried every possible combination of ever possible username, database name, host, and password, to no avail. i’ve also looked up other people’s solutions to this problem and none of them seem to be relevant. i’m stuck.
in my case, my site is less than 24 hours old – could it possibly be that it has not completely propagated?
Possible, but doesn’t matter. Check with your host to verify the hostname for MySQL.
– before you upload anything on to the new server backup just the sql db
– then install wp on the new server using fantistico
– then upload the old sql database and voilia
– you’ll need to re upload w/ ftp software, your themes and plugins
– much easier than i ever thought it would be. here now it is 72 hours later
there’s what i did.