Debian12.5 ; MariaDB , WordPress Install

1. MariaDB

1.1 Install

MariaDB version confirmation

1.2 MariaDB Server Security Settings

MariaDB comes with a default security script, mariadb-secure-installation, which can be used to improve the security of your MariaDB installation, including

Set a password for the root account (if necessary).
Disable remote root login to the database.
Delete anonymous user accounts.
Delete the test database to which anonymous users have access by default.

Installation Status


After that, use the following commands when accessing MariaDB

1.3 phpMyAdmin

Installed phpMyAdmin and configured it to operate MariaDB via web browser
①Install

Select a web server to use phpMyAdmin, this time Apache2

MariaDB password

Confirm password again

apache.conf edit

Apache restart

②Access http:///phpmyadmin in your browser
The following login screen will appear
Username : root
Password:   Password for the root user set in the MariaDB security installation
Log in click

The following phpMyAdmin settings screen appears

2.WordPress

2.1 Database Creation

Create a database for Word Press (for example, in this case, the database name is "wp_db", the user name is "wp_user", and the password is "?Y123456y")

2.2 WordPress Download and Installation

Download and Deployment

Edit WordPress configuration file

Edit contents of wp-config.php

After confirming that the files have been moved, delete the wordpress directory and the downloaded latest.tar.gz

Make apache the owner of the wordpress directory

Access from a browser
Access http://<FQDN>/wp-admin.
If successful, the following WordPress installation information input screen will be output.

「Your PHP installation appears to be missing the MySQL extension which is required by WordPress.」When displayed

Install php library-related software if not already installed

Restart Apache after installation is complete.

again
Access http://<FQDN>/wp-admin.

On the following input screen

  • Site Title   Any name
  • Username   Any name
  • Password  Any password
  • Your Email  Administrator's email address

Enter the information and click "Install WordPress". Remember to enter your "username" and "password" as they are required to access the WordPress administration screen.

Copied title and URL