1、下載和解壓包

wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz
安裝目錄：/home/mysql/
tar -xvJf mysql-8.0.30-linux-glibc2.12-x86_64.tar.xz
mv mysql-8.0.30-linux-glibc2.12-x86_64 mysql
cd /home/mysql
mkdir data

[root@radiuso mysql]# ll
total 1058460
drwxr-xr-x. 2 root root 6 Jun 27 14:21 data
drwxr-xr-x. 9 root root 129 Jun 27 14:21 mysql

用戶和組：groupadd mysql
useradd -g mysql mysql
[root@radiuso mysql]# groupadd mysql
[root@radiuso mysql]# useradd -g mysql mysql

目錄權限：chown -R mysql.mysql /home/mysql/
Chmod -R 755 /home/mysql/
[root@radiuso mysql]# chown -R mysql.mysql /home/mysql/
[root@radiuso mysql]# chmod -R 755 /home/mysql/
[root@radiuso mysql]# ll
total 1058460
drwxr-xr-x. 2 mysql mysql 6 Jun 27 14:21 data
drwxr-xr-x. 9 mysql mysql 129 Jun 27 14:21 mysql
-rwxr-xr-x. 1 mysql mysql 1084018688 Jun 27 12:18 mysql-8.0.30-linux-glibc2.12-x86_64.tar

2、配置文件

Vi /etc/my.cnf
[client]
port=3307
socket=/home/mysql/mysql.sock
[mysqld]
port=3307
user=mysql
socket=/home/mysql/mysql.sock
basedir=/home/mysql/mysql
datadir=/home/mysql/data
lower-case-table-names=1
default_authentication_plugin=mysql_native_password
#skip-grant-tables
#innodb_buffer_pool_size=105109258240
innodb_buffer_pool_size=100G

:wq

3、初始化

bin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql --lower-case-table-names=1 --basedir=/home/mysql/mysql --datadir=/home/mysql/data

[root@radiuso bin]# ./mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql --lower-case-table-names=1 --basedir=/home/mysql/mysql --datadir=/home/mysql/data
2022-06-27T06:40:47.158585Z 0 [System] [MY-013169] [Server] /home/mysql/mysql/bin/mysqld (mysqld 8.0.30) initializing of server in progress as process 39435
2022-06-27T06:40:47.167144Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-06-27T06:40:48.067547Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-06-27T06:40:50.193057Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: =u:fwuuOt8ds

4、啟動

cp /home/mysql/support-files/mysql.server /etc/init.d/mysql
systemctl start mysql
[root@RadiusP bin]# mysql -u root -p
Enter password:
ERROR 1862 (HY000): Your password has expired. To log in you must change it using a client that supports expired passwords.
Vi /etc/my.cnf
[mysqld]
Skip-grant-tables
[root@RadiusP bin]# service mysql stop
Shutting down MySQL… [ OK ]
[root@RadiusP bin]# service mysql start
Starting MySQL. [ OK ]
[root@RadiusP bin]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.30 MySQL Community Server - GPL

Copyright ? 2000, 2017, Oracle, MariaDB Corporation Ab and others.

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

MySQL [(none)]> 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 [mysql]> select * from mysql.user where user=‘root’ \G
*************************** 1. row ***************************
Host: localhost
User: root
Select_priv: Y
Insert_priv: Y
Update_priv: Y
Delete_priv: Y
Create_priv: Y
Drop_priv: Y
Reload_priv: Y
Shutdown_priv: Y
Process_priv: Y
File_priv: Y
Grant_priv: Y
References_priv: Y
Index_priv: Y
Alter_priv: Y
Show_db_priv: Y
Super_priv: Y
Create_tmp_table_priv: Y
Lock_tables_priv: Y
Execute_priv: Y
Repl_slave_priv: Y
Repl_client_priv: Y
Create_view_priv: Y
Show_view_priv: Y
Create_routine_priv: Y
Alter_routine_priv: Y
Create_user_priv: Y
Event_priv: Y
Trigger_priv: Y
Create_tablespace_priv: Y
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0
plugin: mysql_native_password
authentication_string: *4FEC5BAD03EFD5A8FC5CD68197B9CC859354753F
password_expired: Y
password_last_changed: 2022-06-27 15:50:00
password_lifetime: NULL
account_locked: N
Create_role_priv: Y
Drop_role_priv: Y
Password_reuse_history: NULL
Password_reuse_time: NULL
Password_require_current: NULL
User_attributes: NULL
1 row in set (0.00 sec)

設置成不過期
MySQL [mysql]> update user set password_expired=‘N’ where user=‘root’;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

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

MySQL [mysql]> quit

Vi /etc/my.cnf
[mysqld]
#Skip-grant-tables //設置密碼不過期后注釋掉
重啟服務

問題：

修改密碼：
alter user ‘root’@’localhost’ identified by ‘xxxx’;

錯誤：ERROR 2059 (HY000): Authentication plugin ‘caching_sha2_password’ cannot be loaded: /usrb64/mysqlugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

Vi /etc/my.cnf

默認使用“mysql_native_password”插件認證

default_authentication_plugin=mysql_native_password
:wq
重啟服務