当前位置：首页>编程日记>正文

python 获取mysql中所有数据库名称

编程日记 2023/09/17 00:29:17

本站寻求有缘人接手，详细了解请联系站长QQ1493399855

通过mysql ->show databases 命令获取所有非默认数据库存入列表中返回

实例如下：

import pymysql
class Mysql(object):# mysql 端口号,注意：必须是int类型def __init__(self, host, user, passwd, port, db_name):self.host = hostself.user = userself.passwd = passwdself.port = portself.db_name = db_namedef select(self, sql):"""执行sql命令:param sql: sql语句:return: 元祖"""try:conn = pymysql.connect(host=self.host,user=self.user,passwd=self.passwd,port=self.port,database=self.db_name,charset='utf8',cursorclass=pymysql.cursors.DictCursor)cur = conn.cursor()  # 创建游标# conn.cursor()cur.execute(sql)  # 执行sql命令res = cur.fetchall()  # 获取执行的返回结果cur.close()conn.close()return resexcept Exception as e:print(e)return Falsedef get_all_db(self):"""获取所有数据库名:return: list"""# 排除自带的数据库exclude_list = ["sys", "information_schema", "mysql", "performance_schema"]sql = "show databases"  # 显示所有数据库res = self.select(sql)# print(res)if not res:  # 判断结果非空return Falsedb_list = []  # 数据库列表for i in res:db_name = i['Database']# 判断不在排除列表时if db_name not in exclude_list:db_list.append(db_name)if not db_list:return Falsereturn db_listif __name__ == '__main__':host = "ip"user = "root"passwd = "密码"port = 3306db_name = "mysql"obj = Mysql(host, user, passwd, port, db_name)all_db_list = obj.get_all_db()print("all_db_list", all_db_list)

result：

python 获取mysql中所有数据库名称配图01