Linux下MySQL的三种安装方式（简记）

一.官方源方式安装
:yum install mysql80-community-release-e17.noarch.rpm:yum list | grep “mysql-community”
方式等待时间较长

二.rpm包安装
安装包获取：https://dev.mysql.com/downloads/mysql/

:rpm -e mariadb-libs postfix //下载完成后先卸载自带的mariadb

:tar xJf mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar -C mysql //解压缩至已创建好的文件夹下，在文件下还下载有mysql-community-client-8.0.20-1.el7.x86_64.rpm；mysql-community-client-8.0.20-1.el7.x86_64.rpm这两个文件:cd mysql:分别按照步骤安装以下文件（test、之类文件按需求安装）

三.通用二进制安装
下载地址：http://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-8.0/
安装依赖包
：yum -y install make gcc-c++ cmake bison-devel ncurses-devel readline-devel libaio-deve perl libaio wget lrzsz vim libuma* bzip2 xz

关闭selinux防火墙
:getenforce //查看selinux防火墙状态
:setenforce 0 //修改系统限制参数建议使用vim
：vim /etc/security/limits.conf
###custom#
soft nofile 20480
hard nofile 65535
soft nproc 20480
hard nproc 65535
修改内核参数
vm.swappiness=0
#增加tcp支持的队列数
net.ipv4.tcp_max_syn_backlog = 65535
#减少断开连接时，资源回收
net.ipv4.tcp_max_tw_buckets = 8000net.ipv4.tcp_tw_reuse = 1net.ipv4.tcp_tw_recycle = 1net.ipv4.tcp_fin_timeout = 10
#改变本地的端口范围
net.ipv4.ip_local_port_range = 1024 65535
#允许更多的连接进入队列
net.ipv4.tcp_max_syn_backlog = 4096
#对于只在本地使用的数据库服务器
net.ipv4.tcp_fin_timeout = 30
#端口监听队列
net.core.somaxconn=65535
#接受数据的速率net.core.netdev_max_backlog=65535
net.core.wmem_default=87380
net.core.wmem_max=16777216
net.core.rmem_default=87380
net.core.rmem_max=16777216
EOF
sysctl -pmysql的安装配置
: tar xJf mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz -C /opt/ //解压压缩包到opt目录下
:cd /usr/local/
:ln -s /opt/mysql-8.0.20-linux-glibc2.12-x86_64 mysql //做软连接到/usr/bin:groupadd
mysql:useradd -g mysql mysql -d /home/mysql -s/sbin/nologin //创建用户
:chown -R mysql.mysql mysql/ //修改目录权限
:cd mysql/:bin/mysqld --initializa --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data **//初始化数据库root@localhost:****(*为初始密码)
:vim /etc/mycnf //修改配置文件 原配置文件为db的配置文件
[client]
port = 3306
socket = /tmp/mysql.sock

[mysqld
]server_id=10
port = 3306
user = mysql
character-set-server = utf8
default_storage_engine = innodb
log_timestamps = SYSTE
Msocket = /tmp/mysql.sock
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
pid-file = /usr/local/mysql/data/mysqld.pid
max_connections = 1000
max_connect_errors = 1000
table_open_cache = 1024
max_allowed_packet = 128
Mopen_files_limit=65535
#####[innodb]==
innodb_buffer_pool_size = 1024M
innodb_file_per_table = 1
innodb_write_io_threads = 4
innodb_read_io_threads = 4
innodb_purge_threads = 2
innodb_flush_log_at_trx_commit = 1
innodb_log_file_size = 512M
innodb_log_files_in_group = 2
innodb_log_buffer_size = 16M
innodb_max_dirty_pages_pct = 80
innodb_lock_wait_timeout=30
innodb_data_file_path=ibdata1:10M:autoextend #####=====[log]
log_error = /var/log/mysql-error.log
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /var/log/mysql-slow.log

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

:cd /usr/local/mysql
:cp support-files/mysql.server /etc/rc.d/init.d/mysqld
:chmod +x /etc/rec.d/init.d/mysqld //为mysql提供sysv服务脚本
:chkconfig --add mysqld on //添加系统服务
:chkconfig mysqld on //开机自启动
:systemctl start mysqld //启动mysql
:vim mysql
shexport PATH=$PATH:/usr/local/mysql/binsource mysql.sh //配置path环境变量否则无法输入mysql进入mysql界面