解压文件并修改文件名
[mysql@test-192 webserver]$ sudo tar -xvf mysql-8.0.27-linux-glibc2.12-x86_64.tar.xz
[mysql@test-192 webserver]$ sudo mv mysql-8.0.27-linux-glibc2.12-x86_64 mysql-8.0.27
初始化mysql： 初始化完后，注意这里会给一个初始化登录mysql的密码，我的如图，可以看出我的密码是l.7hqoNgdk5&; 全都是，看着比较奇怪。注意密码前面有一个空格，一定要去掉空格，我就被坑了。
[mysql@test-192 mysql-8.0.27]$ sudo ./bin/mysqld --initialize --user=mysql
2023-06-07T08:22:13.593854Z 0 [System] [MY-013169] [Server] /data/webserver/mysql-8.0.27/bin/mysqld (mysqld 8.0.27) initializing of server in progress as process 27480
2023-06-06T08:22:13.626803Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-06-06T08:22:15.944737Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-06-06T08:22:18.552227Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1 is enabled for channel mysql_main
2023-06-06T08:22:18.552294Z 0 [Warning] [MY-013746] [Server] A deprecated TLS version TLSv1.1 is enabled for channel mysql_main
2023-06-06T08:22:18.653182Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: l.7hqoNgdk5&
接下来继续执行命令，修改配置文件，下面两个命令都要执行，然后会打开一个文件，把文件里面内容删光，照我的内容复制粘贴上去。然后：wq 保存，一定要保存
[mysql@test-192 mysql-8.0.27]$ sudo vim /etc/my.cnf
[mysqld]
###安装mysql路径
basedir=/data/webserver/mysql-8.0.27
datadir=/data/webserver/mysql-8.0.27/data
socket=/data/webserver/mysql-8.0.27/data/mysql.sock
##字符集
character-set-server = utf8mb4
##保留binlog日志天数
expire_logs_days = 7
##最大连接数
max_connect_errors = 500
collation-server = utf8mb4_unicode_ci
init-connect='SET NAMES utf8mb4'
character-set-server = utf8mb4
[client]
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8mb4
启动mysql
[mysql@test-192 mysql-8.0.27]$ sudo ./support-files/mysql.server start
Starting MySQL.. SUCCESS!
# 启动之后/var/lib没有生成mysql路径，需要手动创建一下
[mysql@test-192 mysql-8.0.27]$ sudo mkdir /var/lib/mysql
[mysql@test-192 mysql-8.0.27]$ sudo ln -s /data/webserver/mysql-8.0.27/data/mysql.sock /var/lib/mysql/mysql.sock
成功后我们就要修改mysql密码了，初始化时候有一个密码，用他先登录mysql
[mysql@test-192 mysql-8.0.27]$ sudo mysql -uroot -p
Enter password:
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1369
Server version: 8.0.27 MySQL Community Server - GPL
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> set password='123456'; # 修改密码
Query OK, 0 rows affected (0.01 sec)
mysql> use mysql;
mysql> update user set host = '%' where user = 'root'; # 修改用户远程访问权限
