I'm setting up a MySQL server on a VMWare session. I have created a database, created users, and given them permissions to the database. I can log in using one of these users, view tables, do SELECT queries, etc. I can even view these remotely from the host machine using a Windows SQL client (Navicat).

However, I cannot get a couple of PHP scripts to access the database successfully. The first one I'm trying to use is the admin.php file from PHPNuke. I realize this is not the place for PHPNuke support, but I am also having this issue with the vBulletin test PHP file. It seems that they are unable to connect to the database, yet I am sure that the configuration is correct, and they are connecting from the same host OS that Navicat is successfully connecting. They are also using the same username/password. Can anyone point me in the right direction concerning troubleshooting this issue?

Bump.

I would double check that the mysql user you're using does have permission to access from any remote host (yeah, I know Navicat connects, but is it on the same box as ) and then I would enable php logging if you haven't done so already. I'm guessing that this is a PHP problem rather than a MySQL problem.