[root@dlp ~]#
mysql -u root -p
Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 Server version: 5.1.73 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
create database zabbix;
Query OK, 1 row affected (0.00 sec)
mysql>
grant all privileges on zabbix.* to zabbix@'localhost' identified by 'password';
Query OK, 0 rows affected (0.00 sec)
mysql>
grant all privileges on zabbix.* to zabbix@'%' identified by 'password';
Query OK, 0 rows affected (0.00 sec)
mysql>
flush privileges;
Query OK, 0 rows affected (0.00 sec)
[root@dlp ~]#
cd /usr/share/doc/zabbix-server-mysql-*/create
[root@dlp create]#
mysql -u root -p zabbix < schema.sql
Enter password:
[root@dlp create]#
mysql -u root -p zabbix < images.sql
Enter password:
[root@dlp create]#
mysql -u root -p zabbix < data.sql
Enter password:
|