【MySQL】尺度化安装教程

摇滚辣辣妹

导读：
本文重要先容 CentOS 体系二进制安装 MySQL 5.7.23 版本的安装步调，其他版本安装过程相似。

1.前置预备

• 卸载旧版MySQL
  

检察rpm包
rpm-qa|grep mysql 如有可用 rpm-e卸载
查找mysql残留包，有则删除，没有则忽略
find/-name mysql

• 安装相干依靠
  

yum-y install make gcc-c++cmake bison-devel ncurses-devel numactl libaio

• 创建用户和用户组
  

groupadd mysqluseradd-s/sbin/nologin-g mysql-M mysql
2.下载二进制安装包并解压

3.创建mysql相干目次

• mkdir -p /data/mysql/{data,logs,tmp}
  
• # 更改文件夹所属
  
• chown -R mysql.mysql /data/mysql/
  

4.创建mysql设置文件my.cnf

• vi /etc/my.cnf
  
• # 简朴模板如下：
  
• [client]
  
• port            = 3306
  
• socket          = /data/mysql/tmp/mysql.sock
  
• 
  
• [mysqld]
  
• user = mysql
  
• basedir = /usr/local/mysql        
  
• datadir = /data/mysql/data  
  
• port = 3306               
  
• 
  
• socket = /data/mysql/tmp/mysql.sock
  
• pid-file  = /data/mysql/tmp/mysqld.pid
  
• tmpdir = /data/mysql/tmp   
  
• skip_name_resolve = 1
  
• symbolic-links=0
  
• max_connections = 2000
  
• group_concat_max_len = 1024000
  
• sql_mode = NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  
• lower_case_table_names = 1
  
• log_timestamps=SYSTEM
  
• character-set-server = utf8
  
• interactive_timeout = 1800  
  
• wait_timeout = 1800
  
• max_allowed_packet = 32M
  
• binlog_cache_size = 4M
  
• sort_buffer_size = 2M
  
• read_buffer_size = 4M
  
• join_buffer_size = 4M
  
• tmp_table_size = 96M
  
• max_heap_table_size = 96M
  
• max_length_for_sort_data = 8096
  
• 
  
• #logs
  
• server-id = 1003306
  
• log-error = /data/mysql/logs/error.log
  
• slow_query_log = 1
  
• slow_query_log_file = /data/mysql/logs/slow.log
  
• long_query_time = 3
  
• log-bin = /data/mysql/logs/binlog
  
• binlog_format = row
  
• expire_logs_days = 15
  
• log_bin_trust_function_creators = 1
  
• relay-log = /data/mysql/logs/relay-bin
  
• relay-log-recovery = 1  
  
• relay_log_purge = 1  
  
• 
  
• #innodb  
  
• innodb_file_per_table = 1
  
• innodb_log_buffer_size = 16M
  
• innodb_log_file_size = 256M
  
• innodb_log_files_in_group = 2
  
• innodb_io_capacity = 2000
  
• innodb_io_capacity_max = 4000
  
• innodb_flush_neighbors = 0
  
• innodb_flush_method = O_DIRECT
  
• innodb_autoinc_lock_mode = 2
  
• innodb_read_io_threads = 8
  
• innodb_write_io_threads = 8
  
• innodb_buffer_pool_size = 2G
  

5.设置mysql.server

• cd /usr/local/mysql/support-files
  
• cp mysql.server /etc/init.d/mysql
  
• vi /etc/init.d/mysql
  
• # 修改目次位置
  
• basedir=/usr/local/mysql
  
• datadir=/data/mysql/data
  
• 
  
• # 注册开机启动服务
  
• chkconfig --add mysql
  
• chkconfig --list
  

6.添加情况变量

• echo "PATH=$PATH:/usr/local/mysql/bin  " >> /etc/profile  
  
• source /etc/profile
  

7.初始化mysql

8.启动mysql服务 并修改暗码

• # 启动mysql服务
  
• service mysql start
  
• # 利用初始暗码登录mysql服务 并修改暗码
  
• mysql -uroot -p
  
• alter user 'root'@'localhost' identified by 'root';
  
• flush privileges;
  

— END —

假如你喜好我的文章

请在文末右下角点一下悦目❤