WordPress AMI on Amazon Linux 2

Classmethod Canada
3 min readMay 2, 2021

--

This WordPress AMI is running on our LAMP and phpMyAdmin AMI.

Web Server

We prepared SSL/TLS so you can access the top page using http:// or https://.

WordPress Installation

Once the instance is running, please access your WordPress hosting domain or enter the public DNS provided by AWS (IPv4 Public IP) into your browser.

https://<wordpress host or IP>/

You will see the WordPress application. Chose your language settings.

Since the wp-config.php file already exists, you may see the following message. If this is the case, simply click “installing now” to continue.

Specify your account details including username and password, and click “Install WordPress”.

You should see this success message indicating that your WordPress account has been created.

Options

phpMyAdmin

You can access phpMyAdmin after creating ssh tunnel. Please refer to Amazon Linux 2 LAMP with phpMyAdmin AMI

Find database password

You can find the database server password by accessing the System Log in the EC2 management console:

  1. Go to the Amazon EC2 console at https://console.aws.amazon.com/ec2/.
  2. Chose your Instance and Click on Actions → Instance Settings → Get System Log.

3. Get System log as shown below.

You can also SSH into your instance and find the login credential using the following command.

$ cat /home/ec2-user/credentials 
////////////////////credentials info////////////////////
--- WordPress
----- Setting : Success
--- phpMyAdmin
----- Setting : Success
--- MariaDB
----- User : root
----- Password : ****************
----- User : wordpress
----- Password : ****************
////////////////////////////////////////////////////////

Changing URL

You can change the WordPress URL by using wp-cli. You can change it by executing the following command after logging into the instance over SSH.

$ curl -s localhost | grep wp-content
$ wp search-replace 'old_site_url' 'new_site_url' --path=/var/www/html/wordpress --skip-columns=guid

For example, when your instance IP was changed from xxx.xxx.xxx.xxx to yyy.yyy.yyy.yyy you can check URL as shown below:

$ curl -s localhost | grep wp-content
<link rel=’stylesheet’ id=’twentynineteen-style-css’ href=’http://xxx.xxx.xxx.xxx/wp-content/themes/twentynineteen/style.css?ver=1.4' type=’text/css’ media=’all’ />
<link rel=’stylesheet’ id=’twentynineteen-print-style-css’ href=’http://xxx.xxx.xxx.xxx/wp-content/themes/twentynineteen/print.css?ver=1.4' type=’text/css’ media=’print’ />

To update the URL, execute the following command:

$ wp search-replace xxx.xxx.xxx.xxx yyy.yyy.yyy.yyy --path=/var/www/html/wordpress --skip-columns=guid
+------------------+-----------------------+--------------+------+
| Table | Column | Replacements | Type |
+------------------+-----------------------+--------------+------+
| wp_commentmeta | meta_key | 0 | SQL |
| wp_commentmeta | meta_value | 0 | SQL |
<...>
| wp_options | option_value | 2 | PHP |
| wp_options | autoload | 0 | SQL |
| wp_postmeta | meta_key | 0 | SQL |
| wp_postmeta | meta_value | 0 | SQL |
| wp_posts | post_content | 2 | SQL |
<...>
| wp_users | user_url | 1 | SQL |
| wp_users | user_activation_key | 0 | SQL |
| wp_users | display_name | 0 | SQL |
+------------------+-----------------------+--------------+------+
Success: Made 5 replacements.

Reference

--

--

Classmethod Canada
Classmethod Canada

Written by Classmethod Canada

We are Vancouver-based cloud integrators and solutions architects focusing on cloud system infrastructure, IoT cloud architecture and cloud migration .

No responses yet