Tuesday, March 20, 2012

How to find MYSQl Port No and Version ?


mysql> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port          | 3306  |
+---------------+-------+
1 row in set (0.02 sec)

mysql> show variables like 'version';
+---------------+-------------------+
| Variable_name | Value             |
+---------------+-------------------+
| version       | 5.0.45-community-nt |
+---------------+-------------------+
1 row in set (0.00 sec)