if you are using MySQL shell
xxxxxxxxxx
\status
also use \? or \help when you need help
xxxxxxxxxx
mysqladmin version
- or -
mysqladmin ve
## Example Output
mysqladmin Ver 9.1 Distrib 10.3.36-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Server version 10.3.36-MariaDB-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 22 hours 40 sec
Threads: 8 Questions: 271157 Slow queries: 0 Opens: 272 Flush tables: 1 Open tables: 264 Queries per second avg: 3.421
xxxxxxxxxx
import mysql.connector
# Replace 'username', 'password', and 'database_name' with your MySQL credentials
mydb = mysql.connector.connect(
host="localhost",
user="username",
password="password",
database="database_name"
)
mycursor = mydb.cursor()
mycursor.execute("SELECT VERSION()")
result = mycursor.fetchone()
print("MySQL version: ", result)