File: zabbix-server-mysql.README.Debian

package info (click to toggle)
zabbix 1%3A3.0.7%2Bdfsg-3
  • links: PTS, VCS
  • area: main
  • in suites: stretch
  • size: 60,008 kB
  • ctags: 38,245
  • sloc: php: 125,527; ansic: 120,253; sql: 40,319; sh: 5,620; makefile: 1,138; java: 957; cpp: 211; perl: 41; xml: 29
file content (33 lines) | stat: -rw-r--r-- 1,096 bytes parent folder | download | duplicates (5)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Installing the database
-----------------------

The Zabbix server needs an SQL database to run. As you chose to install
this zabbix-server-mysql package you apparently want to use a MySQL server
as a storage backend.

Set up a MySQL database server on any system - you are not forced to run it
on the same computer as the Zabbix server:

-> apt-get install mysql-server

Create a new database (let's call it "zabbix"):

-> mysql -p -e "create database zabbix character set utf8"

Create a MySQL user that has access rights to the database
(please use another password than 'SECRETPASSWORD'):

-> mysql -p -e "grant all on zabbix.* to 'zabbix'@'localhost' identified by 'SECRETPASSWORD'"

Create the database schema:

-> zcat /usr/share/zabbix-server-mysql/{schema,images,data}.sql.gz \
   | mysql -uzabbix -pSECRETPASSWORD zabbix

Now enter the database access credentials into your
/etc/zabbix/zabbix_server.conf, enable the startup in the
/etc/default/zabbix-server-mysql file and start the Zabbix server.

See also:
http://www.zabbix.com/documentation/2.0/manual/appendix/install/db_scripts