Setting Up My Blog with WordPress on Render


2 min read

Table of contents

No heading

No headings in the article.

Several years ago I have set a blog using WordPress and found it quite useful, but honestly I never devote any effort into actually understanding the process. So when Adela told me to “deploy WordPress on Render”, I was totally confused since WordPress was the whole package in my understanding.

I followed the guide on render to set up MySQL using its private service and a WordPress web service, everything went smoothly until I click that URL to my WordPress webpage:

Error establishing database

Frankly speaking in the past 48h I’ve seen negative words including fatal, error and warning more than I’ve ever seen in my whole life. Glancing through a sociological perspective this type of rhetoric might actually affect ones psychosocial well-being😅.

As a beginner who has almost 0 experience in computer science, the term shell means only "shining objects washed up on the shore" for me, as a result I neglected the process "You can use the shell in your dashboard to connect to your database", and set up a web service connected to nothing (…).

Something I learned while using the shell to connect to my database: The only part you need to change in this command is "mysql-demo", replacing it using your own service address name without ":3306". You can see the dashboard running smoothly and within a sec you can see a pleasant line presenting as "mysql>"

Great! You’re almost there!

The final step is to deploy your currently existing WordPress to render, which requires the paired environment setting for your web service. By “WORDPRESS_DB_HOST”, this host is the MySQL you just created on render hence you should tap in your private service address, also without “:3306”.

For the other 3 environment settings they are exactly the same from your private service settings (WORDPRESS_DB_NAME=MYSQL_DATABASE; WORDPRESS_DB_USER=MYSQL_USER; and the same password).

To complete all your hard work done before, you MUST hit the "Manual Deploy" button and select "deploy latest commit" or when you click the URL there’s gonna be nothing but a horrifying "Error". By deploying your WordPress, the beautiful blue and white "W" would finally appear on your screen, and from now on congratulations, you’re free to design your own virtual backyard.