本文将介绍在 Centos7 版本中安装 MySQL 免安装版本。
使用浏览器访问 mysql 官网，获取 mysql 安装包的下载地址：
https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.35-el7-x86_64.tar.gz
（1）使用 wget 命令下载，如下：
[root@localhost ~]# wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.35-el7-x86_64.tar.gz
--2021-11-05 13:01:34-- https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.35-el7-x86_64.tar.gz
Resolving cdn.mysql.com (cdn.mysql.com)... 104.107.242.188
Connecting to cdn.mysql.com (cdn.mysql.com)|104.107.242.188|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 732374542 (698M) [application/x-tar-gz]
Saving to: ‘mysql-5.7.35-el7-x86_64.tar.gz.1’
100%[======================================>] 732,374,542 3.34MB/s in 3m 21s
2021-11-05 13:04:56 (3.47 MB/s) - ‘mysql-5.7.35-el7-x86_64.tar.gz’ saved [732374542/732374542]注意：mysql 安装包大小为 600+MB，需要等待一会儿。
（2）成功下载 mysql 安装包后，使用 tar 命令解压安装包，如下：
[root@localhost ~]# tar -xvzf mysql-5.7.35-el7-x86_64.tar.gz
mysql-5.7.35-el7-x86_64/bin/myisam_ftdump
...
mysql-5.7.35-el7-x86_64/docs/INFO_BIN
mysql-5.7.35-el7-x86_64/docs/INFO_SRC（3）使用 mv 命令将解压后的目录重命名为 “mysql”，如下：
[root@localhost ~]# mv mysql-5.7.35-el7-x86_64 mysql（4）使用 mv 命令将重命名后的 mysql 移动到 /usr/local/ 目录，如下：
[root@localhost ~]# sudo mv mysql /usr/local/
[root@localhost ~]# ls /usr/local/mysql/
bin docs include lib LICENSE man README share support-files（1）配置 my.cnf 文件，将 mysql 的 support-files 目录下的 my.cnf 文件复制到 /etc/my.cnf。mysql 5.7 之后support-files 目录下没有 my.cnf 文件，所以直接创建 /etc/my.cnf 文件。my.cnf 文件内容如下：
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]
log-error=/var/log/error.log
pid-file=/usr/local/mysql/data/mysqld.pid
[client]
socket=/usr/local/mysql/mysql.sock
default-character-set=utf8（2）创建 mysql 数据目录，如下：
[root@localhost ~]# cd /usr/local/
[root@localhost local]# mkdir data
[root@localhost local]# ll
total 0
drwxr-xr-x. 2 root root 6 Apr 11 2018 bin
drwxr-xr-x. 2 root root 6 Nov 5 13:18 data
drwxr-xr-x. 2 root root 6 Apr 11 2018 etc
drwxr-xr-x. 2 root root 6 Apr 11 2018 games
drwxr-xr-x. 2 root root 6 Apr 11 2018 include
drwxr-xr-x. 2 root root 6 Apr 11 2018 lib
drwxr-xr-x. 2 root root 6 Apr 11 2018 lib64
drwxr-xr-x. 2 root root 6 Apr 11 2018 libexec
drwxr-xr-x. 11 root root 151 Oct 1 06:53 nginx
drwxr-xr-x. 2 root root 6 Apr 11 2018 sbin
drwxr-xr-x. 5 root root 49 Aug 3 01:28 share
drwxr-xr-x. 2 root root 6 Apr 11 2018 src（3）出于安全和便利，创建一个专门操作数据库的用户。如下：
a、建立一个 mysql 组
[root@localhost mysql]# groupadd mysqlb、建立 mysql 用户，并且把用户放到 mysql 组
[root@localhost mysql]# useradd -r -g mysql mysqlc、将目录 /usr/local/mysql 拥有者改为 mysql
[root@localhost mysql]# chown -R mysql:mysql /usr/local/mysql/
[root@localhost mysql]# ll
total 272
drwxr-xr-x. 2 mysql mysql 4096 Nov 5 13:00 bin
drwxr-xr-x. 2 mysql mysql 6 Nov 5 13:22 data
drwxr-xr-x. 2 mysql mysql 55 Nov 5 13:00 docs
drwxr-xr-x. 3 mysql mysql 4096 Nov 5 12:59 include
drwxr-xr-x. 5 mysql mysql 230 Nov 5 13:00 lib
-rw-r--r--. 1 mysql mysql 259200 Jun 7 20:52 LICENSE
drwxr-xr-x. 4 mysql mysql 30 Nov 5 13:00 man
-rw-r--r--. 1 mysql mysql 566 Jun 7 20:52 README
drwxr-xr-x. 28 mysql mysql 4096 Nov 5 13:00 share
drwxr-xr-x. 2 mysql mysql 90 Nov 5 13:00 support-files使用 mysql 的 “mysqld --initialize” 命令初始化 mysql 数据库，如下：
[root@localhost bin]# ./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
2021-11-05T05:24:20.044232Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-11-05T05:24:20.248550Z 0 [Warning] InnoDB: New log files created, LSN=45790
2021-11-05T05:24:20.286955Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2021-11-05T05:24:20.348752Z 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: a0f8d057-3df8-11ec-b3cb-000c29633905.
2021-11-05T05:24:20.349623Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-11-05T05:24:21.488386Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2021-11-05T05:24:21.488406Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2021-11-05T05:24:21.489119Z 0 [Warning] CA certificate ca.pem is self signed.
2021-11-05T05:24:21.778522Z 1 [Note] A temporary password is generated for root@localhost: 0hrhgOkuq1%1注意：上面初始化 mysql 最后输出的 “0hrhgOkuq1%1” 为 mysql 默认密码。
[root@localhost bin]# ./mysqld_safe --user=mysql &
[1] 23488
2021-11-05T05:26:38.297282Z mysqld_safe Logging to '/var/log/error.log'.
2021-11-05T05:26:38.352368Z mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data（1）使用 mysql 客户端工具连接到 mysql 客户端（这里使用上面初始化 mysql 生成的密码 0hrhgOkuq1%1），如下：
[root@localhost bin]# ./mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.35
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
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.
mysql>（2）初次登录 mysql 需要修改密码，如下：
mysql> set password=password('aaaaaa');
Query OK, 0 rows affected, 1 warning (0.00 sec)（3）演示 mysql 的 show、use、select 语句，如下：
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> use mysql
Database changed
mysql> select Host,User from user;
+-----------+---------------+
| Host | User |
+-----------+---------------+
| localhost | mysql.session |
| localhost | mysql.sys |
| localhost | root |
+-----------+---------------+
3 rows in set (0.00 sec)
川公网安备51010802032098
