BASH function to get the config value for a variable from MySQL

getCurrentMysqlConfigForVariable.bash

function getCurrentMysqlConfigForVariable(){
    local variable=$1
    mysql -e "select variable_value from information_schema.global_variables where variable_name like '$variable'" |
    while read variable_value;
    do
        if [[ 'variable_value' == "$variable_value" ]]
        then
            # skip the header
            continue
        fi
        echo $variable_value
        return 0
    done
    return 1
}

Usage:

user@server getCurrentMysqlConfigForVariable default_storage_engine
InnoDB