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

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 :: pandas to sql index 
Sql :: mysqldump: Got error: 1045: Access denied for user 
Sql :: mysql check if not null 
Sql :: sqlite create table if not exists 
Sql :: ora-01109 database not open in oracle 19c 
Sql :: sql create table statement 
Sql :: check if record exists mysql 
Sql :: psql change table schema 
Sql :: show tables in cassandra cql 
Sql :: find duplicate users by email address in mysql 
Sql :: is mysql and sqlite same 
Sql :: how to select first row of database sql 
Sql :: oracle trigger 
Sql :: calculate distance between two latitude longitude postgresql 
Sql :: ubuntu connect to mssql database 
Sql :: drop view sql 
Sql :: duplicate records in sql 
Sql :: psql get table data types 
Sql :: pl/sql cursor 
Sql :: postgresql casting integer to string 
Sql :: create new schema mysql 
Sql :: sql create schema 
Sql :: delete join select from one table based on multiple values 
Sql :: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file 
Sql :: oracle remove line breaks 
Sql :: search mysql database for column 
Sql :: unsigned int in mysql 
Sql :: oracle running queries 
Sql :: sql check duplicate value in column 
Sql :: what is default mysql database password in linux 
ADD CONTENT
Topic
Content
Source link
Name
2+8 =