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
mysql Ver 15.1 Distrib 10.5.15-MariaDB, for debian-linux-gnueabihf (armv8l) using EditLine wrapper
xxxxxxxxxx
import mysql.connector
# Establish a connection to the MySQL server
cnx = mysql.connector.connect(user='your_username', password='your_password', host='localhost', database='your_database')
# Create a cursor to execute queries
cursor = cnx.cursor()
# Execute a query to retrieve the MySQL server version
cursor.execute("SELECT VERSION()")
# Fetch the result
result = cursor.fetchone()
# Print the MySQL server version
print("MySQL Server Version:", result[0])
# Close the cursor and connection
cursor.close()
cnx.close()