[SOLVED] Checking mysql version

[wrathican]

Hey people

 

im trying to make an installer script but want to make some server checks before the script works it's magic.

 

how can i check the version of mysql installed on the server.

i need to be able to check without running shell commands and without actually having to connect

 

Thanks

Wrath

[dennismonsewicz]

you could create an info.php script like this

 

<?php

phpinfo();

?>

 

And then just run it in your browser

[wrathican]

sorry i should have said, the script needs to be able to check the version. not the user.

 

[dennismonsewicz]

try this

 

http://us3.php.net/manual/en/function.mysql-get-server-info.php

[discomatt]

http://www.codingforums.com/showthread.php?t=95264

 

exec() and phpinfo() seem to be your best bets.

 

If you choose to go phpinfo(), rather than using this

 

$file = @file_get_contents("http://YOURDOMAINHERE/phpinfo.php");

 

You're better off with

 

ob-start();

phpinfo();

$file = ob_get_clean();

 

[discomatt]

try this

 

http://us3.php.net/manual/en/function.mysql-get-server-info.php

 

Requires connection.

[PFMaBiSmAd]

phpinfo() only shows the client library version.

[wrathican]

Thanks for the replies.

 

dennis: what discomatt said

 

discomatt: what PFMaBiSmAd said and i was thinking to do what you said, but then i found that out.

 

any other suggestions?

 

 

[PFMaBiSmAd]

Since php does not have this information available (mysql is a separate service from the web server/php), the only way that will consistently work will involve you asking mysql what version it is, either through a query or a command line statement.

[discomatt]

No, I don't think there's a consistent way without connecting or using a command-line call. What's wrong with connecting first?

[wrathican]

oh nothing, i just wanted the to see if it was possible to make sure everything was ok before anything is installed.

 

Thanks for the help anyway chaps.

 

I guess i'm going to have to connect first