openEuler-23.0.9安装MySQL

1.先从官网地址下载MySQL包

MySQL :: Download MySQL Community Server (Archived Versions)

2.下载完成之后上传到Linux客户端

C:\Users\lenovo\Desktop>scp ./mysql-9.0.1-1.el9.x86_64.rpm-bundle.tar root@192.168.40.145:/mysql/

此时发现已经在mysql文件夹里面多了一个tar文件

我们解压它

yum install tar -y &> /dev/null#安装解压工具

tar -xvf mysql-9.0.1-1.el9.x86_64.rpm-bundle.tar -C /mysql/

然后安装  yum install mysql-community* -y

[root@localhost mysql]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service

[root@localhost mysql]# systemctl start mysqld.service
[root@localhost mysql]# systemctl status mysqld.service
● mysqld.service - MySQL Server
     Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; preset: disab>     Active: active (running) since Sat 2024-10-19 22:24:43 CST; 1min 17s ago
       Docs: man:mysqld(8)
             http://dev.mysql.com/doc/refman/en/using-systemd.html
    Process: 8567 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/S>   Main PID: 8633 (mysqld)
     Status: "Server is operational"
      Tasks: 34 (limit: 8821)
     Memory: 496.2M
     CGroup: /system.slice/mysqld.service
             └─8633 /usr/sbin/mysqld

10月 19 22:24:36 localhost.localdomain systemd[1]: Starting MySQL Server...
10月 19 22:24:43 localhost.localdomain systemd[1]: Started MySQL Server.

 输入service mysqld start进行启动mysql，发现重定向至systemctl，所以使用systemctl start mysqld.service启动MySQL

可以使用systemctl status mysqld.service查看是否启动成功，发现enable则表示成功启动

systemctl enable mysqld.service设置成为开机启动

查看root密码

[root@localhost mysql]# sed -n '/root/p' /var/log/mysqld.log | awk '{print $NF}'

vKXylg38#/4o

然后修改密码

[root@localhost mysql]# mysqladmin -uroot -pvKXylg38#/4o password @OPENlab123

#注意上面修改代码要求密码比较复杂，不然很可能修改不能成功

 查看对应的监听tcp端口

[root@localhost mysql]# netstat -lntp | grep mysqld
tcp6       0      0 :::33060                :::*                    LISTEN      8633/mysqld
tcp6       0      0 :::3306                 :::*                    LISTEN      8633/mysqld

 然后防火墙放行上面端口

[root@localhost mysql]# firewall-cmd --permanent --zone=public --add-port=3306/tcp && firewall-cmd --permanent --zone=public --add-port=33060/tcp && firewall-cmd --reload 

以上就安装好啦