mysql version
# console
mysql --version
mysql -V
# sql query
SHOW VARIABLES LIKE ‘%version%’;
mysql version
# console
mysql --version
mysql -V
# sql query
SHOW VARIABLES LIKE ‘%version%’;
mysql version
# Console:
mysql -V
mysql --version
# Query:
SHOW VARIABLES LIKE "%version%";
# PHPMyAdmin Interface, on the right side:
> Database server > Server version
mysql version query
SHOW VARIABLES LIKE ‘%version%’;
mysql version
mysqld --version
python and mysql connectivity
import pymysql
############### CONFIGURE THIS ###################
# Open database connection
db = pymysql.connect("database_host","username","password","database_name")
##################################################
# prepare a cursor object using cursor() method
cursor = db.cursor()
# execute SQL query using execute() method.
cursor.execute("SELECT VERSION()")
# Fetch a single row using fetchone() method.
data = cursor.fetchone()
print ("Database version : {0}".format(data))
# disconnect from server
db.close()
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us