Posted by Sugapablo on 10/24/22 11:34

On Wed, 14 Dec 2005 19:12:46 +0000, Andy Hassall wrote:

> Bit of a long shot - but could make sense

Solved.

The php script was actually failing on the mysql_connect() function, and
then going right ahead and selecting the database and going ahead with the
queries. It would accept any connection that did NOT try to connect with
a password.

That's why it returned a false resource link, and that's why it wuoldn't
query using that link but would query without it.

To fix it, I basically had to reiterate the passwords (enter them again)
into the mysql.user table. I have no idea why as the value in the table
was identical before and after, but it DID work. (Perhaps the privileges
were not flushed during the system upgrade?)


--
Sugapablo
http://www.sugapablo.net

[Back to original message]