MySQL 버전 확인 방법 여러가지 sql, 리눅스, yum, rpm, mysqladmin

MySQL 버전 확인 방법 여러가지 sql, 리눅스, yum, rpm, mysqladmin

방법1 linux

mysql  Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline 5.1

mysql접속

mysql -u testuser -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 810996
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

방법2 sql

SELECT VERSION();

방법3 sql

SHOW VARIABLES LIKE 'version';

방법4 yum

yum list installed mysql*

방법5 linux

rpm -qa | grep ^mysql

방법6 linux

mysqladmin -uroot -pP@ssw0rd version | grep ^Server