Click here for "Error Codes for Commercial Air Conditioners".

Debian10; Installing MySQL and WordPress

1.Installing MySQL

1.1 Download and install the MySQL package

The MySQL team provides the official MySQL PPA for Debian Linux. When you download and install the package on your Debian system, the PPA file will be added to your system. To enable the PPA, run the following command

In this case, we will select MySQL 5.7 and install it on our Debian system. If you have selected a specific version and need to change the configuration, use the following command

During the installation of the MySQL apt config package, you will be asked to select the MySQL version to install. Select the MySQL 8.0 or 5.7 option and install it on your system

1.2 Installing MySQL on Debian 10

During the installation process, you will be prompted to enter the root password that you want to set as default. Enter a secure password and confirm the same password window. This will be the MySQL root user password required to login to the MySQL server.

You will be asked to re-enter the same password in the next window.

Configure security settings for MySQL server.
There is a tool called mysql_secure_installtion that can be used to configure security-related settings for the MySQL server.
When you run it, it will ask you a series of questions to configure some security settings. First, you will be asked if you want to use the password validation plugin as shown below. Password validation means that you can check the password strength of users for MySQL and restrict them to accept only passwords that are secure enough. For example, it should be at least a few characters long and always contain at least one symbol and one number. You can set this condition with the following question.
If you like, enter y and press Enter.

LOW Minimum of 8 characters
MEDIUM minimum of 8 characters, must contain numbers, uppercase and lowercase letters, and special symbols
STRONG Minimum of 8 characters, must contain numbers, upper and lower case letters, and special symbols, and no more than 4 characters must match a word in the dictionary file.
That's it. In the future, if you want to log in to MySQL as root user, you can use the following command.

1.3 Checking the operation of MySQL

2.Wordpress installation

2.1 Create a database for Word Press.

2.2 Word Press Installation

①Download and extract WordPress

Rewrite the wp-config settings, username and password to the ones you just put into MySQL.

Move the expanded contents under /var/www/html/hoge.com

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

Make apache the owner of the wordpress directory.
# chown -R www-data:www-data /var/www/html/hoge.com

③Access from a browser
Go to http://hoge.com/.

Debian: "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 installed php and mysql on your Debian server, but when installing 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. Check if the library related items are installed, and if not, install the php library related items.

Installing the MYSQL module
WordPress requires the PHP MYSQL module, if you do not have it installed, install it.

Restart Apache after the installation is complete.

Go to "http://<FQDN>/ wp-admin" in your browser with your browser again

On the input screen below

  • Site Title   Any name
  • Username     Any name
  • Password  Any Password
  • Your Email  Admin mail-address

Click on "Install WordPress".
Make sure you remember your username and password as they are required to access the wordpress admin panel.

タイトルとURLをコピーしました