Find MySQL Server Version

To find MySQL server version, connect to MySQL, then run

select version();

1	select version();

You can also use “mysql –version”

[root@server ~]# mysql --version
mysql  Ver 14.14 Distrib 5.6.38, for Linux (x86_64) using  EditLine wrapper
[root@server ~]#

[root@server ~]# mysql --version

mysql Ver 14.14 Distrib 5.6.38, for Linux (x86_64) using EditLine wrapper

[root@server ~]#

This only show MySQL client version. If you have multiple MySQL server installed or MySQL server is running on another host, this won’t help.