MySQL error - Please help

[mamold]

I moved a client's site to my server and they're having problems with the mySQL. For one thing, the db names are different. How do I change the default MySQL prefix?

thx

 

[jmstacey]

The prefix is always the same as the username, at least on DirectAdmin servers. If DirectAdmin restored the databases on a server that had a different username prefix, something sounds like it went wrong.

You can login as root or da_admin and I think you can change the database names through phpmyadmin.

 

[mamold]

Here is the error I'm getting. I don't know what's wrong? Pls. help.

Thx.

Warning: mysql_connect(): Access denied for user: 'thal_xmb1@localhost' (Using password: YES) in /home/thal/domains/thal.com/public_html/board/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/thal/domains/thal.com/public_html/board/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/thal/domains/thal.com/public_html/board/db/mysql4.php on line 331
phpBB : Critical Error

 

[jmstacey]

Ok, so this isn't a problem with the MySQL Manager in DirectAdmin?

Did you modify the database login details in your script to match what you setup in MySQL?
If username's are different then the prefix will also be different and so on.