目錄
前提步驟
刪除原有mysql及maridb數據庫
安裝MySQL
啟動MySQL
啟動查看MySQL狀態
設置MySQL開機自啟動
查看登錄密碼
登錄MySQL
修改密碼及支持遠程連接
遠程連接MySQL
前提步驟
擁有openEuler24.03 LTS環境，可參考：Vmware下安裝openEuler24.03 LTS
刪除原有mysql及maridb數據庫
如果原來有mysql或maridb數據庫，請先備份數據，再進行刪除操作。
$ sudo rpm -qa | grep -i 'mysql\|mariadb' | xargs -n1 sudo rpm -e --nodeps 2>/dev/null$ sudo rm -rf /var/lib/mysql* /var/log/mysql /usr/lib64/mysql /etc/my.cnf* /usr/my.cnf
操作過程如下
[liang@node1 ~]$ sudo rpm -qa | grep -i 'mysql\|mariadb' | xargs -n1 sudo rpm -e --nodeps 2>/dev/null
[liang@node1 ~]$ sudo rm -rf /var/lib/mysql* /var/log/mysql /usr/lib64/mysql /etc/my.cnf* /usr/my.cnf安裝MySQL
直接使用yum命令安裝mysql服務
$ sudo yum install -y mysql-server操作過程如下
[liang@node1 ~]$ sudo yum install -y mysql-server
OS 2.0 kB/s | 2.1 kB 00:01
everything 13 kB/s | 2.7 kB 00:00
EPOL 12 kB/s | 2.3 kB 00:00
debuginfo 10 kB/s | 2.2 kB 00:00
source 9.3 kB/s | 2.6 kB 00:00
update 8.0 kB/s | 2.2 kB 00:00
update-source 11 kB/s | 2.2 kB 00:00
Dependencies resolved.
====================================================================================Package Arch Version Repository Size
====================================================================================
Installing:mysql-server x86_64 8.0.42-1.oe2403sp1 update 32 M
Installing dependencies:abseil-cpp x86_64 20230802.1-6.oe2403sp1 update 508 kcheckpolicy x86_64 3.5-1.oe2403sp1 OS 293 kmecab x86_64 0.996-2.oe2403sp1 everything 375 kmysql x86_64 8.0.42-1.oe2403sp1 update 13 Mmysql-common x86_64 8.0.42-1.oe2403sp1 update 26 kmysql-config x86_64 8.0.42-1.oe2403sp1 update 6.5 kmysql-errmsg x86_64 8.0.42-1.oe2403sp1 update 574 kmysql-selinux noarch 1.0.10-1.oe2403sp1 everything 31 kpolicycoreutils-python-utils noarch 3.5-3.oe2403sp1 OS 22 kprotobuf-lite x86_64 25.1-7.oe2403sp1 OS 215 kpython3-IPy noarch 1.01-2.oe2403sp1 OS 44 kpython3-audit x86_64 1:3.1.2-7.oe2403sp1 OS 76 kpython3-libselinux x86_64 3.5-3.oe2403sp1 OS 174 kpython3-libsemanage x86_64 3.5-1.oe2403sp1 OS 71 kpython3-policycoreutils noarch 3.5-3.oe2403sp1 OS 2.2 Mpython3-setools x86_64 4.4.3-1.oe2403sp1 OS 657 kTransaction Summary
====================================================================================
Install 17 PackagesTotal download size: 51 M
Installed size: 263 M
Downloading Packages:
(1/17): policycoreutils-python-utils-3.5-3.oe2403sp 85 kB/s | 22 kB 00:00
(2/17): python3-IPy-1.01-2.oe2403sp1.noarch.rpm 382 kB/s | 44 kB 00:00
(3/17): checkpolicy-3.5-1.oe2403sp1.x86_64.rpm 715 kB/s | 293 kB 00:00
(4/17): protobuf-lite-25.1-7.oe2403sp1.x86_64.rpm 445 kB/s | 215 kB 00:00
(5/17): python3-libselinux-3.5-3.oe2403sp1.x86_64.r 2.0 MB/s | 174 kB 00:00
(6/17): python3-audit-3.1.2-7.oe2403sp1.x86_64.rpm 132 kB/s | 76 kB 00:00
(7/17): python3-libsemanage-3.5-1.oe2403sp1.x86_64. 102 kB/s | 71 kB 00:00
(8/17): mecab-0.996-2.oe2403sp1.x86_64.rpm 1.3 MB/s | 375 kB 00:00
(9/17): mysql-selinux-1.0.10-1.oe2403sp1.noarch.rpm 496 kB/s | 31 kB 00:00
(10/17): python3-policycoreutils-3.5-3.oe2403sp1.no 1.8 MB/s | 2.2 MB 00:01
(11/17): python3-setools-4.4.3-1.oe2403sp1.x86_64.r 765 kB/s | 657 kB 00:00
(12/17): mysql-common-8.0.42-1.oe2403sp1.x86_64.rpm 111 kB/s | 26 kB 00:00
(13/17): mysql-config-8.0.42-1.oe2403sp1.x86_64.rpm 120 kB/s | 6.5 kB 00:00
(14/17): abseil-cpp-20230802.1-6.oe2403sp1.x86_64.r 614 kB/s | 508 kB 00:00
(15/17): mysql-errmsg-8.0.42-1.oe2403sp1.x86_64.rpm 1.7 MB/s | 574 kB 00:00
(16/17): mysql-8.0.42-1.oe2403sp1.x86_64.rpm 963 kB/s | 13 MB 00:14
(17/17): mysql-server-8.0.42-1.oe2403sp1.x86_64.rpm 1.7 MB/s | 32 MB 00:19
------------------------------------------------------------------------------------
Total 2.3 MB/s | 51 MB 00:22
retrieving repo key for OS unencrypted from http://repo.openeuler.org/openEuler-24.03-LTS-SP1/OS/x86_64/RPM-GPG-KEY-openEuler
OS 4.9 kB/s | 3.0 kB 00:00
Importing GPG key 0xB675600B:Userid : "openeuler <openeuler@compass-ci.com>"Fingerprint: 8AA1 6BF9 F2CA 5244 010D CA96 3B47 7C60 B675 600BFrom : http://repo.openeuler.org/openEuler-24.03-LTS-SP1/OS/x86_64/RPM-GPG-KEY-openEuler
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transactionPreparing : 1/1Installing : python3-libselinux-3.5-3.oe2403sp1.x86_64 1/17Installing : mysql-config-8.0.42-1.oe2403sp1.x86_64 2/17Installing : mysql-common-8.0.42-1.oe2403sp1.x86_64 3/17Installing : abseil-cpp-20230802.1-6.oe2403sp1.x86_64 4/17Installing : protobuf-lite-25.1-7.oe2403sp1.x86_64 5/17Installing : mysql-8.0.42-1.oe2403sp1.x86_64 6/17Installing : mysql-errmsg-8.0.42-1.oe2403sp1.x86_64 7/17Installing : python3-libsemanage-3.5-1.oe2403sp1.x86_64 8/17Installing : python3-setools-4.4.3-1.oe2403sp1.x86_64 9/17Installing : mecab-0.996-2.oe2403sp1.x86_64 10/17Running scriptlet: mecab-0.996-2.oe2403sp1.x86_64 10/17Installing : python3-audit-1:3.1.2-7.oe2403sp1.x86_64 11/17Installing : python3-IPy-1.01-2.oe2403sp1.noarch 12/17Running scriptlet: checkpolicy-3.5-1.oe2403sp1.x86_64 13/17Installing : checkpolicy-3.5-1.oe2403sp1.x86_64 13/17Running scriptlet: checkpolicy-3.5-1.oe2403sp1.x86_64 13/17Installing : python3-policycoreutils-3.5-3.oe2403sp1.noarch 14/17Installing : policycoreutils-python-utils-3.5-3.oe2403sp1.noarch 15/17Running scriptlet: mysql-selinux-1.0.10-1.oe2403sp1.noarch 16/17Installing : mysql-selinux-1.0.10-1.oe2403sp1.noarch 16/17Running scriptlet: mysql-selinux-1.0.10-1.oe2403sp1.noarch 16/17
libsemanage.semanage_direct_install_info: Overriding mysql module at lower priority 100 with module at priority 200.Running scriptlet: mysql-server-8.0.42-1.oe2403sp1.x86_64 17/17Installing : mysql-server-8.0.42-1.oe2403sp1.x86_64 17/17Running scriptlet: mysql-server-8.0.42-1.oe2403sp1.x86_64 17/17Running scriptlet: mysql-selinux-1.0.10-1.oe2403sp1.noarch 17/17Running scriptlet: mysql-server-8.0.42-1.oe2403sp1.x86_64 17/17
/usr/lib/tmpfiles.d/dbus.conf:13: Line references path below legacy directory /var/run/, updating /var/run/dbus/containers → /run/dbus/containers; please update the tmpfiles.d/ drop-in file accordingly.Verifying : checkpolicy-3.5-1.oe2403sp1.x86_64 1/17Verifying : policycoreutils-python-utils-3.5-3.oe2403sp1.noarch 2/17Verifying : protobuf-lite-25.1-7.oe2403sp1.x86_64 3/17Verifying : python3-IPy-1.01-2.oe2403sp1.noarch 4/17Verifying : python3-audit-1:3.1.2-7.oe2403sp1.x86_64 5/17Verifying : python3-libselinux-3.5-3.oe2403sp1.x86_64 6/17Verifying : python3-libsemanage-3.5-1.oe2403sp1.x86_64 7/17Verifying : python3-policycoreutils-3.5-3.oe2403sp1.noarch 8/17Verifying : python3-setools-4.4.3-1.oe2403sp1.x86_64 9/17Verifying : mecab-0.996-2.oe2403sp1.x86_64 10/17Verifying : mysql-selinux-1.0.10-1.oe2403sp1.noarch 11/17Verifying : abseil-cpp-20230802.1-6.oe2403sp1.x86_64 12/17Verifying : mysql-8.0.42-1.oe2403sp1.x86_64 13/17Verifying : mysql-common-8.0.42-1.oe2403sp1.x86_64 14/17Verifying : mysql-config-8.0.42-1.oe2403sp1.x86_64 15/17Verifying : mysql-errmsg-8.0.42-1.oe2403sp1.x86_64 16/17Verifying : mysql-server-8.0.42-1.oe2403sp1.x86_64 17/17Installed:abseil-cpp-20230802.1-6.oe2403sp1.x86_64checkpolicy-3.5-1.oe2403sp1.x86_64mecab-0.996-2.oe2403sp1.x86_64mysql-8.0.42-1.oe2403sp1.x86_64mysql-common-8.0.42-1.oe2403sp1.x86_64mysql-config-8.0.42-1.oe2403sp1.x86_64mysql-errmsg-8.0.42-1.oe2403sp1.x86_64mysql-selinux-1.0.10-1.oe2403sp1.noarchmysql-server-8.0.42-1.oe2403sp1.x86_64policycoreutils-python-utils-3.5-3.oe2403sp1.noarchprotobuf-lite-25.1-7.oe2403sp1.x86_64python3-IPy-1.01-2.oe2403sp1.noarchpython3-audit-1:3.1.2-7.oe2403sp1.x86_64python3-libselinux-3.5-3.oe2403sp1.x86_64python3-libsemanage-3.5-1.oe2403sp1.x86_64python3-policycoreutils-3.5-3.oe2403sp1.noarchpython3-setools-4.4.3-1.oe2403sp1.x86_64Complete!啟動MySQL
$ sudo systemctl start mysqld啟動查看MySQL狀態
[liang@node1 ~]$ sudo systemctl status mysqld
● mysqld.service - MySQL 8.0 database serverLoaded: loaded (/usr/lib/systemd/system/mysqld.service; disabled; preset: disa>Active: active (running) since Wed 2025-05-07 22:59:59 CST; 3min 7s agoProcess: 2811 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status>Process: 2834 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mysqld.service (co>Main PID: 2912 (mysqld)Status: "Server is operational"Tasks: 37 (limit: 21353)Memory: 473.3M ()CGroup: /system.slice/mysqld.service└─2912 /usr/libexec/mysqld --basedir=/usr5月 07 22:59:54 node1 systemd[1]: Starting MySQL 8.0 database server...
5月 07 22:59:55 node1 mysql-prepare-db-dir[2834]: Initializing MySQL database
5月 07 22:59:59 node1 systemd[1]: Started MySQL 8.0 database server.
lines 1-15/15 (END)看到Active: active (running)，說明mysql服務正常啟動。
按q鍵返回命令行。
設置MySQL開機自啟動
[liang@node1 ~]$ sudo systemctl enable mysqld
Created symlink /etc/systemd/system/multi-user.target.wants/mysqld.service → /usr/lib/systemd/system/mysqld.service.查看登錄密碼
[liang@node1 ~]$ sudo cat /var/log/mysql/mysqld.log
2025-05-07T14:59:55.041414Z 0 [System] [MY-013169] [Server] /usr/libexec/mysqld (mysqld 8.0.42) initializing of server in progress as process 2869
2025-05-07T14:59:55.046791Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-05-07T14:59:55.301970Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-05-07T14:59:55.986953Z 6 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2025-05-07T14:59:58.680076Z 0 [System] [MY-010116] [Server] /usr/libexec/mysqld (mysqld 8.0.42) starting as process 2912
2025-05-07T14:59:58.689207Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-05-07T14:59:59.073809Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-05-07T14:59:59.317924Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-05-07T14:59:59.317946Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-05-07T14:59:59.340722Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
2025-05-07T14:59:59.340759Z 0 [System] [MY-010931] [Server] /usr/libexec/mysqld: ready for connections. Version: '8.0.42' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution.輸出看到[Server] root@localhost is created with an empty password !，說明初始密碼為空。
登錄MySQL
$ mysql -uroot -p提示輸入密碼，因為是空密碼，不需要輸入任何信息直接回車，進入mysql命令行。
操作過程如下
[liang@node1 ~]$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.42 Source distributionCopyright (c) 2000, 2025, 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>測試使用MySQL命令
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)mysql> quit;
Bye
[liang@node1 ~]$修改密碼及支持遠程連接
mysql> set password='000000';
mysql> update mysql.user set host='%' where user='root';
mysql> flush privileges;操作過程如下
[liang@node1 ~]$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.42 Source distributionCopyright (c) 2000, 2025, 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> set password='000000';
Query OK, 0 rows affected (0.01 sec)mysql> update mysql.user set host='%' where user='root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)mysql> quit;
Bye
[liang@node1 ~]$使用新密碼登錄
[liang@node1 ~]$ mysql -uroot -p000000
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 10
Server version: 8.0.42 Source distributionCopyright (c) 2000, 2025, 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>遠程連接MySQL
使用navicat等工具遠程連接mysql
完成！enjoy it！
)
--多點觸控)
)
