How to detect the mySQL version using PHP?

Question

I can use:

extension_loaded('mysql')

to check if mySQL is installed on the server or not.

also phpinfo() can display a nice phpinfo page.

but how to get which mysql version is installed on server? is there any function like:

which_extension_version('mysql') //output the mysql version?

just like the PHP_VERSION?

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

Bolli
– Bolli

2014-04-07 15:06:15 +00:00
Commented Apr 7, 2014 at 15:06 — Bolli
– Bolli, Commented Apr 7, 2014 at 15:06
php.net/manual/en/mysqli.get-server-info.php

Steve
– Steve

2014-04-07 15:06:41 +00:00
Commented Apr 7, 2014 at 15:06 — Steve
– Steve, Commented Apr 7, 2014 at 15:06

gbestard · Accepted Answer · 2014-04-07 15:06:41Z

2

You can get it with:

mysqli_get_server_version();

answered Apr 7, 2014 at 15:06

gbestard

1,17713 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nambi · Accepted Answer · 2014-04-07 15:06:55Z

Use the mysql_get_server_info() after connect with mysql_connect

<?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } printf("MySQL server version: %s\n", mysql_get_server_info()); ?>

Emil · Accepted Answer · 2014-04-07 15:07:07Z

0

Take a look at: mysql_get_server_info()

answered Apr 7, 2014 at 15:07

Emil

1,8161 gold badge20 silver badges22 bronze badges

Collectives™ on Stack Overflow

How to detect the mySQL version using PHP?

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related