7.2 Configuring the MySQL database from Python

新建GuiDBConfig.py文件（确保外界不能访问以确保安全），保存数据库配置

# -*- coding: utf-8 -*-
dbConfig = {
    'user': 'tiger',
    'password': 'tiger',
    'host': '127.0.0.1'
}

        

          
        
        
        

          

          AI 代码解读
        
      
      

创建连接数据库文件，执行两次创建数据库操作，第二次显示错误（Failed to create DB: 1007 (HY000): Can't create database 'GuiDB'; database exists）

# -*- coding: utf-8 -*-
import GuiDBConfig as guiConf
import mysql.connector as mysql
# unpack dictionary credentials
conn = mysql.connect(**guiConf.dbConfig)

cursor = conn.cursor()
GUIDB = 'GuiDB'
try:
    # 创建数据库
    # cursor.execute("CREATE DATABASE {} DEFAULT CHARACTER SET 'utf8'".format(GUIDB))
    # 显示数据库
    cursor.execute("show databases")
except mysql.Error as error:
    print("Failed to create DB: {}".format(error))
print(cursor.fetchall())
cursor.close()
conn.close()
print(conn)

        

          
        
        
        

          

          AI 代码解读
        
      
      

执行show databases显示结果：

[('information_schema',), ('GuiDB',), ('bladepro',), ('blog',), ('engineer',), ('ip',), ('mysql',), ('performance_schema',), ('spring_blog',), ('sys',), ('weixin',)]

        

          
        
        
        

          

          AI 代码解读
        
      
      

mysql版本5.7，数据库名称区分大小写