Click here for "Safe Air Conditioner Repair and Proper Freon Recovery".(Japanese Version)

Ubuntu22.04 Server : MySQL 8 , WordPress

1. MySQL 8 Install

1. 1Install

1.2. MySQL Server Security Settings

Run the tool mysql_secure_installation to configure security-related settings for the MySQL server.
Once executed, several security settings are initiated in the form of questions.
First, you will be asked if you want to use a plugin for password validation as follows. Password validation is a way to check the strength of a user's password for MySQL and restrict it to only accepting passwords that are secure enough. For example, it must be at least as many characters long as the user's password and must contain at least one symbol and one number. You can set this requirement by asking the following questions
Type y and press Enter if you like

"Failed! Error: SET PASSWORD has no significance for user ‘root’@’localhost’ as the authentication method used doesn’t store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters."

If you get the above error, change the authentication parameters by executing this ALTER query as follows

Installation Status

Finally, the security settings are complete when the message "All done!

From then on, when accessing MySQL, you must use the

2.WordPress Install

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")
If you receive a message "Your password does not satisfy the current policy requirements" when creating an account, please make sure your password is at least 8 characters long and includes upper and lower case letters, numbers, symbols, etc.

2.2 WordPress Download and Install

①Download and Deployment

②Edit WordPress configuration file

Edit contents of wp-config.php

③Moving Files

After confirming that the files have been moved, delete the wordpress directory and downloaded latest-ja.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 server’s PHP does not seem to be able to use the MySQL extension required by WordPress.” If you get the message

If you have php and mysql installed on your Ubuntu server, but when you install WordPress you get the message “Your server’s PHP does not seem to be able to use the MySQL extension required by WordPress.” Please check the following.
Make sure you have the library installed、
Install the php library if you haven’t already done so.

Installing the MYSQL module
WordPress requires the MYSQL module in PHP.
Install the PHP MYSQL module if you haven’t already done so.

After the installation is complete, restart Apache.

On the input screen below

  • Site Title :  Any name
  • Username :    Any name
  • Password : Any Password
  • Your Email : Admin E-mail Address

Click on "Install WordPress". Remember to enter your "username" and "password" as they are required to access the WordPress administration screen.

Copied title and URL