openSUSE ; Install Mysql & WordPress

# 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.27-1.sl15
Arch : x86_64
Vendor : Oracle and/or its affiliates
Installed Size : 2.83 GiB
Installed : Yes
Status : up-to-date
Source package : mysql-community-8.0.27-1.sl15.src
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
・・・・Abbreviation・・・
This package includes the MySQL server binary as well as related utilities
to run and administer a MySQL server.

# rpm -qi mysql-community-server
Name : mysql-community-server
Version : 8.0.27
Release : 1.sl15
Architecture: x86_64
Install Date: Fri Jan 7 22:45:00 2022
Group : Applications/Databases
Size : 3039099718
License : Copyright (c) 2000, 2021, Oracle and/or its affiliates. Under GPLv2 license as shown in the Description field.
Signature : DSA/SHA256, Wed Sep 29 16:36:37 2021, Key ID 8c718d3b5072e1f5
Source RPM : mysql-community-8.0.27-1.sl15.src.rpm
Build Date : Wed Sep 29 00:13:00 2021
Build Host : pb2-opensuse15-01.appad3iad.mysql2iad.oraclevcn.com
Relocations : (not relocatable)
Packager : MySQL Release Engineering <mysql-build@oss.oracle.com>
Vendor : Oracle and/or its affiliates
URL : http://www.mysql.com/
Summary : A very fast and reliable SQL database server
Description :
・・・・・Abbreviation・・・・
This package includes the MySQL server binary as well as related utilities
to run and administer a MySQL server.
Distribution: (none)

# mysql -u root -p
Enter password: ‘temporary password’
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 8.0.27
Copyright (c) 2000, 2021, 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> ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘Any new root password’;
Query OK, 0 rows affected (0.02 sec)
exit
Bye

Log in as the root user with the newly specified root password.
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 8.0.27

Copyright (c) 2000, 2021, 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> select version(); ←　Check mysql version
+———–+
| version() |
+———–+
| 8.0.27 |
+———–+
1 row in set (0.00 sec)

mysql> exit;
Bye

# mysql -u root -p
① Create a database
mysql> create database wp_db;
Query OK, 0 rows affected (0.14 sec)

➁Create user
mysql> create user ‘wp_user’@’localhost’ identified with mysql_native_password by ‘?WHxx333Yo’;
Query OK, 0 rows affected (0.14 sec)

➂Setting user rights
mysql> grant all on wp_db.* to wp_user@’localhost’ with grant option;
Query OK, 0 rows affected (0.14 sec)

④Settings reflect
mysql> flush privileges;
Query OK, 0 rows affected (0.22 sec)

mysql>exit
Bye

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

define(‘DB_NAME’, ‘wp_db‘);

define(‘DB_USER’, ‘wp_user‘);

define(‘DB_PASSWORD’, ‘?WHxx333Yo‘);

#Add the following to the last line.
#When you add a plugin, you will be asked for FTP connection information.
define(‘FS_METHOD’, ‘direct’);