江苏龙网

  1. 主页 > 生活百科 > >

CentOS下MySQL8.0的超详细的安装及配置文档

MySQL8.0

操作系统环境：centos linux release 7.7.1908 (Core)

CentOS下MySQL8.0的超详细的安装及配置文档

文章插图
 
基础环境配置关闭SeLinux及防火墙sed -i "s/SELINUX=enforcing/SELINUX=disabled/" /etc/selinux/configsetenforce 0 ?systemctl stop firewalld  //停止系统默认的防火墙systemctl mask firewalld  //屏蔽服务(让它不能启动)yum remove -y firewalld     //卸载系统自带的防火墙安装运维基础工具yum install -y chkconfignet-tools ntsysv mlocate lrzsz wget lsof setuptool 安装yum源yum install -y epel-releasewget https://dev.MySQL.com/get/mysql80-community-release-el7-2.noarch.rpmyum localinstall -y mysql80-community-release-el7-2.noarch.rpmMySQL8.0安装yum install -y bison-devel libaio-devel perl-Data-Dumperyum install -y mysql-serversystemctl start mysqld     //启动MySQLsystemctl enable mysqld.service//开机自启动
由于mysql的yum源是在国外，所以，在国内安装很慢，因此，森哥的做法，是直接下载rpm包回来手工安装。如下操作：
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.19-1.el7.x86_64.rpm-bundle.tartar -xvf mysql-8.0.19-1.el7.x86_64.rpm-bundle.taryum localinstall -y mysql-community-*     //使用localinstall会自己补足未安装的所需要组件systemctl start mysqld     //启动MySQLsystemctl enable mysqld.service//开机自启动
CentOS下MySQL8.0的超详细的安装及配置文档

文章插图
 

CentOS下MySQL8.0的超详细的安装及配置文档

文章插图
 
修改初始密码grep 'temporary password' /var/log/mysqld.log     //mysql5.7版本后，初始密码不再为空，默认随机生成，可通过该命令查询mysql -u root -p   //进入mysql，输入刚刚查到的密码alter user 'root'@'localhost' identified with mysql_native_password by '三种或以上的八位字符';      //修改密码，并将密码插件更改为mysql_native_password初始my.cnf配置的内容为：
cat /etc/my.cnf# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html?[mysqld]## Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128M## Remove the leading "# " to disable binary logging# Binary logging captures changes between backups and is enabled by# default. It's default setting is log_bin=binlog# disable_log_bin## Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2M## Remove leading # to revert to previous value for default_authentication_plugin,# this will increase compatibility with older clients. For background, see:# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin# default-authentication-plugin=mysql_native_password?datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock?log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid原则上，上面的这个配置，就可以正常使用了 。但有时候为了一些业务场合的应用，就需要考虑对其进行修改，以达到符合实现业务的需求 。
【CentOS下MySQL8.0的超详细的安装及配置文档】mkdir /var/log/mysqldtouch /var/log/mysqld/error.logchown mysql.mysql /var/log/mysqld -R# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html[mysqld]## Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128M## Remove the leading "# " to disable binary logging# Binary logging captures changes between backups and is enabled by# default. It's default setting is log_bin=binlog# disable_log_bin## Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2M## Remove leading # to revert to previous value for default_authentication_plugin,# this will increase compatibility with older clients. For background, see:# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_default_authentication_plugin# default-authentication-plugin=mysql_native_password# server-id = 1//单MySQL服务下，可以省略不用datadir=/var/lib/mysql//数据文件所在位置socket=/var/lib/mysql/mysql.sock//sock文件所在位置log_error = /var/log/mysqld/error.log//数据库错误日志文件# skip_name_resolve = 1//设置这个，说明只能通过IP连接，不用主机名，一般不建议使用character-set-server=utf8mb4//数据库默认字符集，可以支持表情符号等，utf8不支持表情符号 。另外utf8mb4是mysql8.0起支持的 。collation-server = utf8mb4_general_ci//数据库字符集对应一些排序等规则，必须和character-set-server对应transaction_isolation = READ-COMMITTED//事务隔离级别，默认为可重复读init_connect='SET NAMES utf8mb4'//设置client连接mysql时的字符集,防止乱码max_connections=500//最大连接数max_connect_errors = 1000//最大错误连接数explicit_defaults_for_timestamp = true//TIMESTAMP如果没有显示声明NOT NULL，允许NULL值max_allowed_packet = 1024M//SQL数据包发送的大小，如果有BLOB对象建议修改成1G# interactive_timeout = 1800//MySQL默认的wait_timeout值为8个小时, interactive_timeout参数需要同时配置才能生效# wait_timeout = 1800tmp_table_size = 134217728//内部内存临时表的最大值，超过了这个值将写入磁盘，系统IO压力增大max_heap_table_size = 134217728# query_cache_size = 0//禁用mysql的缓存查询结果集功能，可根据业务需求是否开启，通常为关闭# query_cache_type = 0# slow_query_log = 1//慢查询sql日志设置# slow_query_log_file = /var/log/mysqld/slow.log# long_query_time = 8//慢查询执行的秒数，必须达到此值可被记录# log_queries_not_using_indexes = 1//检查未使用到索引的sql# log_throttle_queries_not_using_indexes = 5//开启后，记录慢sql的频次、每分钟记录的条数# min_examined_row_limit = 100// 检索的行数必须达到此值才可被记为慢查询# skip-log-bin//关闭binlog功能binlog_expire_logs_seconds=604800//binlog日志文件保存的过期时间，过期后自动删除innodb_log_file_size=60Minnodb_buffer_pool_size=128M[client]default-character-set=utf8mb8socket=/var/lib/mysql/mysql.sock[mysqld_safe]open-files-limit = 8192log-error=/var/log/mysqld.logsocket=/var/lib/mysql/mysql.sockpid-file=/var/run/mysqld/mysqld.pid


推荐阅读


上一篇：决明子菊花茶泡水喝的功效,玫瑰花茶泡水喝的功效

下一篇：牡丹花茶属于什么茶,调味茶是什么