php 4.4.7 and mysql 5.0.x troubles

[Join us @ facebook]

Lately I've been coding a new CMS product for my web development clients. As the first client for this product is going to have a site with 8 languages, I thought it would be wise to have a UTF8 encoding system(saves you from a lot of trouble and some people believe it is better for SEO too).

In my development system I have php 4, mysql 4.0 and mysql 5.0. In the server we have php 4, php 5, mysql 4.0 and mysql 5.0. As you may know mysql 4.0.x and smaller versions keep data in ascii format (1 byte per character) while after the 4.1 version they use unicode (2 bytes per character) which give us the ability to have utf8 encoded data. I have never upgraded the mysql from 4.0 as this would cause troubles with our greek applications but now I have to upgrade and use mysql 5.0 for this app.

My problem is that php 4 can't connect to mysql 5.0 (I've tried all possible ways to connect....) I even tried to use custom compiled libraries that didn't worked too. Does anyone here solved this problem somehow, or should I just stick to php 5?

[Join us @ facebook]

Ok after a lot of search I found the problem....

Mysql after 4.1 version changed the way that the passwords are stored. So the new mysql  client uses another password system.

In order to make this work with php, you need php 5+ and use a client library like mysqli or use the libraries that mysql offers.

Now if you want to use php 4 you have to rollback the mysql DBMS. This can be done by this simple query :

Code:

UPDATE mysql.user
SET password=OLD_PASSWORD('somepassword')
WHERE user='someuser'
AND host='somehost';

After the update execution you just restart the server and php 4 will be able to work with mysql 4.1 +

never noticed that (maybe because I switched to php5 since a while)

but you're right, it's not wrong to use the mysqli extension.

btw I switched the greek version from some website without any problems from mysql 3 to 4 and finally to 5

[Guest]

[62.885]

Yahoo crawler, Googlebot