Site moved but SQL error?

[IronWarrior]

Hello.

Am a new customer and I just brought hosting for the first time for my site, http://www.game-maps.net/

I've just had all my files and DB's moved to the new host and we just changed the name servers eailer today, everything has been completed now.

But the problem is that users going to the site are getting this error.

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'game_admin'@'localhost' (using password: YES) in /home/iwarrior/public_html/includes/mysql.php on line 63
: paFileDB was unable to successfully connect to the MySQL database. Check your settings including the MySQL server, username, and password and try again.

I've looked at the old cpanel SQL area in the old host and then looked at the new one and I can see the difference between them and I understand the problem, but am so out of my depth on fixing it.

Am also worried about the name changes between the database's.

My transfer ticket is still open, I was expecting it to be closed now, but because it is open, am thinking the person who has transfered my site, is gonna fix this part, but as he didn't do it when he moved the files and DB, am confused.

I'll have no experience in things like this, any help would be most welcome.

Thank you.

[kmaw]

Go into cpanel, click MySQL databases and make sure the user game_admin is added to the DB

[IronWarrior]

Yeah it is, but it's under a new name now, none of the other fields are added.

[ghpk]

Originally Posted by IronWarrior

Yeah it is, but it's under a new name now, none of the other fields are added.

check with your config file it is having the correct DB connection specified, if you have moved your site most probably your username would be different from the one you were using earlier.

mysql error you are getting also says "
Check your settings including the MySQL server, username, and password and try again."

[IronWarrior]

Ah well, with a help of a friend, she told me how to fix it, was so simple really, all I needed to do was change the old account details to the new in mysql.php file and upload it.

But, now am trying to fix the wiki that is also hosted, http://www.game-maps.net/wiki/

So same error I guess, but can't really find the right file to fix it.

[IronWarrior]

Hmm, if anyone knows about wikis please reply.

[kompreszor]

I don't use MediaWiki, but a quick look on there site got me this...

file to edit: LocalSettings.php
Directions