零基础安装MySQL 5.7数据库

cat /sys/block/sda/queue/scheduler
#cfq完全公平队列；noop电梯式调度；deadline截止时间调度

cat /proc/sys/vm/swappiness
编辑 /etc/sysctl.conf 加入vm.swappiess的值

ulinit -a
open files和max user processes，建议均设置为65535
vim /etc/security/limits.conf
* soft nproc 65535
* hard nproc 65535
* soft nofile 65535
* hard nofile 65535

numa --interleave=all /usr/local/mysql/bin/mysqld_safe -defaults-file=/etc/my.cnf &

[root@wjq1 Packages]# md5sum mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
075dccd655e090ca999e2c8da3b67eb7  mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

[root@wjq1 Packages]# mv mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz /usr/local/

[root@wjq1 Packages]# cd /usr/local/
[root@wjq1 local]# tar zxvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

[root@wjq1 local]# ln -s mysql-5.7.24-linux-glibc2.12-x86_64 mysql

[root@wjq1 ~]# mkdir -p /data/mysql/3306/{data,log,tmp}
[root@wjq1 ~]# chown -R mysql:mysql /usr/local/mysql
[root@wjq1 ~]# chown -R mysql:mysql /data/mysql/

[root@wjq1 ~]# vim /etc/my.cnf
[client]
port=3306
socket=/tmp/mysql3306.sock

[mysql]
prompt=\\U [\\d]>

[mysqld]
user=mysql
basedir = /usr/local/mysql
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
character_set_server = utf8mb4

datadir=/data/mysql/3306/data
port=3306
server_id=330610
socket=/tmp/mysql3306.sock
log-output=file
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /data/mysql/3306/log/slow.log
log-error = /data/mysql/3306/log/error.log
pid-file = /data/mysql/3306/tmp/mysql3306.pid
binlog_format = mixed
log-bin = /data/mysql/3306/log/mysql3306.bin

#gtid-mode = ON
#enforce-gtid-consistency = ON
#log-slave-updates = ON

[root@wjq1 ~]# cd /usr/local/mysql/bin/
[root@wjq1 bin]# ./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/data/mysql/3306/data --user=mysql --initialize
#--initialize参数，生成一个临时数据库初始密码，记录在log-error里面

[root@wjq1 bin]# ./mysqld_safe --defaults-file=/etc/my.cnf &
[1] 7481
[root@wjq1 bin]# 2018-11-05T07:10:36.482523Z mysqld_safe Logging to '/data/mysql/3306/log/error.log'.
2018-11-05T07:10:36.511901Z mysqld_safe Starting mysqld daemon with databases from /data/mysql/3306/data

[root@wjq1 bin]# netstat -tuplan | grep mysqld
tcp6       0      0 :::3306                 :::*                    LISTEN      7739/mysqld

[root@wjq1 ~]# cat /data/mysql/3306/log/error.log | grep password
2018-11-05T07:10:19.979308Z 1 [Note] A temporary password is generated for root@localhost: F?IJVgCaa1h4

[root@wjq1 bin]# ./mysql -u root -p                         
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.24-log

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root [(none)]>select user,host from mysql.user;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

root [(none)]>set password='XXXX@2019';
Query OK, 0 rows affected (0.00 sec)

./mysqld_safe --defaults-file=/etc/my.cnf --skip-grant-tables &

use mysql

update user set authentication_string=password('root123') where user='root';

flush privileges;