MySQL單實例安裝--CentOS(Yum安裝)

1. 安裝MySQL存儲庫

yum -y install wget

wget https://dev.mysql.com/get/mysql80-community-release-el7-7.noarch.rpm

yum install mysql80-community-release-el7-7.noarch.rpm -y

其他不同版本的存儲庫查看官網：https://dev.mysql.com/downloads/repo/yum/

2.安裝MySQL服務端

yum install mysql-community-server

3.啟動MySQL

systemctl start mysqld

4.設置MySQL開機自啟動

systemctl enable mysqld

5.查看MySQL狀態

systemctl status mysqld

如果安裝啟動正常的話，可以看到類似下面的內容：

[root@VM-4-148-centos ~]# systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2023-09-21 13:55:37 CST; 1min 10s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
 Main PID: 2501 (mysqld)
   Status: "Server is operational"
   CGroup: /system.slice/mysqld.service
           └─2501 /usr/sbin/mysqld

6.查看root用戶的初始密碼

grep 'password' /var/log/mysqld.log

7.嘗試登錄，-p后面是上一步獲取到的密碼

mysql -uroot -p'hqOQPScus0,E'

一切正常的話，可以看到如下輸出：

[root@VM-4-148-centos ~]# mysql -uroot -p'hqOQPScus0,E'
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 8
Server version: 8.0.34

Copyright (c) 2000, 2023, 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> 

8.修改root用戶密碼

最后，您可以通過下面的命令重新設置root用戶密碼

alter user 'root'@'localhost' identified by '新密碼';