No mySQL functionality in php4
Posted by: vertical (---.c1.ondsl.gr)
Date: February 22, 2007 11:34AM

I have many applications installed and function really well in wamp (1.7.0) with php5. When I installed the php4 plugin and try to use the same applications, I get warning/error messages that it cannot connect to the mySQL database. None of the application does.

The wamp index screen says:

PHP version : 4.4.4
MySQL version : 5.0.27-community-nt

Any ideas what is wrong?



Post Edited (02-22-07 11:38)

Options: ReplyQuote
Re: No mySQL functionality in php4
Posted by: CyberSpatium (71.237.217.---)
Date: February 23, 2007 01:03AM

if you are using mysqli it is only supported on php5



CyberSpatium
-------------------------
WAMP English Forum Admin

Options: ReplyQuote
Re: No mySQL functionality in php4
Posted by: whysyn (---.hmon.net)
Date: February 23, 2007 04:21AM

What is your exact error message?

PHP4 uses the old style mySQL passwords, meaning you must force mySQL to do it as well...

First, connect to your mySQL server on command line, and manually reset every password as follows:

mysql> connect mysql
mysql> select user, host from user;

For each user/host pair, do:

mysql> set password for 'user'@'host' = old_password('yourpassword');

Then, edit your mysql config file (my.cnf) and add the following to the section under [wampmysqld]:

old_passwords=1

Restart mySQL and you should be all set. For more info on mySQL password supports, check out [dev.mysql.com]

Options: ReplyQuote
Re: No mySQL functionality in php4
Posted by: vertical (---.c1.ondsl.gr)
Date: February 23, 2007 12:58PM

Thank you very much. old_passwords was trick... Everything works fine now...

Options: ReplyQuote


Sorry, only registered users may post in this forum.