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
Smart way of Technology 