Contents
1. Install Mysql8
First, make sure the server is up to date.
# zypper ref
# zypper up -y
1.1 Mysql8 install
Download the RPM repository
Make sure you have the required version of mysql.
# 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)
⑤Start and enable the mysql service
Make the service start on reboot.
# systemctl enable mysql
Check the status of the service and make sure it is actually running.
# systemctl status mysql
● mysql.service – MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysql.service; enabled; vendor pre>
Active: active (running) since Sat 2022-01-08 08:21:14 JST; 1h 11min ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 1412 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status>
Main PID: 1484 (mysqld)
Status: “Server is operational”
Tasks: 37 (limit: 2308)
CGroup: /system.slice/mysql.service
mq1484 /usr/sbin/mysqld
Jan 08 08:21:07 Lepard systemd[1]: Starting MySQL Server…
Jan 08 08:21:14 Lepard systemd[1]: Started MySQL Server.
Use the journalctl command
# tail -f /var/log/mysql/mysqld.log
Check the ‘temporary password’ after installation and make a note of it.
2022-01-07T13:59:50.849820Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 8LvNl4sjV9=1
# 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
⑧Check mysql version
mysql Ver 8.0.27 for Linux on x86_64 (MySQL Community Server – GPL)
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
1.2 Example of creating Mysql8 database and user
database : wp_db
user : wp_user
password : ?WHxx333Yo
# 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
2. Install WordPress
2.1 Install required libraries
2.2 Download and install WordPress
# wget http://ja.wordpress.org/latest-ja.tar.gz
# tar zxvf latest-ja.tar.gz
2.3 Edit the configuration file
# 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’);
Move the extracted contents under /srv/www/htdocs/[web directory]
# mv wordpress/* .
# rm -Rf wordpress
# rm latest-ja.tar.gz
# chmod 775 -R /srv/www/htdocs/[web directory]
2.4 startup confirmation
Normally, this will bring up the initial installation screen, including the “User Name” and “Password” to access the WordPress administration screen as shown below.
Site Title : Any title
Username : Any Name
Password : Any password
Your Email : Administrator’s email address
Click “Install WordPress.

define( ‘WP_DEBUG’, true ); change it to true and check the part of the message that is displayed.
In most cases, this is due to a misconfiguration, but in some cases you may need to change the following
In wp-config.php, on line 38, where the hostname is setdefine( ‘DB_HOST’, ‘localhost’);
First, find out where mysql.sock is installed.
In this case, the file is installed in /var/lib/mysql/mysql.sock, so change it as followsdefine( ‘DB_HOST’, ‘localhost:/var/lib/mysql/mysql.sock’);