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

admin

[pre]

vim /etc/my.cnf
[/pre]

修改sql_mode参数
[pre]
sql_mode='NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
[/pre]

Skey11

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/debia ... 0.996-1.1_amd64.deb

libmecab 0.996-3的下载地址如下

ftp://ftp.us.scene.org/debian/po ... 2_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 -i  libmysqlclient20_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