Find out the current version of mySQL using either PHP or SQL

Question

Using either a SQL query, or some php code, how can I determine which version of MySQL is running. I found several examples of using the command line, but I need to check programmatically.

I tried

SELECT @version;

But that returned NULL.

I did search stack overflow, and found a lot of questions, but they were about other dbs or programming languages. I didn't find any specifically for MySQL.

Jerson · Accepted Answer · 2021-12-26 13:51:34Z

2

You can get by user mysqli_server_info or the oop way using $mysqli->server_info;

<?php

$mysqli = new mysqli("localhost", "my_user", "my_password");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

/* print server version */
printf("MYSQL Server version: %s\n", $mysqli->server_info);

$mysqli->close();

Or in MYSQL Query way

SELECT VERSION();

Or you may want to show in detailed way

SHOW VARIABLES LIKE "%version%";

answered Dec 26, 2021 at 13:51

Jerson

1,7752 gold badges12 silver badges15 bronze badges

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

Comments

Zakaria · Accepted Answer · 2021-12-26 12:40:49Z

1

Correct syntax with mysql is select version();

Fiddle

answered Dec 26, 2021 at 12:40

Zakaria

4,7762 gold badges9 silver badges37 bronze badges

Collectives™ on Stack Overflow

Find out the current version of mySQL using either PHP or SQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related