數(shù)據(jù)庫啟動
service?mysqld start?
mysql:1153 Got a packet bigger than ‘max_allowed_packet’ bytes的解決方法
1.臨時修改：
mysql>setglobal max_allowed_packet=524288000; #修改 512M
2.修改my.cnf(windows下my.ini)，需重啟mysql器一。
在 [MySQLd] 部分添加一句（如果存在课锌，調(diào)整其值就可以）：
max_allowed_packet=256M （根據(jù)實際情況調(diào)整數(shù)值）
可通過命令：
showVARIABLESlike'%max_allowed_packet%’;
MySQL 建索引時 Specified key was too long; max key length is 767 bytes 錯誤的處理
SHOW variables like 'innodb_large_prefix'
臨時修改
SET GLOBAL INNODB_LARGE_PREFIX = ON;
SHOW variables like 'innodb_file_format'
臨時修改
SET GLOBAL innodb_file_format = BARRACUDA;
永久修改
vim /etc/my.con.d/server.conf
innodb_large_prefix=on
innodb_file_format=BARRACUDA
