Mysql centOs安装教程_warning: mysql-community-server-8.3.0-1.el8.x86_64

CentOs系统默认已安装mariadb

[root@MiWiFi-RA80-srv data]# rpm -qa |grep mariadb   （查看是否安装mariadb）
[root@MiWiFi-RA80-srv data]# rpm -qa | grep mysql    （查看是否安装mysql）
[root@MiWiFi-RA80-srv data]# uname -a   （查看系统版本）
Linux MiWiFi-RA80-srv 4.18.0-193.el8.x86_64 #1 SMP Fri May 8 10:59:10 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
[root@MiWiFi-RA80-srv data]# cat /etc/redhat-release  （查看系统版本）
CentOS Linux release 8.2.2004 (Core) 
[root@MiWiFi-RA80-srv data]# hostnamectl   （查看系统版本）
   Static hostname: localhost.localdomain
Transient hostname: MiWiFi-RA80-srv
         Icon name: computer-vm
           Chassis: vm
        Machine ID: a8b78a2e5ecc4443a4bab956012e338a
           Boot ID: 25a9b38e9c854e77acd0dbd70b79ef55
    Virtualization: vmware
  Operating System: CentOS Linux 8 (Core)
       CPE OS Name: cpe:/o:centos:centos:8
            Kernel: Linux 4.18.0-193.el8.x86_64
      Architecture: x86-64
[root@MiWiFi-RA80-srv data]# 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

因为系统版本是el8的，所以安装mysql版本是el8，如下图：

找到对应的系统版本即可
mysql下载地址为 https://dev.mysql.com/downloads/mysql/5.1.html

下载并安装

以下载mysql-8.3.0-1.el8.x86_64.rpm-bundle.tar为主 解压文件

[root@MiWiFi-RA80-srv data]#  tar -xvf mysql-8.3.0-1.el8.x86_64.rpm-bundle.tar
mysql-community-client-8.3.0-1.el8.x86_64.rpm
mysql-community-client-debuginfo-8.3.0-1.el8.x86_64.rpm
mysql-community-client-plugins-8.3.0-1.el8.x86_64.rpm
mysql-community-client-plugins-debuginfo-8.3.0-1.el8.x86_64.rpm
mysql-community-common-8.3.0-1.el8.x86_64.rpm
mysql-community-debuginfo-8.3.0-1.el8.x86_64.rpm
mysql-community-debugsource-8.3.0-1.el8.x86_64.rpm
mysql-community-devel-8.3.0-1.el8.x86_64.rpm
mysql-community-icu-data-files-8.3.0-1.el8.x86_64.rpm
mysql-community-libs-8.3.0-1.el8.x86_64.rpm
mysql-community-libs-debuginfo-8.3.0-1.el8.x86_64.rpm
mysql-community-server-8.3.0-1.el8.x86_64.rpm
mysql-community-server-debug-8.3.0-1.el8.x86_64.rpm
mysql-community-server-debug-debuginfo-8.3.0-1.el8.x86_64.rpm
mysql-community-server-debuginfo-8.3.0-1.el8.x86_64.rpm
mysql-community-test-8.3.0-1.el8.x86_64.rpm
mysql-community-test-debuginfo-8.3.0-1.el8.x86_64.rpm

[root@MiWiFi-RA80-srv data]#  rpm -ivh   mysql-community-client-plugins-8.3.0-1.el8.x86_64.rpm \
>  mysql-community-client-8.3.0-1.el8.x86_64.rpm \
>  mysql-community-common-8.3.0-1.el8.x86_64.rpm \
>  mysql-community-libs-8.3.0-1.el8.x86_64.rpm \
>  mysql-community-icu-data-files-8.3.0-1.el8.x86_64.rpm \
>  mysql-community-server-8.3.0-1.el8.x86_64.rpm 
warning: mysql-community-client-plugins-8.3.0-1.el8.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID a8d3785c: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-common-8.3.0-1.el################################# [ 17%]
   2:mysql-community-client-plugins-8.################################# [ 33%]
   3:mysql-community-libs-8.3.0-1.el8 ################################# [ 50%]
   4:mysql-community-client-8.3.0-1.el################################# [ 67%]
   5:mysql-community-icu-data-files-8.################################# [ 83%]
   6:mysql-community-server-8.3.0-1.el################################# [100%]
[/usr/lib/tmpfiles.d/subscription-manager.conf:1] Line references path below legacy directory /var/run/, updating /var/run/rhsm → /run/rhsm; please update the tmpfiles.d/ drop-in file accordingly.
[root@MiWiFi-RA80-srv data]# 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

初始化mysql

[root@MiWiFi-RA80-srv data]# systemctl start mysqld.service  (启动mysql)
[root@MiWiFi-RA80-srv data]# systemctl status mysqld.service  (查看mysql状态)
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Sat 2024-01-27 02:22:52 PST; 8s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 186308 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 186629 (mysqld)
   Status: "Server is operational"
    Tasks: 38 (limit: 11312)
   Memory: 442.7M
   CGroup: /system.slice/mysqld.service
           └─186629 /usr/sbin/mysqld

Jan 27 02:22:45 MiWiFi-RA80-srv systemd[1]: Starting MySQL Server...
Jan 27 02:22:52 MiWiFi-RA80-srv systemd[1]: Started MySQL Server.
[root@MiWiFi-RA80-srv data]# grep 'temporary password' /var/log/mysqld.log     （获取mysql初始密码）
2024-01-27T10:22:50.099056Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: >1Q>>sbqMS0j
[root@MiWiFi-RA80-srv data]# mysql -u root -p  （初始进入mysql）
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.3.0

Copyright (c) 2000, 2024, 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> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Lwh!12345';
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE USER 'school'@'*' IDENTIFIED BY 'Lwh!12345';
Query OK, 0 rows affected (0.01 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> SELECT host, user FROM user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| *         | school           |
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+
5 rows in set (0.00 sec)

mysql> UPDATE user SET host = '%' WHERE user = 'root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> SELECT host, user FROM user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | root             |
| *         | school           |
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
+-----------+------------------+
5 rows in set (0.00 sec)

mysql> UPDATE user SET host = '%' WHERE user = 'school';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> SELECT host, user FROM user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | root             |
| %         | school           |
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
+-----------+------------------+
5 rows in set (0.00 sec)

mysql> quit
Bye
[root@MiWiFi-RA80-srv data]# 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93