YUM方式安装Zabbix

mysql yum 安装

Mysql YUM安装

安装yum源,安装地址： 
https://dev.mysql.com/downloads/repo/yum/

1. rpm -Uvh mysql80-community-release-el6-2.noarch.rpm

安装官方文档地址： 
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html 
具体步骤如下： 
- 查看安装源

1. yum repolist enabled | grep mysql

• 变更安装mysql版本

1. yum-config-manager --disable mysql80-community
2. yum-config-manager --enable mysql57-community

• 获取可用安装列表

1. yum repolist all | grep mysql

• 安装MySql

1. yum install mysql-community-server

• 修改my.cnf文件

  [client] 
  port = 3306 
  socket = /tmp/mysql.sock

  [mysql] 
  prompt="\u@\h [\d]>" 
  #pager="less -i -n -S" 
  #tee=/opt/mysql/logs/query.log 
  no-auto-rehash

  [mysqld] 
  #misc 
  user = mysql 
  basedir = /usr/local/mysql 
  datadir = /opt/mysql/data 
  port = 3306 
  socket = /tmp/mysql.sock 
  event_scheduler = 0

  tmpdir = /opt/mysql/tmp 
  #timeout 
  interactive_timeout = 300 
  wait_timeout = 300

  #character set 
  character-set-server = utf8

  open_files_limit = 65535 
  max_connections = 100 
  max_connect_errors = 100000 
  #lower_case_table_names =1 
  #logs 
  log-output=file 
  slow_query_log = 1 
  slow_query_log_file = slow.log 
  log-error = error.log 
  log_warnings = 2 
  pid-file = mysql.pid 
  long_query_time = 1 
  #log-slow-admin-statements = 1 
  #log-queries-not-using-indexes = 1 
  log-slow-slave-statements = 1

  #binlog 
  #binlog_format = STATEMENT 
  binlog_format = row 
  server-id = 23306 
  log-bin = /opt/mysql/logs/mysql-bin 
  binlog_cache_size = 4M 
  max_binlog_size = 1024M 
  max_binlog_cache_size = 1M 
  sync_binlog = 0 
  expire_logs_days = 1 
  #procedure 
  log_bin_trust_function_creators=1

  gtid-mode = 0

  #relay log 
  skip_slave_start = 1 
  max_relay_log_size = 128M 
  relay_log_purge = 1 
  relay_log_recovery = 1 
  relay-log=relay-bin 
  relay-log-index=relay-bin.index 
  log_slave_updates 
  #slave-skip-errors=1032,1053,1062 
  #skip-grant-tables

  #buffers & cache 
  table_open_cache = 2048 
  table_definition_cache = 2048 
  table_open_cache = 2048 
  max_heap_table_size = 96M 
  sort_buffer_size = 128K 
  join_buffer_size = 128K 
  thread_cache_size = 200 
  query_cache_size = 0 
  query_cache_type = 0 
  query_cache_limit = 256K 
  query_cache_min_res_unit = 512 
  thread_stack = 192K 
  tmp_table_size = 96M 
  key_buffer_size = 8M 
  read_buffer_size = 2M 
  read_rnd_buffer_size = 16M 
  bulk_insert_buffer_size = 32M

  #myisam 
  myisam_sort_buffer_size = 128M 
  myisam_max_sort_file_size = 10G 
  myisam_repair_threads = 1

  #innodb 
  innodb_buffer_pool_size = 100M 
  innodb_buffer_pool_instances = 1 
  innodb_data_file_path = ibdata1:100M:autoextend 
  innodb_flush_log_at_trx_commit = 2 
  innodb_log_buffer_size = 8M 
  innodb_log_file_size = 100M 
  innodb_log_files_in_group = 3 
  innodb_max_dirty_pages_pct = 50 
  innodb_file_per_table = 1 
  innodb_rollback_on_timeout 
  innodb_status_file = 1 
  innodb_io_capacity = 2000 
  transaction_isolation = READ-COMMITTED 
  innodb_flush_method = O_DIRECT

• 启动MySql

1. service mysqld start

• 查看初始密码

1. grep password /opt/mysql/data/error.log

• 更改密码

1. > ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

• 查看所有可用安装列表

1. yum --disablerepo=\* --enablerepo='mysql*-community*' list available

安装PHP

下载PHP二进制文件

1. http://cn2.php.net/distributions/php-7.3.2.tar.gz

下载安装curl,因需要高版本curl

1. wget https://curl.haxx.se/download/curl-7.64.0.tar.gz

安装其他必须安装包

1. yum install

解压后安装，报错缺什么包，按什么包

1. ./configure --prefix=/usr/local/php --with-config-file-path=/usr/local/php/etc --enable-fpm --with-fpm-user=php-fpm --with-fpm-group=php-fpm --with-pdo-mysql=mysqlnd --with-mysqli=mysqlnd --with-libxml-dir --with-gd --with-jpeg-dir --with-png-dir --with-freetype-dir --with-iconv-dir --with-zlib-dir --enable-soap --enable-ftp --enable-mbstring --enable-exif --disable-ipv6 --with-pear --with-curl --enable-bcmath --enable-mbstring --enable-sockets --with-gd --with-libxml-dir=/usr/local --with-gettext