Check version (64/32 bit) & port number of MySQL

Check version (64/32 bit) & port number of MySQL

Check the version of MYSQL from SQL Query

mysql> SELECT VERSION();

+-----------+
| VERSION() |
+-----------+
| 8.0.16    |
+-----------+
1 row in set (0.00 sec)

Check the version of MYSQL from Configuration file

mysql> SHOW VARIABLES LIKE "%version%";

+--------------------------+------------------------------+
| Variable_name            | Value                        |
+--------------------------+------------------------------+
| immediate_server_version | 999999                       |
| innodb_version           | 8.0.16                       |
| original_server_version  | 999999                       |
| protocol_version         | 10                           |
| slave_type_conversions   |                              |
| tls_version              | TLSv1,TLSv1.1,TLSv1.2        |
| version                  | 8.0.16                       |
| version_comment          | MySQL Community Server - GPL |
| version_compile_machine  | x86_64                       |
| version_compile_os       | Win64                        |
| version_compile_zlib     | 1.2.11                       |
+--------------------------+------------------------------+

Check version from Command prompt

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql --version
mysql Ver 8.0.16 for Win64 on x86_64 (MySQL Community Server - GPL)

Check uptime, version & port information

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysqladmin -u root -p version
Enter password: *****
mysqladmin Ver 8.0.16 for Win64 on x86_64 (MySQL Community Server - GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version 8.0.16
Protocol version 10
Connection localhost via TCP/IP
TCP port 3306
Uptime: 1 day 19 hours 32 min 34 sec

Threads: 5 Questions: 1439 Slow queries: 0 Opens: 348 Flush tables: 3 Open tables: 249 Querie
per second avg: 0.009

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.