Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql version

# Console:
mysql -V
mysql --version
# Query:
SHOW VARIABLES LIKE "%version%";
# PHPMyAdmin Interface, on the right side:
> Database server > Server version
Comment

what is my mysql version

Mysql version
mysql -V
Comment

mysql version query

SHOW VARIABLES LIKE ‘%version%’;
Comment

mysql version

mysqld --version
Comment

mysql version

mysqladmin version
 - or -
mysqladmin ve

## Example Output
mysqladmin  Ver 9.1 Distrib 10.3.36-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          10.3.36-MariaDB-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 22 hours 40 sec

Threads: 8  Questions: 271157  Slow queries: 0  Opens: 272  Flush tables: 1  Open tables: 264  Queries per second avg: 3.421
Comment

mysql --version

mysql  Ver 15.1 Distrib 10.5.15-MariaDB, for debian-linux-gnueabihf (armv8l) using  EditLine wrapper
Comment

PREVIOUS NEXT
Code Example
Sql :: find duplicates mysql 
Sql :: mysql inner join 3 tables 
Sql :: mysql query first character 
Sql :: sql update table remove spaces 
Sql :: sql order by where condition 
Sql :: select all tables sql 
Sql :: how to update date value in sql 
Sql :: mysql regex replace 
Sql :: mysql show table structure 
Sql :: create table in mysql 
Sql :: copy postgres table from one schema into another 
Sql :: how to use group_concat in sql server 
Sql :: load sql into mamp 
Sql :: mysql select multiple rows into one column 
Sql :: psql fatal database does not exist 
Sql :: command line mysql xampp 
Sql :: update from table tsql 
Sql :: get current month last date in sql server 
Sql :: vbscript connect mssql 
Sql :: How to convert DateTime to VarChar SQL 
Sql :: create sequence postgres 
Sql :: mysql command not working in linux 
Sql :: join in update query in mysql 
Sql :: postgresql get today 
Sql :: date conversion in mysql column 
Sql :: how to query without duplicate rows in sql 
Sql :: how to select unique element in sql 
Sql :: encrypt password postgresql 
Sql :: sql line numbers 
Sql :: how to inner join 4 tables in sql 
ADD CONTENT
Topic
Content
Source link
Name
2+7 =