admin 发表于 2018-9-5 08:35:02

mysql报错:[Err] 1074 - Column length too big for column '' (max = 21845); us...



vim /etc/my.cnf


修改sql_mode参数

sql_mode='NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'


Skey11 发表于 2018-9-5 14:02:21

01、安装之前下载libmecab大于libmecab2 0.996-1.1的版本,因为mysql-community-server 依赖于 mysql-client (= 5.7.17-1debian8)
02、libmecab2 0.996-1.1下载地址

ftp://mirrors.ircam.fr/pub/debian/pool/main/m/mecab/libmecab2_0.996-1.1_amd64.deb

libmecab 0.996-3的下载地址如下

ftp://ftp.us.scene.org/debian/pool/main/m/mecab/libmecab2_0.996-3_amd64.deb


或者自己搜索

http://www.filewatcher.com/_/?q=libmecab2+0.996&p=1

安装

dpkg -i libc6_2.19-18+deb8u7_amd64.deb




debian linux mysql5.7.17安装顺序

sudo dpkg -i mysql-common_5.7.17-1debian8_amd64.deb
03、dpkg -ilibmysqlclient20_5.7.17-1debian8_amd64.deb
dpkg -i libmysqlclient-dev_5.7.17-1debian8_amd64.deb
04、启动和停止mysql服务命令

/etc/init.d/mysql start
/etc/init.d/mysql stop
页: [1]
查看完整版本: mysql报错:[Err] 1074 - Column length too big for column '' (max = 21845); us...