How to create Wordpress Website in Linux - resolve upload max MB & Home Url

Setting Up WordPress Containers with Portainer

To create a WordPress environment, you'll need to set up two containers: one for the database and one for the web server. You can use the following docker-compose.yml file to create these containers.

Docker Compose File

 

YAML

xxxxxxxxxx

30

 

1

version: '3.1'

2

​

3

services:

4

  db:

5

    image: mysql:8.0

6

    command: --default-authentication-plugin=mysql_native_password

7

    volumes:

8

      - db_data_apexnote_de:/var/lib/mysql

9

    restart: always

10

    environment:

11

      MYSQL_ROOT_PASSWORD: example

12

      MYSQL_DATABASE: wordpress

13

      MYSQL_USER: wordpress

14

      MYSQL_PASSWORD: wordpress

15

​

16

  wordpress:

17

    depends_on:

18

      - db

19

    image: wordpress:latest

20

    ports:

21

      - "7300:80"

22

    restart: always

23

    environment:

24

      WORDPRESS_DB_HOST: db:3306

25

      WORDPRESS_DB_USER: wordpress

26

      WORDPRESS_DB_PASSWORD: wordpress

27

      WORDPRESS_DB_NAME: wordpress

28

​

29

volumes:

30

  db_data_apexnote_de: {}

Step 1: Deploy Containers Using Portainer

• Open Portainer: Log in to your Portainer dashboard.
• Stacks: Navigate to the 'Stacks' section and click on 'Add Stack'.
• Create a New Stack:
• Name your stack (e.g., wordpress-site).
• Copy and paste the docker-compose.yml content into the editor.
• Deploy the Stack: Click 'Deploy the stack'.

Resolving Upload Issues in WordPress

If you encounter issues with file uploads exceeding the maximum size, follow these steps to increase the upload limit:

Step 1: Access the WordPress Container

• Open a Terminal: Use Portainer's console or a terminal to access the WordPress container.
• Execute the Bash Shell:

 

Apache

xxxxxxxxxx

 

1

docker exec -it db_data_apexnote_de bash

Step 2: Modify PHP Settings

• Navigate to the WordPress Directory:

 

Plain Text

xxxxxxxxxx

 

1

cd /var/www/html

• Install Nano Editor (if not installed):

 

Plain Text

xxxxxxxxxx

 

1

apt updateapt install nano

• Edit the File:

 

Plain Text

xxxxxxxxxx

 

1

nano .htaccess

• Add the Following Lines:

 

Apache

xxxxxxxxxx

11

 

1

# Increase the maximum upload file size to 4096M

2

php_value upload_max_filesize 4096M

3

​

4

# Increase the maximum POST size to 4096M

5

php_value post_max_size 4096M

6

​

7

# Increase the maximum execution time to 300 seconds

8

php_value max_execution_time 300

9

​

10

# Increase the maximum input time to 300 seconds

11

php_value max_input_time 300

• Save and Exit: Press CTRL + O to save and CTRL + X to exit.

Step 3: Restart the Container

• Exit the Container:

 

Plain Text

xxxxxxxxxx

 

1

exit

• Restart the WordPress Container:

 

Apache

xxxxxxxxxx

 

1

docker restart db_data_apexnote_de

Changing the WordPress URL

If you need to change the URL of your WordPress site, follow these steps:

Step 1: Access the MySQL Database

• Open a Terminal: Access the MySQL container using Portainer or a terminal.
• Log into MySQL:

 

Plain Text

xxxxxxxxxx

 

1

mysql -u wordpress -p

• Use the WordPress Database:

 

Plain Text

xxxxxxxxxx

 

1

USE wordpress;

Step 2: Update the URL

• Check Current URLs:

 

Plain Text

xxxxxxxxxx

 

1

SELECT option_name, option_value FROM wp_options WHERE option_name = 'siteurl' OR option_name = 'home';

• Update the URLs:

 

SQL

xxxxxxxxxx

 

1

UPDATE wp_options SET option_value = 'http://new-url.com' WHERE option_name = 'siteurl';

2

UPDATE wp_options SET option_value = 'http://new-url.com' WHERE option_name = 'home';

• Verify Changes:

 

Plain Text

xxxxxxxxxx

 

1

SELECT option_name, option_value FROM wp_options WHERE option_name = 'siteurl' OR option_name = 'home';

Action Items:

• Deploy Containers: Use the provided docker-compose.yml file to set up the WordPress and MySQL containers using Portainer.
• Increase Upload Limits: Modify the .htaccess file to increase upload limits.
• Update WordPress URL: Change the site URL directly in the database if needed.

 {fullWidth}