CentOS7 环境二进制包安装mysql-5.7.40

1.目录规划

/u01/mysql/
├── data
│   └── 3306
│       ├── data
│       ├── logfile
│       ├── pid
│       ├── socket
│       └── tmp
├── sh
└── svr
[root@192-168-0-22 mysql]# mkdir -p /u01/mysql/{data/3306/{data,logfile,pid,socket,tmp},svr,sh}
[root@192-168-0-22 mysql]# ll
total 0
drwxr-xr-x. 3 root root 18 Jun 24 04:35 data
drwxr-xr-x. 2 root root  6 Jun 24 04:35 sh
drwxr-xr-x. 4 root root 52 Jun 24 04:34 svr

2.解压、建立软连接、并授权目录

【注：onedb-5.7.40-43-linux-x86_64.tar.gz为作者自行使用源码编译的二进制包，修改了版权信息】

[root@192-168-0-22 ~]# cd /u01/mysql/svr/
[root@192-168-0-22 svr]# tar -xzvf onedb-5.7.40-43-linux-x86_64.tar.gz mysql-5.7.40
[root@192-168-0-22 svr]# ln -s mysql-5.7.40 mysql
[root@192-168-0-22 svr]# ll
total 0
lrwxrwxrwx.  1 mysql mysql  12 Jan 27 04:42 mysql -> mysql-5.7.40
drwxr-xr-x. 12 mysql mysql 188 Jun 24 04:46 mysql-5.7.40
[root@192-168-0-22 svr]#
[root@192-168-0-22 svr]# chown -R mysql.mysql /u01/mysql/

3.编辑配置文件:/u01/mysql/data/3306/my3306.cnf

【注：关于MySQL对应配置文件my.cnf 默认搜索顺序可以通过“mysql --help”查看,顺序为：
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf】

[root@192-168-0-22 3306]# cat my3306.cnf
[mysqld]
basedir=/u01/mysql/svr/mysql
datadir=/u01/mysql/data/3306/data
socket=/u01/mysql/data/3306/socket/mysql.sock
pid-file=/u01/mysql/data/3306/pid/mysqld.pid

port=3306
log-error=/u01/mysql/data/3306/logfile/mysqld.log

[mysql]
socket=/u01/mysql/data/3306/socket/mysql.sock

[client]
socket=/u01/mysql/data/3306/socket/mysql.sock
[root@192-168-0-22 3306]#chown -R mysql.mysql my3306.cnf

4.初始化数据库：（建立默认的库和表）

【注：1、初始化时，data目录必须为空，2、将随机生成的登录密码记录下来】

[root@192-168-0-22 bin]# mysqld --defaults-file=/u01/mysql/data/3306/my3306.cnf --initialize --user=mysql
[root@192-168-0-22 bin]#
[root@192-168-0-22 bin]# tail /u01/mysql/data/3306/logfile/mysqld.log

2023-06-23T21:09:46.607586Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-06-23T21:09:47.394319Z 0 [Warning] InnoDB: New log files created, LSN=45790
2023-06-23T21:09:47.466786Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2023-06-23T21:09:47.531845Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 48cb4617-120a-11ee-85db-000c29a96888.
2023-06-23T21:09:47.532910Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2023-06-23T21:09:47.661154Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2023-06-23T21:09:47.661174Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2023-06-23T21:09:47.661798Z 0 [Warning] CA certificate ca.pem is self signed.
2023-06-23T21:09:47.696318Z 1 [Note] A temporary password is generated for root@localhost: mo#5iqd3.ikD
[root@192-168-0-22 bin]#

5.启动数据库

[root@192-168-0-22 bin]#
[root@192-168-0-22 bin]# su - mysql
Last login: Sat Jun 24 04:57:48 CST 2023 on pts/0
[mysql@192-168-0-22 ~]$ mysqld --defaults-file=/u01/mysql/data/3306/my3306.cnf &
[1] 15528
[mysql@192-168-0-22 ~]$
[mysql@192-168-0-22 ~]$ ps -ef|grep mysql
root      15470   9155  0 05:11 pts/0    00:00:00 su - mysql
mysql     15471  15470  0 05:11 pts/0    00:00:00 -bash
mysql     15528  15471 20 05:11 pts/0    00:00:01 mysqld --defaults-file=/u01/mysql/data/3306/my3306.cnf
mysql     15593  15471  0 05:11 pts/0    00:00:00 ps -ef
mysql     15594  15471  0 05:11 pts/0    00:00:00 grep --color=auto mysql
[mysql@192-168-0-22 ~]$
[mysql@192-168-0-22 ~]$ netstat -nlp|grep mysql
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
tcp6       0      0 :::3306                 :::*                    LISTEN      15528/mysqld
unix  2      [ ACC ]     STREAM     LISTENING     52222    15528/mysqld         /u01/mysql/data/3306/socket/mysql.sock
[mysql@192-168-0-22 ~]$

6.连接数据库:第一次强制修改密码

[mysql@192-168-0-22 ~]$ 
[mysql@192-168-0-22 ~]$ mysql -uroot -pmo#5iqd3.ikD -S /u01/mysql/data/3306/socket/mysql.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the AbcSQL monitor.  Commands end with ; or \g.
Your OneDB connection id is 2
Server version: 5.7.40-43

Copyright (c) 2000, 2023 China ABC Cooperation Co., Ltd
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
mysql> status;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql>
mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'Abc_1234';
Query OK, 0 rows affected (0.00 sec)

mysql> create user 'root'@'%' identified with mysql_native_password by 'Abc_1234';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'root'@'%' with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

7.连接数据库:正常使用

[mysql@192-168-0-22 ~]$ mysql -uroot -pGauss_234 -S /u01/mysql/data/3306/socket/mysql.sock
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the OneDB monitor.  Commands end with ; or \g.
Your OneDB connection id is 3
Server version: 5.7.40-43 Source distribution

Copyright (c) 2000, 2023 China Mobile System Integration Co., Ltd
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
mysql> status;
--------------
mysql  Ver 14.14 Distrib 5.7.40-43, for Linux (x86_64) using  6.2

Connection id:          3
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.7.40-43 Source distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /u01/mysql/data/3306/socket/mysql.sock
Uptime:                 2 min 5 sec

Threads: 1  Questions: 12  Slow queries: 0  Opens: 115  Flush tables: 1  Open tables: 33  Queries per second avg: 0.096
--------------

mysql>