While I've searched the forums here and found no other reference, Google groups seems to have many references to this problem - but with no cohesive or applicable answer from what I could find.

I'm working with a default, first-time install of PHP, Xoops, MySQL, and Apache. It's my first time working with all of these, so please forgive my ignorance.

Basically, everything works fine until I try to change my root MySQL password from null to anything. Then everything goes wrong. phpMyAdmin won't connect, neither will Xoops, despite entering the appropriate password in config.inc.php or mainfile.php, respectively. The odd thing is that the Windows version of MySQL Administrator *will* connect with the new credentials, which (as far as I can see) proves that there is nothing wrong with MySQL itself.

Has anyone else had problems with this? Please tell me that I'm not on cheap drugs, here. Any help is most appreciated.

Cheers,
Shawn.

That sounds like your PHP is compiled with a MySQL client that is too old for your MySQL version. Either upgrade/recompile PHP using a newer client library or downgrade MySQL to 4.0.xx.

And of course you won't be using the root account for xoops....

Quote:

I'm using the latest versions of everything, since I just recently installed everything. Apache v2.0.52, PHP v4.3.10, MySQL v4.1.8. I'm using binaries, though, on Win32.

While it wasn't my intention to use root as my production server, but I tried creating a user with full rights to the XOOPS database, but that user doesn't seem to work either. While I can connect to the database using the MySQL Administrator with the 'xoopsroot' user, the home page won't load. If I edit mainfile.php to use the 'xoopsroot' user, I get the error:

Quote:

I'm assuming that the XOOPS database user needs full control to the XOOPS database? It doesn't need any other rights to the 'mysql' database or something?

Thanks,
Shawn.

Found my issue. Had to do the 'OLD_PASSWORD' thing, per the article here:

http://dev.mysql.com/doc/mysql/en/Old_client.html

Cheers,
Shawn.