mysql8报错解决

  • Z时代
  • 2024-01-10
  • 分类：综合

database

ERROR 1178 (42000) at line 241: The storage engine for the table doesn"t support native partitioning

检查后发现是老数据的引擎是 MyISAM

) ENGINE=MyISAM AUTO_INCREMENT=789 DEFAULT CHARSET=utf8
/*!50100 PARTITION BY LINEAR HASH (id)
PARTITIONS 10 */;

改为 InnoDB 即可

) ENGINE=InnoDB AUTO_INCREMENT=789 DEFAULT CHARSET=utf8;

 

客户端连接mysql 服务器报错:

The server time zone value "EDT" is unrecognized or represents more than one time zone.

是时区的设置为 EDT,查看: show variables like "%time_zone%";

修改为系统时区,执行:

set time_zone=SYSTEM;

set global time_zone="+8:00";

flush privileges;

以上是 mysql8报错解决 的全部内容， 来源链接： utcz.com/z/533628.html

回到顶部