mysql5.7最新版二进制安装

# 创建用户
useradd mysql

# 下载
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz

# 解压
tar zxvf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz

# 程序位置
mv mysql-5.7.30-linux-glibc2.12-x86_64 usr/local/
cd usr/local/
ln -s mysql-5.7.30-linux-glibc2.12-x86_64/ mysql

# 目录规范
mkdir data/mysql_3306/data/data -pv
cd data/mysql_3306/data
mkdir log
mkdir tmp

# 编辑配置文件
cp -rp etc/my.cnf etc/my.cnf.bak

# 37上的配置
vi etc/my.cnf
------
[client]
port=3306
socket=/data/mysql_3306/data/tmp/mysql.sock
user=mysql
[mysqld]
max_allowed_packet = 1024M
datadir             = data/mysql_3306/data/data
port              = 3306
pid-file            =/data/mysql_3306/data/tmp/mysql.pid
socket=/data/mysql_3306/data/tmp/mysql.sock
log_error            = data/mysql_3306/data/log/error.log
slow-query-log         = 1
slow-query-log-file      = data/mysql_3306/data/log/slow.log
long_query_time        = 2
log-bin            = data/mysql_3306/data/log/mysql_bin.log
binlog_format         = ROW
expire-logs-days        = 1
relay-log           = data/mysql_3306/data/log/mysql_relay.log
relay_log_recovery       = 1
general_log          = off
general_log_file        = data/mysql_3306/data/log/general.log
lower_case_table_names     = 1
server-id            = 1
character_set_client_handshake = FALSE
character_set_server      = utf8mb4
collation_server        = utf8mb4_unicode_ci
init_connect          ='SET NAMES utf8mb4'
interactive_timeout       = 172800
wait_timeout          = 172800
max_prepared_stmt_count     =1048576 
max_connections         = 8000
max_connections=4000
key_buffer_size=200M
low_priority_updates=1
table_open_cache = 8000
back_log=1500
query_cache_type=0
table_open_cache_instances=16
explicit_defaults_for_timestamp = ON
read_buffer_size = 4M
innodb_file_per_table =on
innodb_log_file_size=1024M
innodb_log_files_in_group = 3
innodb_open_files=4000
innodb_buffer_pool_size=4G
innodb_buffer_pool_instances=32
innodb_log_buffer_size=64M
join_buffer_size=32K
sort_buffer_size=32K
innodb_checksums=0
innodb_doublewrite=0
innodb_support_xa=0
innodb_thread_concurrency=0
innodb_flush_log_at_trx_commit=2
innodb_max_dirty_pages_pct=50
innodb_use_native_aio=1
innodb_stats_persistent = 1
innodb_adaptive_flushing = 1
innodb_flush_neighbors = 0
innodb_read_io_threads = 4
innodb_write_io_threads = 4
innodb_io_capacity = 4000
innodb_purge_threads=1
innodb_adaptive_hash_index=0
innodb_monitor_enable = '%'
performance_schema=OFF
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
log_queries_not_using_indexes=true
-------

# 目录权限
chown -R mysql.mysql data/mysql_3306/

# 初始化
cd usr/local/mysql 
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql_3306/data/data

# 配置环境变量，并刷新
vim etc/profile.d/mysql.sh
export PATH=/usr/local/mysql/bin:$PATH
. etc/profile.d/mysql.sh

# 生成启动脚本，并启动mysql
cp support-files/mysql.server etc/init.d/mysqld
chmod +x etc/init.d/mysqld
vim etc/init.d/mysqld
basedir=/usr/local/mysql  在第46~47行
datadir=/data/mysql_3306/data/data
/etc/init.d/mysqld start
Starting MySQL. SUCCESS!


# 查看日志
more data/mysql_3306/data/log/error.log |grep  generated

# 测试，并修改root密码
# mysql -uroot -p'jcJ3Ncguf:ql'
mysql> set password for root@localhost=password('admin@123');
Query OK, 0 rows affected, 1 warning (0.00 sec)
 

# mysql -uroot -padmin@123
mysql>

# 设置mysql可以远程
mysql> select user,host from mysql.user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| mysql.session | localhost |
| mysql.sys     | localhost |
| root          | localhost |
+---------------+-----------+
3 rows in set (0.01 sec)

mysql> update mysql.user set host='%' where user="root" and host="localhost";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select user,host from mysql.user;
+---------------+-----------+
| user          | host      |
+---------------+-----------+
| root          | %         |
| mysql.session | localhost |
| mysql.sys     | localhost |
+---------------+-----------+
3 rows in set (0.00 sec)