mac设置编码格式mysql

[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

[client]
default-character-set=utf8mb4

sudo launchctl unload /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist
sudo launchctl load /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

mysql> SHOW VARIABLES LIKE 'character_set_%';
mysql> SHOW VARIABLES LIKE 'collation_%';

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase",
  charset='utf8mb4'
)

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword"
)

mycursor = mydb.cursor()

# 创建数据库时指定字符集
mycursor.execute("CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci")

# 使用新数据库
mycursor.execute("USE mydatabase")

# 创建表时指定字符集
mycursor.execute("CREATE TABLE customers (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), address VARCHAR(255)) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci")