SHARE
TWEET

Untitled

a guest Jan 26th, 2019 109 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. wget http://repo.zabbix.com/zabbix/3.2/ubuntu/pool/main/z/zabbix-release/zabbix-release_3.2-1+xenial_all.deb
  2. dpkg -i zabbix-release_3.2-1+xenial_all.deb
  3. apt-get update
  4. apt-get install zabbix-server-mysql zabbix-frontend-php
  5.    
  6. Creating initial database
  7.  
  8. Create Zabbix database and user on MySQL by the following commands, where <root_password> shall be replaced with the actual root password (e.g., shell> mysql -uroot -p12345) and <password> with new password for zabbix user on the database (including apostrophes: …identified by '67890';):
  9.  
  10. shell> mysql -uroot -p<root_password>
  11. mysql> create database zabbix character set utf8 collate utf8_bin;
  12. mysql> grant all privileges on zabbix.* to zabbix@localhost identified by '<password>';
  13. mysql> quit;
  14.    
  15. $sudo service mysql stop
  16. $sudo mysqld_safe --skip-grant-tables
  17.  
  18. # Another terminal
  19. $mysql -uroot mysql
  20. mysql > update user set password=PASSWORD("root") where User='root';
  21. mysql > flush privileges;
  22. mysql > quit;
  23. $ sudo service mysql restart
  24. $ mysql -uroot -proot
  25. ERROR 1698 (28000): Access denied for user 'root'@'localhost'
  26.    
  27. dpkg -l | grep mysql
  28. ii  libdbd-mysql-perl                     4.033-1ubuntu0.1                                            amd64        Perl5 database interface to the MySQL database
  29. ii  libmysqlclient20:amd64                5.7.17-0ubuntu0.16.04.1                                     amd64        MySQL database client library
  30. ii  mysql-common                          5.7.17-0ubuntu0.16.04.1                                     all          MySQL database common files, e.g. /etc/mysql/my.cnf
  31. ii  php-mysql                             1:7.0+35ubuntu6                                             all          MySQL module for PHP [default]
  32. ii  php7.0-mysql                          7.0.13-0ubuntu0.16.04.1                                     amd64        MySQL module for PHP
  33. ii  zabbix-server-mysql                   1:3.2.3-1+xenial                                            amd64        Zabbix network monitoring solution - server (MySQL)
  34.    
  35. mysql_secure_installation
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top