这里写自定义目录标题
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]#
因为系统版本是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]#
初始化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]#