Guest User

Untitled

a guest
Jan 26th, 2019
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.02 KB | None | 0 0
  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
Add Comment
Please, Sign In to add comment