openSUSE Tumbleweed :　MariaDB , WordPressインストール

# zypper ref
# zypper up -y

# zypper -n install mariadb

# vi /etc/my.cnf

12行目　追記
[mysqld]
character-set-server=utf8

# rpm -qi mariadb

Name        : mariadb
Version     : 12.3.2
Release     : 1.1
Architecture: x86_64
Install Date: Wed 24 Jun 2026 10:25:08 AM JST
Group       : Productivity/Databases/Servers
Size        : 141560723
License     : SUSE-GPL-2.0-with-FLOSS-exception
Signature   : RSA/SHA512, Sat 13 Jun 2026 04:09:42 AM JST, Key ID 35a2f86e29b700a4
Source RPM  : mariadb-12.3.2-1.1.src.rpm
Build Date  : Thu 11 Jun 2026 02:26:23 AM JST
Build Host  : reproducible
Packager    : https://bugs.opensuse.org
Vendor      : openSUSE
URL         : https://www.mariadb.org
Summary     : Server part of MariaDB
Description :
MariaDB is an open-source, multi-threaded, relational database management
system. It's a backward compatible, drop-in replacement branch of the
MySQL Community Server.

This package only contains the server-side programs.
Distribution: openSUSE Tumbleweed

# systemctl start mariadb
# systemctl enable mariadb
Created symlink '/etc/systemd/system/mysql.service' → '/usr/lib/systemd/system/mariadb.service'.
Created symlink '/etc/systemd/system/multi-user.target.wants/mariadb.service' → '/usr/lib/systemd/system/mariadb.service'.

# systemctl status mariadb

● mariadb.service - MariaDB database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
     Active: active (running) since Wed 2026-06-24 10:27:12 JST; 1min 44s ago
 Invocation: 2c74c5c72dfb40569cad9910f46a4aa7
       Docs: man:mysqld(8)
             https://mariadb.com/kb/en/library/systemd/
   Main PID: 5044 (mysqld)
     Status: "Taking your SQL requests now..."
      Tasks: 10 (limit: 4541)
        CPU: 2.052s
     CGroup: /system.slice/mariadb.service
             mq5044 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --user=mysql --socket=/run/mysql/mysql.sock

Jun 24 10:27:11 Lepard mysql-systemd-helper[4439]: you need to be the system 'mysql' user to connect.
Jun 24 10:27:11 Lepard mysql-systemd-helper[4439]: After connecting you can set the password, if you would need to be
Jun 24 10:27:11 Lepard mysql-systemd-helper[4439]: able to connect as any of these users with a password and without sudo
Jun 24 10:27:11 Lepard mysql-systemd-helper[4439]: See the MariaDB Knowledgebase at https://mariadb.com/kb
Jun 24 10:27:11 Lepard mysql-systemd-helper[4439]: Please report any problems at https://mariadb.org/jira
Jun 24 10:27:11 Lepard mysql-systemd-helper[4439]: The latest information about MariaDB is available at https://mariadb.org/.
Jun 24 10:27:11 Lepard mysql-systemd-helper[4439]: Consider joining MariaDB's strong and vibrant community:
Jun 24 10:27:11 Lepard mysql-systemd-helper[4439]: https://mariadb.org/get-involved/
Jun 24 10:27:11 Lepard mysql-systemd-helper[5044]: /usr/sbin/mysqld: Deprecated program name. It will be removed in a future release, use '/usr/sbin/mariadbd>
Jun 24 10:27:12 Lepard systemd[1]: Started MariaDB database server.

# mysql_secure_installation

/usr/bin/mysql_secure_installation: Deprecated program name. It will be removed in a future release, use 'mariadb-secure-installation' instead

NOTE: MariaDB is secure by default. Running this script is mostly
      unecessary and it will likely be removed in a future release,
      but it is for now preserved for backwards compatibility.

Enter root user password or leave blank:

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password or using the unix_socket ensures that nobody
can log into the MariaDB root user without the proper authorisation.

You already have your root account protected, so you can safely answer 'n'.

Switch to unix_socket authentication [Y/n] y
Enabled successfully (or at least no errors was emitted)!
Reloading privilege tables..
 ... Success!


You already have your root account protected, so you can safely answer 'n'.

Change the root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y
Query OK, 2 rows affected
SQL executed without errors!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] y
Query OK, 0 rows affected
SQL executed without errors!

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y
 - Dropping test database...
Query OK, 0 rows affected
SQL executed without errors!
 - Removing privileges on test database...
Query OK, 2 rows affected
SQL executed without errors!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!

# mariadb -V
mariadb from 12.3.2-MariaDB, client 15.2 for Linux (x86_64) using  EditLine wrapper

# firewall-cmd --add-service=mysql --permanent
success
# firewall-cmd --reload
success

# zypper -n install phpMyAdmin

# systemctl restart apache2

# mariadb -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 37
Server version: 12.3.2-MariaDB MariaDB package

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database wp_db;
Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> create user 'wp_user'@'localhost' identified by '?WHxx333Yo';
Query OK, 0 rows affected (0.002 sec)

MariaDB [(none)]> grant all on wp_db.* to 'wp_user'@'localhost';
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.000 sec)

MariaDB [(none)]> exit;
Bye

# zypper install -n php8-gd php8-pdo php8-mysql php8-mbstring php8-curl apache2-mod_php8

# cd /srv/www/htdocs/[FQDN]
# wget http://wordpress.org/latest.tar.gz
# tar zxvf latest.tar.gz

# cd /srv/www/htdocs/[FQDN]/wordpress/
# cp wp-config-sample.php wp-config.php

# vi wp-config.php

23行目 :
define( 'DB_NAME', 'wp_db' ); [データベース名]

26行目 :
define( 'DB_USER', 'wp_user' ); [ユーザー名]

29行目 :
define( 'DB_PASSWORD', '?WHxx333Yo' ); [パスワード]

/** Database hostname */

また、最終行に以下の分を追加します。 これをしないと、プラグインを追加するときにFTP接続情報なるものを聞かれます。
define('FS_METHOD', 'direct');

# cd /srv/www/htdocs/[FQDN]
# mv wordpress/* .

# cd /srv/www/htdocs/[FQDN]
# rm -Rf wordpress
# rm -f latest.tar.gz

# chown -R wwwrun:wwwrun /srv/www/htdocs/[FQDN]
# chmod 775 -R /srv/www/htdocs/[FQDN]

# systemctl restart apache2