Your PHP installation appears to be missing the MySQL extension which is require

If you’re a beginner, you probably should not be running a VPS on AWS. It calls for a lot of Linux sysadmin skills.

Try

sudo yum install php-mysqlnd

Hello, Steve

Thank you for your help. I fixed it.

But after inputting username, password, and database host, I faced ‘Error establishing a database connection’

What should I do now? Thank you in advance.

• This reply was modified 7 years, 6 months ago by shinjune2.

This goes beyond the scope of WordPress; this is linux system admin. You need some help with this.

Is your mysql server running? Did you install a mysql (or mariadb) server?

Assuming that MySQL/MariaDB is installed and running on your server, there are few other things that may cause this problem.

Have you created a MySQL database and user? You need to edit the wp-config.php file and update the database settings.

Make sure that the MySQL user has permissions to use/manage the MySQL database you created.

Thank Rose

I installed MySQL/Linux on EC2.

I checked that Apache and PHP (from my perspective) are working well.

I also created database for wordpress setup. After inputting right username and password, ‘Error establishing a database connection’ message came up.

How should I solve this? I am not a techie ??

I can access to my server through Putty and Filezilla

https://52.78.112.78/wordpress

This is my site.

• This reply was modified 7 years, 6 months ago by shinjune2.

Is your database server actually running?

What do you see if you do

ps -ef |grep mysql

I have to ask. If you’re ‘not a techie’, why are you administering your own server?

Hello, Steve

First of all, truly appreciate your help.

This is what I got

1. [ec2-user@ip-172-31-20-151 ~]$ ps -ef |grep mysql
root 8752 1 0 02:40 ? 00:00:00 /bin/sh /usr/libexec/mysql55/mys qld_safe –datadir=/var/lib/mysql –socket=/var/lib/mysql/mysql.sock –pid-file= /var/run/mysqld/mysqld.pid –basedir=/usr –user=mysql
mysql 8947 8752 0 02:40 ? 00:00:00 /usr/libexec/mysql55/mysqld –ba sedir=/usr –datadir=/var/lib/mysql –plugin-dir=/usr/lib64/mysql/plugin –user mysql –log-error=/var/log/mysqld.log –pid-file=/var/run/mysqld/mysqld.pid –so cket=/var/lib/mysql/mysql.sock
ec2-user 14415 14391 0 02:43 pts/0 00:00:00 grep –color=auto mysql

2. I studied finance but started my own company a few months ago. I used to using ‘WordPress.com’ but I want to make more advanced website using Javascript, etc.

Thank you for your help in advance.

Hello, Steve

I resolved this issue!

I didn’t set up my username and password. Now everything works well.

Let me ask you a final question.

I want to see wp-config.php file but I can’t see that.

I installed Filezilla and connected it to AWS but the files only I could see are files related to server.

Do I have to install other programs to see and control wp-config.php files (and to customize child theme files)?

Truly appreciate your help in advance.

where did you install WordPress?

Hello, Steve

I installed it on my AWS EC-2.

Am I doing something wrong or misunderstand what I am doing?

No, where on your file system did you install WordPress?

Try sudo updatedb; locate wp-config.php from and SSH commmand line.

Hello, Steve

Thank you very much for your patience. I’ve visited your website. You’re learning your own business. I started my business a few months ago but my background is investment banking. That’s why I try to learn this new world!

I input sudo updatedb; locate wp-config.php but what I got is as below

login as: ec2-user
Authenticating with public key “imported-openssh-key”
Last login: Sun Sep 3 15:30:54 2017 from 49.163.189.185

__| __|_ )
_| ( / Amazon Linux AMI
___|\___|___|

[ec2-user@ip-172-31-20-151 ~]$ sudo updatedb; locate wp-config.php
sudo: updatedb: command not found
-bash: locate: command not found
[ec2-user@ip-172-31-20-151 ~]$

Secondly, when I click on ‘root’ directory on Filezilla (on right side of remote site), there was a message like this on Filezilla

Command: cd “/root”
Error: Directory /root: permission denied
Error: Failed to retrieve directory listing

• This reply was modified 7 years, 6 months ago by shinjune2.
• This reply was modified 7 years, 6 months ago by shinjune2.
• This reply was modified 7 years, 6 months ago by shinjune2.

I have to come to the conclusion that your server is not set up correctly. You should either move to a managed WordPress hosting plan for your site and get a good book on Linux system administration before trying to build out a WordPress site at the same time you’re trying to learn Linux.

For those who are looking for a solution:
You’ll need to make sure that your PHP is running as the correct user. I two WordPress installation on my server and 1 was giving me this error. I am on GCP Debian server w/ Virtualmin.

ERROR: Your PHP installation appears to be missing the MySQL extension which is required by WordPress.

ISSUE: PHP is being run as FCGId as virtual server owner and PHP is does not execute correctly

FIX: Virtualmin – Server Configuration – Website Options – PHP Script Execution Mode – Apache mod_php