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 -u root -p

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

CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE mytable CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

import mysql.connector

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

import mysql.connector

config = {
  'user': 'root',
  'password': 'yourpassword',
  'host': '127.0.0.1',
  'database': 'mydatabase',
  'charset': 'utf8mb4'
}

try:
    connection = mysql.connector.connect(**config)
    print("Connected to MySQL with charset utf8mb4")
except mysql.connector.Error as err:
    print(f"Error: {err}")
finally:
    if connection.is_connected():
        connection.close()