设为首页收藏本站
切换到宽版

电脑疯子技术论坛|电脑极客社区

 找回密码
 注册

QQ登录

只需一步，快速开始

电脑疯子技术论坛|电脑极客社区»技术论坛 › 电脑疯子|资源分享 › 电脑教程分享 › CentOS7最小安装mysql
返回列表 发新帖

[linux教程] CentOS7最小安装mysql

[复制链接]
zhaorong 发表于 2017-3-8 15:44:08 | 显示全部楼层 |阅读模式

.安装CentOS-7-x86_64-DVD-1511.iso。
  最小安装方式。建议添加开发工具，samba和文件共享。
  安装的时候选择静态IP地址，录入机器名


2.安装网络工具包

  1. yum install net-tools

复制代码


  如果安装时为动态IP方式，则需要手工修改IP地址为静态，同时修改主机名


3.安装vmtools

  1.   mount -t auto /dev/cdrom /mnt/cdrom
  2.   cp /mnt/cdrom/VMwareTools-10.0.10-4301679.tar.gz /root
  3.   tar zxvf VMwareTools-10.0.10-4301679.tar.gz
  4.   cd vmware-tools-distrib
  5.   ./vmware-install.pl
  6.   rm -rf vmware-tools-distrib
复制代码


4.更新或升级最小化安装的 CentOS

  1.   yum update && yum upgrade
复制代码



5.添加163镜像源

  1. #mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup
  2.   cp /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.backup
  3.   cd /etc/yum.repos.d/
  4.   wget http://mirrors.163.com/.help/CentOS7-Base-163.repo
  5.   yum clean all
  6.   yum makecache
复制代码



5.安装mysql

  1. sudo rpm -Uvh mysql57-community-release-el7-9.noarch.rpm
  2.   sudo yum install mysql-community-server
  3.   vi /etc/my.cnf
复制代码


#添加以下内容

  1. log_bin_trust_function_creators=1  
  2. character-set-server=utf8
  3. lower_case_table_names=1
复制代码


  1. plugin-load=validate_password.so
  2. validate-password=FORCE_PLUS_PERMANENT
  3. sql_mode='ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,PIPES_AS_CONCAT,ANSI_QUOTES'
复制代码

  1. max_connections=4000
  2. key_buffer_size=200M
  3. low_priority_updates=1
  4. table_open_cache=8000
  5. back_log=1500
  6. query_cache_type=0
  7. table_open_cache_instances=16
复制代码

  1. # files
  2. innodb_file_per_table
  3. innodb_log_file_size=200M
  4. innodb_log_files_in_group=3
  5. innodb_open_files=4000
复制代码

  1. # buffers
  2. innodb_buffer_pool_size=1024M
  3. innodb_buffer_pool_instances=32
  4. #innodb_additional_mem_pool_size=20M
  5. innodb_log_buffer_size=64M
  6. join_buffer_size=32K
  7. sort_buffer_size=32K
复制代码


  1. # innodb
  2. innodb_checksums=0
  3. innodb_doublewrite=0
  4. innodb_support_xa=0
  5. innodb_thread_concurrency=0
  6. innodb_flush_log_at_trx_commit=2
  7. innodb_max_dirty_pages_pct=50
  8. innodb_use_native_aio=1
  9. innodb_stats_persistent=1
  10. innodb_spin_wait_delay=16 #6/96
复制代码

  1. # perfspecial
  2. innodb_adaptive_flushing=1
  3. innodb_flush_neighbors=0
  4. innodb_read_io_threads=4
  5. innodb_write_io_threads=4
  6. innodb_io_capacity=400
  7. innodb_purge_threads=1
  8. innodb_adaptive_hash_index=0
复制代码

  1. # monitoring
  2. innodb_monitor_enable='%'
  3. performance_schema=OFF
复制代码


  1. sudo service mysqld start
  2.   sudo grep 'temporary password' /var/log/mysqld.log
  3.   mysql -uroot -p
  4.     ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
  5.     use mysql
  6.     update user set host = '%' where user = 'root';
  7.     flush privileges;
复制代码

  1. exit
  2.   iptables -A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT
  3.   iptables -A INPUT -p tcp -m state --state NEW -m tcp --dport 1521 -j ACCEPT
  4.   iptables -A INPUT -p tcp -m state --state NEW -m tcp --dport 1234 -j ACCEPT
  5.   service iptables restart
  6.   service iptables stop
  7.   service firewalld stop
  8.   #systemctl disable firewalld.service
  9.   #systemctl disable iptables.service
复制代码
回复

举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

本版积分规则

手机版|小黑屋|VIP|电脑疯子技术论坛 ( Computer madman team )

GMT+8, 2025-3-14 04:02

Powered by Discuz! X3.4

Copyright © 2001-2023, Tencent Cloud.

快速回复 返回顶部 返回列表