manual:appendix:install:db_scripts

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
manual:appendix:install:db_scripts [2020/02/20 13:18]
martins-v instructions for mysql 8
manual:appendix:install:db_scripts [2021/01/27 19:24] (current)
Line 16: Line 16:
  
 Character set utf8 and utf8_bin collation is required for Zabbix server to work properly with MySQL database. Character set utf8 and utf8_bin collation is required for Zabbix server to work properly with MySQL database.
- 
-Instructions for creating a Zabbix database for MySQL versions prior to 8.0: 
- 
-  shell> mysql -uroot -p<​password>​ 
-  mysql> create database zabbix character set utf8 collate utf8_bin; 
-  mysql> grant all privileges on zabbix.* to [email protected] identified by '<​password>';​ 
-  mysql> quit; 
- 
-Instructions for creating a Zabbix database with MySQL 8.0 and later: 
  
   shell> mysql -uroot -p<​password>​   shell> mysql -uroot -p<​password>​