Centos7安装Mysql5.7

参考

官方安装文档

卸载 mariadb

yum remove -y mariadb-libs-5.5.68

下载mysql5.7

https://dev.mysql.com/downloads/mysql/

下载RPM包

wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.44-1.el7.x86_64.rpm-bundle.tar

创建解压目录

mkdir -p mysql5.7.44

tar -xvf mysql-5.7.44-1.el7.x86_64.rpm-bundle.tar -C mysql5.7.44

安装mysql-server

rpm -ivh mysql-community-{server,client,common,libs}-*

修改基础配置文件

vim /etc/my.cnf

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# 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
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

#慢日志
slow_query_log=ON
long_query_time=5
slow_query_log_file=/var/log/mysql-slow.log

##设置缓冲池实例为8个
innodb_buffer_pool_instances=8
#为所有线程打开的表的数量
table_open_cache=65536

#### Threads ###
innodb_purge_threads=4
innodb_page_cleaners=8
innodb_read_io_threads=16
innodb_write_io_threads=16

#### Buffer Cache ###
##### Global ###
##设置缓冲池大小为
innodb_buffer_pool_size=24G
innodb_buffer_pool_chunk_size=128M
innodb_change_buffering=ALL
innodb_change_buffer_max_size=25

#### Connections ###
back_log=1500
max_connections=10000
max_connect_errors=100000
open_files_limit=65535
table_definition_cache=10000
thread_cache_size=1000
#connect_timeout=30
#interactive_timeout=3600
#wait_timeout=3600
#net_read_timeout=86400
#net_write_timeout=86400

### InnoDB Engine ###
###事务隔离级别，默认为可重复读，mysql默认可重复读级别（此级别下可能参数很多间隙锁，影响性能）
transaction_isolation=READ-COMMITTED

# 服务端使用的字符集默认为UTF8
character-set-server=utf8mb4

# 不区分表名大小写
lower_case_table_names=1

# 关闭DNS解析
skip_name_resolve=ON

# 单个数据包（网络传输或 SQL 语句）的最大值，不建议超过1G, 默认值4M
max_allowed_packet=960M

# 全文检索
innodb_ft_total_cache_size=1600M
innodb_ft_cache_size=80M
innodb_ft_min_token_size=2
ft_min_word_len=2
ngram_token_size=2


[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8mb4

• 创建慢日志文件

sudo -u mysql echo "" > /var/log/mysql-slow.log

启动mysqld

systemctl start mysqld

获取默认root密码

grep ‘temporary password’ /var/log/mysqld.log

登录修改密码

mysql -uroot -p

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

修改root@localhost，允许远程连接

mysql> UPDATE user SET host='%' WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> exit

重启服务

systemctl restart mysqld

netstat -nltp