How do I check the version of MySQL

To check the version of MySQL, you can execute a simple query in your MySQL client or in your terminal. Below is an example of how to do this using PHP:


        <?php
        // Connect to MySQL
        $conn = new mysqli('localhost', 'username', 'password');

        // Check connection
        if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
        }

        // Get MySQL server version
        $result = $conn->query("SELECT VERSION() AS version");
        $row = $result->fetch_assoc();
        echo "MySQL version: " . $row['version'];

        // Close connection
        $conn->close();
        ?>