mysql离线安装

1.下载

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

2.安装

#创建mysql数据目录
mkdir /data/mysqldata
mkdir /data/mysql_slow_query_data/
 
 
#删除mariadb
rpm -qa|grep mariadb
 
rpm -e --nodeps mariadb-libs-5.5.65-1.el7.x86_64
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64

rpm -qa|grep mariadb
  
#安装mysql 步骤
rpm -ivh mysql-community-common-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.29-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.29-1.el7.x86_64.rpm
 
#查看mysql
systemctl status mysqld
mv my.cnf /etc/.
 
#启动mysql
systemctl enable mysqld
systemctl start mysqld
 
#查看密码后登陆
grep 'password' /var/log/mysqld.log 
mysql -u root -p
 
#修改密码
set global validate_password_policy=LOW;
set global validate_password_length=4;
SET PASSWORD = PASSWORD('123456');
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
flush privileges;

my.cnf

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/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 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
datadir=/data/mysqldata

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

sql_mode='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

log-bin=mysql-bin
binlog-format=ROW
server_id=1
max_connections=5000
 
#init_connect='SET collation_connection = utf8_unicode_ci'
#init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake

default-time_zone='+8:00'

max_allowed_packet=100M
interactive_timeout = 120
wait_timeout = 120

slow_query_log = ON
slow_query_log_file = /data/mysql_slow_query_data/slow.log     
long_query_time = 2


[client]
default-character-set=utf8
 
[mysql]
default-character-set=utf8

有遇到过慢查询一直不写进 /data/mysql_slow_query_data/slow.log 文件，是权限问题
给该文件设置权限为chmod 777 slow.log，重启mysql systemctl restart mysqld解决