Mysql version query

Mysql version

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

Source: liquidweb.com

Find mysql version linux

SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------------------+
| Variable_name           | Value                                    |
+-------------------------+------------------------------------------+
| protocol_version        | 10                                       |
| version                 | 5.0.27-standard                          |
| version_comment         | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686                                     |
| version_compile_os      | pc-linux-gnu                             |
+-------------------------+------------------------------------------+
5 rows in set (0.04 sec)

Source: stackoverflow.com

What is my mysql version

Mysql version
mysql -V

Mysql version

mysqld --version

Source: linuxize.com

Similar codes

0 vote157 views1 answer
Delete duplicate rows
SQL
0 vote110 views1 answer
Select all domains of database firbird
SQL
0 vote294 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote140 views1 answer
Mysql date minus 1 day
SQL
2 votes169 views1 answer
Oracle kill session by sql_id
SQL
16 votes146 views1 answer
Mysql mediumint max value
SQL
0 vote151 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
1 vote148 views1 answer
Oracle avg
SQL
0 vote159 views1 answer
Sql show founctions
SQL
0 vote152 views1 answer
Sql orcale i forgot what my name & password was
SQL