[RESOLVED] Help: How do I run MySQLi on PHP 4.4.4?

TheoGB

I have PHP 4.4.4 on a Windows machine running Apache and I just upgraded to MySQL 4.1.22 from 4.0.

I don't understand how to get MySQLi to be used intstead of the normal MySQL. It seems like I need php_mysqli.dll in my extensions but I don't have that anywhere.

Is there a way to sort this? Does someone have the DLL they could send me?

Cheers
Theo

bradgrafelman

I don't know that you can run MySQLi on PHP4. Consider upgrading to PHP5, or use the old password hashing method on your MySQL server.

TheoGB

Umm... Really? PhpMyAdmin won't run because I don't have MySQLi. I've been having real trouble working out how to sort this. I used to have MySQL 4.0 and that was fine but I just upgraded.

My website is run on a host who has MySQL 4.1.22 and PHP 4.4.6. I'm trying to mimic this so I wasn't sure about upgrading to PHP 5 in case I start using functionality I don't have.

Does anyone have any suggestions to help me out with this?

bradgrafelman

You can use the old mysql_*() functions, provided you:

bradgrafelman wrote:
use the old password hashing method on your MySQL server.

TheoGB

Okay, so I have to change the root user so that the password is stored with the old_password() function? Or am I hacking PhpMyAdmin so that it sends the mysql_connect string through with old_password?

I only use OLD_PASSWORD for all my internal functions in any case.

I see what you mean now. It's strange because this solution wasn't what google and the PhpMyAdmin documentation was telling me, based on the errors I was getting: everything seems to lead to MySQLi being required.

Cheers

TheoGB

Okay, I'm really confused now.

I just did a

SELECT user FROM User WHERE password = PASSWORD('my password');

and got nothing. When I did:

SELECT user FROM User WHERE password = OLD_PASSWORD('my password');

I got 'root' back. I can't see how to request phpMyAdmin use the old_password function, but then maybe mysql_connect() automatically uses it? In any case I can't work out why it can't connect if my root user already has the OLD_PASSWORD() functionality.

Any ideas? Cheers

bradgrafelman

mysql_connect() is unable to use the new hashing algorithm, so it doesn't know that OLD_PASSWORD() is actually "old" - it's the only thing it knows.

Try opening your my.ini config and adding "old_passwords=1" under the [mysqld] section. Don't forget to restart your SQL server after you make this config change.

Have you tried making a simple PHP script that attempts to connect to your DB? If it fails, what errors does it give?

TheoGB

Hurrah! Thank you. Setting the value in my.ini was all it took. 🙂