I managed to successfully install mariadb from SCLO. I am able to login to the database and create users, new databases, etc.
The setup I am doing now is for WordPress. The error I get when I try to open the WordPress install page from the browser is (http://myserverip/wp-admin/install.php) :
Error establishing a database connection
This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at localhost. This could mean your host’s database server is down.
Are you sure you have the correct username and password?
Are you sure you have typed the correct hostname?
Are you sure the database server is running?
However, the db is not down, as when I run a ps -aux, I can see it running :
- Code: Select all
[root@dev-mumo system]# ps -aux | grep maria
mysql 14266 1.0 4.3 1305104 79276 ? Ssl 12:12 0:00 /opt/rh/rh-mariadb102/root/usr/libexec/mysqld --basedir=/opt/rh/rh-mariadb102/root/usr
root 14356 0.0 0.0 110428 892 pts/0 R+ 12:13 0:00 grep --color=auto maria
I also can see it listening to port 3306 :
- Code: Select all
[root@dev-mumo system]# ss -tulpn | grep mysql
tcp LISTEN 0 80 [::]:3306 [::]:* users:(("mysqld",pid=14266,fd=20))
I have checked wp-config.php, and all the details like db name, db user, password matches details in the db itself.
How do I resolve this error?