5 zabbix 添加host_zabbix源码编译安装以及添加第一台host监控

[root@linux-node1 ~]# groupadd mysql

[root@linux-node1 ~]# useradd -g mysql -s /sbin/nologin -M mysql

[root@linux-node1 ~]# cd /opt/tools/

[root@linux-node1 tools]# tar xf mysql-5.7.19-linux-glibc2.12-x86_64.tar.gz

[root@linux-node1 tools]# mv mysql-5.7.19-linux-glibc2.12-x86_64 /opt/application/mysql

[root@linux-node1 tools]# cd /opt/application/mysql

[root@linux-node1 mysql]# useradd -s /sbin/nologin -M mysql

[root@linux-node1 mysql]# /opt/application/mysql/bin/mysqld --user=mysql --basedir=/opt/application/mysql --datadir=/opt/application/data --initialize

2017-09-02T14:59:34.959312Z 1 [Note] A temporary password is generated for root@localhost: VOFZIVorO4,W #此处有密码则表示安装成功

[root@linux-node1 mysql]# ln -s /opt/application/mysql/bin/* /usr/bin/

[root@linux-node1 mysql]# vim /etc/my.cnf #修改配置文件

[client]

port= 3306

socket= /tmp/mysql.sock

[mysqld]

port= 3306

socket= /tmp/mysql.sock

skip-external-locking

key_buffer_size = 16M

max_allowed_packet = 1M

table_open_cache = 64

sort_buffer_size = 512K

net_buffer_length = 8K

read_buffer_size = 256K

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 8M

symbolic-links = 0

log-bin=mysql-bin

binlog_format=mixed

server-id= 1

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size = 20M

sort_buffer_size = 20M

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout

[root@linux-node1 mysql]# vim /opt/application/mysql/support-files/mysql.server

basedir=/opt/application/mysql/

datadir=/opt/application/data/

[root@linux-node1 mysql]# cp /opt/application/mysql/support-files/mysql.server /etc/init.d/mysql

[root@linux-node1 mysql]# /etc/init.d/mysql start

Starting MySQL.Logging to '/opt/application/data/linux-node1.err'.

SUCCESS! #启动成功

[root@linux-node1 mysql]# mysql -pVOFZIVorO4,W #进入程序

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 3

Server version: 5.7.19-log

Copyright (c) 2000, 2017, 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> set password = password('woshiniba8');

mysql> alter user 'root'@'localhost' password expire never;

mysql> grant all privileges on *.* to root@'localhost' identified by 'woshiniba8';

mysql> flush privileges;

mysql> exit