MySqlConnection链接mysql

 mysql默认编码

default-character-set = utf8mb4

 

导致

MySqlConnection connection = new MySqlConnection()

connection.ConnectionString = configFile["ConnectionStrings:WeiCloudDBQRTZ"];
connection.Open();//提示错误:Guid should contain 32 digits with 4 dashes

 

可以在在连接字符串中添加 OldGuids=true; 尝试解决一下:完整连接:

修改链接串:server=;uid=root;pwd=;port=3308;database=WeiCloudDB.QRTZ;charset=utf8mb4;Character Set=utf8mb4;OldGuids=true

posted @ 2022-04-19 16:00  wjl910  阅读(1539)  评论(0)    收藏  举报