Golfreeze.packetlove.com: Life style of Golfreeze Canon400D Family kammtan.com Jazz Freebsd Unix Linux System Admin guitar Music
All about unix linux freebsd and FAQ for Packetlove.com Web hosting , Mail hosting , VoIP + IP PBX server => all application on unix knowledges by golfreeze => Topic started by: golfreeze on พฤษภาคม 17, 2019, 09:39:53 PM
-
# zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz | mysql -uzabbix -p zabbix I get error:
ERROR 1071 (42000) at line 162: Specified key was too long; max key length is 767 bytes
fixed by recreate database with utf8
mysql -u root -p
mysql> DROP DATABASE IF EXISTS zabbixdb;
mysql>CREATE DATABASE zabbixdb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
mysql> GRANT ALL on zabbixdb.* to zabbix@localhost IDENTIFIED BY ‘password’;
mysql> FLUSH PRIVILEGES;
cd /usr/share/doc/zabbix-server-mysql
zcat create.sql.gz | mysql -u zabbix -p zabbixdb
;)