1. sqlalchemy utf8mb4指定: 在创建引擎时,指定mysql连接字符串的编码为utf8mb4即可,示例代码如下: ```python from sqlalchemy import create_engine engine = create_engine('mysql+pymysql://user:password@host:port/database?charset=utf8mb4') ``` 2. sqlalchemy port指定: 在连接字符串中指定端口号即可,示例代码如下: ```python from sqlalchemy import create_engine engine = create_engine('mysql+pymysql://user:password@host:port/database') ``` 3. sqlalchemy autocommit指定: 可以在创建连接时设置autocommit参数,示例代码如下: ```python from sqlalchemy import create_engine engine = create_engine('mysql+pymysql://user:password@host:port/database', connect_args={'autocommit': True}) ``` 4. sqlalchemy connect_timeout指定: 可以在创建连接时设置connect_timeout参数,示例代码如下: ```python from sqlalchemy import create_engine engine = create_engine('mysql+pymysql://user:password@host:port/database', connect_args={'connect_timeout': 10}) ```