MySQL包安装 -- SUSE系列（SUSE资源库安装MySQL）

2.2.3 SUSE系列

2.2.3.1 SUSE资源库安装MySQL

2.2.3.1.1 MySQL 8.0

在"openSUSE"上安装MySQL：

opensuse15:~ # wget https://repo.mysql.com//mysql80-community-release-sl15-1.noarch.rpm

opensuse15:~ # rpm --import https://mirrors.nju.edu.cn/mysql/RPM-GPG-KEY-mysql-2023

opensuse15:~ # rpm -Uvh mysql80-community-release-sl15-1.noarch.rpm 

# 替换国内镜像源
sed -i.bak 's|http://repo.mysql.com|https://mirrors.nju.edu.cn/mysql|g' /etc/zypp/repos.d/mysql-community*.repo

opensuse15:~ # zypper refresh

opensuse15:~ # zypper search "mysql-community-server"
Loading repository data...
Reading installed packages...

S | Name                         | Summary                                      | Type
--+------------------------------+----------------------------------------------+--------
  | mysql-community-server       | A very fast and reliable SQL database server | package
  | mysql-community-server-debug | The debug version of MySQL server            | package

opensuse15:~ # zypper info "mysql-community-server"
Loading repository data...
Reading installed packages...


Information for package mysql-community-server:
-----------------------------------------------
Repository     : MySQL 8.0 Community Server
Name           : mysql-community-server
Version        : 8.0.43-1.sl15
Arch           : x86_64
Vendor         : Oracle and/or its affiliates
Installed Size : 401.4 MiB
Installed      : No
Status         : not installed
Source package : mysql-community-8.0.43-1.sl15.src
Upstream URL   : http://www.mysql.com/
Summary        : A very fast and reliable SQL database server
Description    : 
    The MySQL(TM) software delivers a very fast, multi-threaded, multi-user,
    and robust SQL (Structured Query Language) database server. MySQL Server
    is intended for mission-critical, heavy-load production systems as well
    as for embedding into mass-deployed software. MySQL is a trademark of
    Oracle and/or its affiliates

    The MySQL software has Dual Licensing, which means you can use the MySQL
    software free of charge under the GNU General Public License
    (http://www.gnu.org/licenses/). You can also purchase commercial MySQL
    licenses from Oracle and/or its affiliates if you do not wish to be bound by the terms of
    the GPL. See the chapter "Licensing and Support" in the manual for
    further info.

    The MySQL web site (http://www.mysql.com/) provides the latest news and
    information about the MySQL software.  Also please see the documentation
    and the manual for more information.

    This package includes the MySQL server binary as well as related utilities
    to run and administer a MySQL server.

opensuse15:~ # zypper install -y mysql-community-server

opensuse15:~ # systemctl enable --now mysql

opensuse15:~ # ls /var/lib/mysql
#ib_16384_0.dblwr  auto.cnf       ca.pem           ibdata1    mysql.sock          public_key.pem   undo_001
#ib_16384_1.dblwr  binlog.000001  client-cert.pem  ibtmp1     mysql.sock.lock     server-cert.pem  undo_002
#innodb_redo       binlog.index   client-key.pem   mysql      performance_schema  server-key.pem
#innodb_temp       ca-key.pem     ib_buffer_pool   mysql.ibd  private_key.pem     sys

opensuse15:~ # mysql -V
mysql  Ver 8.0.43 for Linux on x86_64 (MySQL Community Server - GPL)

opensuse15:~ # systemctl status mysql
● mysql.service - MySQL Server
     Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled; preset: disabled)
     Active: active (running) since Fri 2025-10-03 14:52:18 CST; 34s ago
       Docs: man:mysqld(8)
             http://dev.mysql.com/doc/refman/en/using-systemd.html
    Process: 13723 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
   Main PID: 13787 (mysqld)
     Status: "Server is operational"
      Tasks: 38 (limit: 2250)
        CPU: 5.712s
     CGroup: /system.slice/mysql.service
             └─13787 /usr/sbin/mysqld

Oct 03 14:52:10 opensuse15 systemd[1]: Starting MySQL Server...
Oct 03 14:52:17 opensuse15 (mysqld)[13787]: mysql.service: Referenced but unset environment variable evaluates t>
Oct 03 14:52:18 opensuse15 systemd[1]: Started MySQL Server.

# 获取MySQL初始密码
opensuse15:~ # grep 'temporary password' /var/log/mysql/mysqld.log
2025-10-03T06:52:13.198731Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: y;_44nus=q8U
# "y;_44nus=q8U"就是MySQL的初始密码

# 修改mysql密码
opensuse15:~ # mysqladmin -uroot -p'y;_44nus=q8U' password 123456
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
mysqladmin: unable to change password; error: 'Your password does not satisfy the current policy requirements'
# 上面报错提示密码太简单

opensuse15:~ # mysqladmin -uroot -p'y;_44nus=q8U' password Raymond@2025
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety

opensuse15:~ # mysql -uroot -p'Raymond@2025'
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 9
Server version: 8.0.43 MySQL Community Server - GPL

Copyright (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> status
--------------
mysql  Ver 8.0.43 for Linux on x86_64 (MySQL Community Server - GPL)

Connection id:		9
Current database:	
Current user:		root@localhost
SSL:			Not in use
Current pager:		less
Using outfile:		''
Using delimiter:	;
Server version:		8.0.43 MySQL Community Server - GPL
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	utf8mb4
Db     characterset:	utf8mb4
Client characterset:	utf8mb4
Conn.  characterset:	utf8mb4
UNIX socket:		/var/lib/mysql/mysql.sock
Binary data as:		Hexadecimal
Uptime:			1 min 49 sec

Threads: 2  Questions: 8  Slow queries: 0  Opens: 130  Flush tables: 3  Open tables: 46  Queries per second avg: 0.073
--------------

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> exit
Bye

2.2.3.1.2 MySQL 8.4

在"openSUSE"上安装MySQL：

去“https://www.mysql.com/”网站下载，选择“DOWNLOADS”，如图62所示。

图62 下载SUSE仓库包

选择“MySQL Community (GPL) Downloads”，如图63所示。

图63 下载SUSE仓库包

选择“MySQL SUSE Repository（MySQL SUSE资源库）”，如图64所示。

图64 下载SUSE仓库包

然后根据系统版本下载相应的安装包，如图65所示。

图65 下载SUSE仓库包

opensuse15:~ # wget https://dev.mysql.com/get/mysql84-community-release-sl15-1.noarch.rpm

opensuse15:~ # rpm --import https://mirrors.nju.edu.cn/mysql/RPM-GPG-KEY-mysql-2023

opensuse15:~ # rpm -Uvh mysql84-community-release-sl15-1.noarch.rpm

# 替换国内镜像源
sed -i.bak 's|http://repo.mysql.com|https://mirrors.nju.edu.cn/mysql|g' /etc/zypp/repos.d/mysql-community*.repo

opensuse15:~ # zypper update -y mysql84-community-release

opensuse15:~ # zypper refresh

opensuse15:~ # zypper search "mysql-community-server"
Loading repository data...
Reading installed packages...

S | Name                         | Summary                                      | Type
--+------------------------------+----------------------------------------------+--------
  | mysql-community-server       | A very fast and reliable SQL database server | package
  | mysql-community-server-debug | The debug version of MySQL server            | package

opensuse15:~ # zypper info mysql-community-server
Loading repository data...
Reading installed packages...


Information for package mysql-community-server:
-----------------------------------------------
Repository     : MySQL 8.4 LTS Community Server
Name           : mysql-community-server
Version        : 8.4.6-1.sl15
Arch           : x86_64
Vendor         : Oracle and/or its affiliates
Installed Size : 380.0 MiB
Installed      : No
Status         : not installed
Source package : mysql-community-8.4.6-1.sl15.src
Upstream URL   : http://www.mysql.com/
Summary        : A very fast and reliable SQL database server
Description    : 
    The MySQL(TM) software delivers a very fast, multi-threaded, multi-user,
    and robust SQL (Structured Query Language) database server. MySQL Server
    is intended for mission-critical, heavy-load production systems as well
    as for embedding into mass-deployed software. MySQL is a trademark of
    Oracle and/or its affiliates

    The MySQL software has Dual Licensing, which means you can use the MySQL
    software free of charge under the GNU General Public License
    (http://www.gnu.org/licenses/). You can also purchase commercial MySQL
    licenses from Oracle and/or its affiliates if you do not wish to be bound by the terms of
    the GPL. See the chapter "Licensing and Support" in the manual for
    further info.

    The MySQL web site (http://www.mysql.com/) provides the latest news and
    information about the MySQL software.  Also please see the documentation
    and the manual for more information.

    This package includes the MySQL server binary as well as related utilities
    to run and administer a MySQL server.

opensuse15:~ # zypper install -y mysql-community-server

opensuse15:~ # systemctl enable --now mysql

opensuse15:~ # ls /var/lib/mysql
#ib_16384_0.dblwr  auto.cnf       ca.pem           ibdata1    mysql.sock             private_key.pem  sys
#ib_16384_1.dblwr  binlog.000001  client-cert.pem  ibtmp1     mysql.sock.lock        public_key.pem   undo_001
#innodb_redo       binlog.index   client-key.pem   mysql      mysql_upgrade_history  server-cert.pem  undo_002
#innodb_temp       ca-key.pem     ib_buffer_pool   mysql.ibd  performance_schema     server-key.pem

opensuse15:~ # mysql -V
mysql  Ver 8.4.6 for Linux on x86_64 (MySQL Community Server - GPL)

opensuse15:~ # systemctl status mysql
● mysql.service - MySQL Server
     Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled; preset: disabled)
     Active: active (running) since Fri 2025-10-03 16:08:08 CST; 29s ago
       Docs: man:mysqld(8)
             http://dev.mysql.com/doc/refman/en/using-systemd.html
    Process: 13988 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
   Main PID: 14050 (mysqld)
     Status: "Server is operational"
      Tasks: 35 (limit: 2250)
        CPU: 4.965s
     CGroup: /system.slice/mysql.service
             └─14050 /usr/sbin/mysqld

Oct 03 16:08:01 opensuse15 systemd[1]: Starting MySQL Server...
Oct 03 16:08:06 opensuse15 (mysqld)[14050]: mysql.service: Referenced but unset environment variable evaluates t>
Oct 03 16:08:08 opensuse15 systemd[1]: Started MySQL Server.

# 获取MySQL初始密码
opensuse15:~ # grep 'temporary password' /var/log/mysql/mysqld.log
2025-10-03T08:08:04.005002Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: a/i1hpY;b8s#
# "a/i1hpY;b8s#"就是MySQL的初始密码

# 修改mysql密码
opensuse15:~ #  mysqladmin -uroot -p'a/i1hpY;b8s#' password 123456
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
mysqladmin: unable to change password; error: 'Your password does not satisfy the current policy requirements'
# 上面报错提示密码太简单

opensuse15:~ # mysqladmin -uroot -p'a/i1hpY;b8s#' password Raymond@2025
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety

opensuse15:~ # mysql -uroot -p'Raymond@2025'
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 9
Server version: 8.4.6 MySQL Community Server - GPL

Copyright (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> status
--------------
mysql  Ver 8.4.6 for Linux on x86_64 (MySQL Community Server - GPL)

Connection id:		9
Current database:	
Current user:		root@localhost
SSL:			Not in use
Current pager:		less
Using outfile:		''
Using delimiter:	;
Server version:		8.4.6 MySQL Community Server - GPL
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	utf8mb4
Db     characterset:	utf8mb4
Client characterset:	utf8mb4
Conn.  characterset:	utf8mb4
UNIX socket:		/var/lib/mysql/mysql.sock
Binary data as:		Hexadecimal
Uptime:			1 min 35 sec

Threads: 2  Questions: 9  Slow queries: 0  Opens: 130  Flush tables: 3  Open tables: 46  Queries per second avg: 0.094
--------------

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> exit
Bye