Re: Checking the Version of mySql and settings on server

GH wrote:

However, this does not tell you if they are using the Old or New Password on the newer version... how can i check that? On Fri, 11 Feb 2005 21:01:02 +0100, Marek Kilimajer <lists@kilimajer.net> wrote:

GH wrote:

Is it possible to check via php what version of mysql is running and if it is a 4.1.x or better version to see if it is using the --old-password switch or not? I would like to know so that I can code both ways and just have a conditional statement direct which code is used...

hmm, mysql, that should be in mysql functions. I need to *get* *info* about *mysql* *server*. Oh yeah, there's one function like that: mysql_get_server_info

$var = mysql_fetch_assoc(mysql_query('show variables like 'old_passwords';')); echo $var['Variable_name'] But you need to be connected first :)