Mysql 版本: 8.0
系统:win10
错误描述:[ERR] 1118 - Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
解决方法:
在C:\ProgramData\MySQL\MySQL Server 8.0下找到my.ini文件,增加如下配置项:
[mysqld]
innodb_log_file_size = 512M
innodb_strict_mode = 0
然后重启mysql即可。
注意:my.ini 文件需保存为ANSI编码,否则mysql无法启动!
标签:ERR,large,too,8126,1118,size From: https://www.cnblogs.com/colinwps/p/16744161.html