PHP Won't connect to mySQL

[deanstev]

Hi Guys, for some reason, no PHP will connect to mySQL.

The server will connect to the mySQL via command line, but when we try and access the databases via PHP, we are getting access denied.

For some reason, the PHP just ignores the data we have sent for accessing the databases.. ie I will give the following example:

cpanel username: axe
db username: axe_uname
db dbname: axe_database
db password: anythinggoes

Ok, when we try and connect, it ignores what we have set, and displays the following error:

mysql://axe_database:@localhost/axe_uname failed to connectAccess denied for user 'axe'@'localhost' (using password: NO)

Anyone got any ideas?

I've recompiled apache with so many different combinations trying to get it working, and nothing budges!

[deanstev]

Oh and its PHP 4.4.2 with mySQL 4.1.21

[deanstev]

<ack, barfed forum times for some reason>

[MMarko]

I think this is your problem "(using password: NO)".

[deanstev]

Thing is, we sent the password
PHP is ignoring it.

I don't get it.

[MMarko]

Have you checked mysql error logs?

It is possible that mysql is not started with switch useoldpassword

[cpanelkenneth]

Check your php.ini file and make certain sql.safe_mode = Off

If it equals On, that is your problem.

[ac0x2102]

Hello,

Was this sorted out? I have the same issue. Mysql was set to use old passwords and safe_mode set to off. But the issue persists.

[JoehBloeh]

Hi,

I'm having this problem also, and would like to see if anyone came across a solution!

Please post if you know of anything that may resolve this!