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 6 years, 7 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
http://52.78.112.78/wordpress
This is my site.
-
This reply was modified 6 years, 7 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 6 years, 7 months ago by shinjune2.
-
This reply was modified 6 years, 7 months ago by shinjune2.
-
This reply was modified 6 years, 7 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
