How To Get MySQL Version in Laravel

In this post, I will share with you how to get the MySQL Version using Laravel. Lately, I need to determine what MySQL version I'm using and maybe you need it also.

 

Here is the code below:

 

Our controller:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class HomeController extends Controller
{
    public function index() 
    {
        $results = \DB::select( \DB::raw('SHOW VARIABLES LIKE "%version%"') );

        print_r($results);die;
    }
}

 

The results:

Array
(
    [0] => stdClass Object
        (
            [Variable_name] => in_predicate_conversion_threshold
            [Value] => 1000
        )

    [1] => stdClass Object
        (
            [Variable_name] => innodb_version
            [Value] => 10.4.21
        )

    [2] => stdClass Object
        (
            [Variable_name] => protocol_version
            [Value] => 10
        )

    [3] => stdClass Object
        (
            [Variable_name] => slave_type_conversions
            [Value] => 
        )

    [4] => stdClass Object
        (
            [Variable_name] => system_versioning_alter_history
            [Value] => ERROR
        )

    [5] => stdClass Object
        (
            [Variable_name] => system_versioning_asof
            [Value] => DEFAULT
        )

    [6] => stdClass Object
        (
            [Variable_name] => tls_version
            [Value] => TLSv1.1,TLSv1.2,TLSv1.3
        )

    [7] => stdClass Object
        (
            [Variable_name] => version
            [Value] => 10.4.21-MariaDB
        )

    [8] => stdClass Object
        (
            [Variable_name] => version_comment
            [Value] => mariadb.org binary distribution
        )

    [9] => stdClass Object
        (
            [Variable_name] => version_compile_machine
            [Value] => x64
        )

    [10] => stdClass Object
        (
            [Variable_name] => version_compile_os
            [Value] => Win64
        )

    [11] => stdClass Object
        (
            [Variable_name] => version_malloc_library
            [Value] => system
        )

    [12] => stdClass Object
        (
            [Variable_name] => version_source_revision
            [Value] => 4902b0fdc91cc6dc169dd2322daf966a2eeafdd8
        )

    [13] => stdClass Object
        (
            [Variable_name] => version_ssl_library
            [Value] => WolfSSL 4.8.0
        )

)

 

Reference: https://stackoverflow.com

 

Thanks for visiting. I hope it helps :)