MySQL 5.0.45 or 4.1.22?
Posted by: herb (---.dyn.optonline.net)
Date: December 20, 2007 08:19PM

Greetings!

First a big Thanks for making this available. I just upgraded from a previous version so I could better replicate my hosts environment and this release, (and your new website), looks great.

My challenge is related to the version of MySQL. I'm trying to replicate my hosts usage of MySQL version 4.1.22.

I've loaded the default configuration of Apache 2.2.6, PHP 5.2.5 and MySQL 5.0.45 and then added on MySQL 4.1.22. I switched to the 4.1.22 Version of MySQL and get the following contradictory information...

The localhost page indicates that the MySQL version is 4.1.22, as does the loaded my.ini file.

However, phpinfo() says that mysql Client API Version is 5.0.45.

So,,, which one is correct? Or am I doing something wrong? I tried using Apache 1.3.37 which is the same as my host, but I got the same conflicting indication of mysql versions.

Thank you very much if you can help!!

Herb

UPDATE: I'm 98% sure now that my server is actually running 5.0.45 since I did an import of a 5.0 mysql database, without using the "compatibility mode" and I see none of the strange translations of punctuation that I got when I tried the same thing on my host who IS using 4.1.22.



Edited 1 time(s). Last edit at 12/20/2007 09:23PM by herb.

Options: ReplyQuote
Re: MySQL 5.0.45 or 4.1.22?
Posted by: herb (---.dyn.optonline.net)
Date: December 27, 2007 12:37AM

I tried updating to MySQL 4.1.21 to see if this would help, but I get the same issue.

The localhost information says that I'm using the "correct" MySQL - 4.1.21 in this case, but running phpinfo(), still shows that the client is 5.0.45.

Is this a bug, or am I doing something wrong?

Thanks if you can help point me in the correct direction!

Options: ReplyQuote
Re: MySQL 5.0.45 or 4.1.22?
Posted by: jw_k (---.net-you.de)
Date: December 27, 2007 10:41PM

php uses the libmysql.dll (client) from the mysql 5.045 package.
No problem though (it's backword compatible and can deal even with mysql 3.x servers)

Options: ReplyQuote
Re: MySQL 5.0.45 or 4.1.22?
Posted by: herb (---.dyn.optonline.net)
Date: December 29, 2007 03:46PM

Thank you very much for your response!

So as I understand it, I can believe what the WAMP localhost page tells me (I really am using MySQL 4.1.2x) - and that phpinfo() is just reporting the use of the 5.045 client.

Thanks again - it had me confused.

Herb

Options: ReplyQuote
Re: MySQL 5.0.45 or 4.1.22?
Posted by: jw_k (---.net-you.de)
Date: December 30, 2007 12:46AM

to let the mysql report the actual *server* version you are connected to use

select version();

in the phpmyadmin sql window or on the mysql CLI.


Glad to have been helpful winking smiley

Jürgen

Options: ReplyQuote


Sorry, only registered users may post in this forum.