Skip to content

Instantly share code, notes, and snippets.

@aortmannm
Last active December 15, 2015 12:48
Show Gist options
  • Save aortmannm/5262264 to your computer and use it in GitHub Desktop.
Save aortmannm/5262264 to your computer and use it in GitHub Desktop.
configure percona for zabbix server
svcadm disable mysql:percona
mysqld_safe --skip-grant-tables &
mysql -uroot
mysql> use mysql;
mysql> update user set password=PASSWORD("password") where User='root';
mysql> flush privileges;
mysql> quit;
prstat
kill PID
svcadm enable mysql
mysql -u root -p
mysql> CREATE USER 'zabbix'@'%' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'zabbix'@'%'
-> WITH GRANT OPTION;
mysql -u zabbix -p
mysql> create database zabbix character set utf8;
mysql> quit;
mysql -uzabbix -ppassword zabbix < database/mysql/schema.sql
mysql -uzabbix -ppassword zabbix < database/mysql/images.sql
mysql -uzabbix -ppassword zabbix < database/mysql/data.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment