If you are in MySQL prompt and want to know which version of the database you are using, you can make use of below queries,
mysql> select version();
+-------------------------+
| version() |
+-------------------------+
| 8.0.28-0ubuntu0.20.04.3 |
+-------------------------+
1 row in set (0.01 sec)

You can also find the details by looking at the variable name version
mysql> show variables like 'version';
+---------------+-------------------------+
| Variable_name | Value |
+---------------+-------------------------+
| version | 8.0.28-0ubuntu0.20.04.3 |
+---------------+-------------------------+
1 row in set (0.01 sec)
One other way is to quit and come out of mysql prompt and once you login you will see the version details,
mysql> quit
Bye
root@b2391b608026:/# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.28-0ubuntu0.20.04.3 (Ubuntu)
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
mysql>
More Posts related to MySQL,
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- [Fix] MySQL Docker ERROR 1045 (28000): Access denied for user root@localhost (using password: YES/NO)
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
- Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
- MySQL: Error Code: 1175 You are using safe update mode
- Connection Failed: 1130 PHP MySQL Error
- MySQL : Error :1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- Display List of Databases in mysql Command Line
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- How to query database table names [MySQL/Oracle/SQL Server]
- MySQL Query for Schema/Structure of a Table
- How to find AUTO_INCREMENT Fields value in MySQL table
- [fix] Loading class com.mysql.jdbc.Driver is deprecated
- Identify MySQL version in MySQL Command Line Prompt
- How to clear MySQL Console Screen
More Posts:
- M365 service Europe outage - AADSTS90033 A transient error has occurred. Please try again. - Microsoft
- Create SharePoint list from Excel spreadsheet and import table - SharePoint
- SharePoint 2016 error - Could not find file ManageUserProfileServiceApplicationTenantSimplified.xml - SharePoint
- Error 50057 - User account is disabled. The account has been disabled by an administrator [Microsoft - Teams - Azure] - Microsoft
- How to backup a file in Linux/Unix - Linux
- PHP Script to Upload Images to Server - PHP
- Get the total size and number of objects of a AWS S3 bucket and folders - AWS
- MongoDB: Failed to connect to 127.0.0.1:27017 reason: Connection refused - HowTos