First we need to understand the error message.
Please turn on 「 define('WP_DEBUG', false);」to define('WP_DEBUG', true);
in the file /data/wp-config.php on NFS server.
It will tell us the exact error message for db connection.
Then, need to check the grant of DB to a particular user.
I forgot once to execute 「FLUSH PRIVILEGES;」which simply assign new privileges.
I hope you will get some pointers and complete your task.
@pmpcert2013@Tej-Singh-Rana@hasmukhrathod@Lalit
There is a DB dump on jump_host under location /home/thor/db.sql. Restore this database in newly create database. -
for this step. should I copy this sql file to db server using scp command and restore the sql from db server on newly created database?
or this should be done in a different way?
could you please check and advise.
I think you have problems while connecting to database. And it must be related to the user privileges.
Before you modify user privilege, I request you to check if you are able to connect using those user credentials from terminal.
If it fails, then drop your user and execute as below,
MariaDB [(none)]> drop user ‘kodekloud_tim’@‘%@%’;
MariaDB [(None)]> create user ‘kodekloud_tim’@‘%’ identified by ‘Pra2468@’ ;
MariaDB [(None)]> grant all privileges on kodekloud_db8.* to ‘kodekloud_tim’@‘%’;
Hey @bushido I tired but still not luck with the advise you gave, can you please advise what the issue could be ? @pmpcert2013 Hey did you get this resolved ? if so please advise how to correct the error " Error establishing database connection" @Tej-Singh-Rana would you be able to give some input
mysql -u root -p
create database kodekloud_db7;
create user ‘kodekloud_top’@localhost identified by ‘pass’;
grant all on kodekloud_db7.* to ‘kodekloud_top’ identified by ‘pass’ WITH GRANT OPTION;
grant all privileges on kodekloud_db7.* to ‘kodekloud_top’@‘%’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit
[root@stdb01 peter]# vi /etc/my.cnf
bind-address=172.16.239.10
port=3306
to import dump
mysql -u kodekloud_top -p kodekloud_db7 < /tmp/db.sql
systemctl restart mariadb
To Validate from db server
mysql -u kodekloud_top -p -h stdb01
mysql -u kodekloud_top -p -h localhost
sudo sed -i 's/dbname/kodekloud_db7/g' /data/wp-config.php
sudo sed -i 's/dbuser/kodekloud_top/g' /data/wp-config.php
sudo sed -i 's/dbpass/pass/g' /data/wp-config.php
sudo sed -i 's/dbhost/stdb01/g' /data/wp-config.php
one more step to validate my sql connection from app server:
login app server install my sql client and try to login mariadb using specified user
app server
yum install mysql -y
mysql -u kodekloud_top -p -h stdb01
I have issue’s completing this task, Getting “Error Establishing Database Connection” issues.
Guy’s please help me out to finish the task. PFA screenshots.
Hi @girish.shet187 While creating the mysql user and while granting user the access to the database you should also mention the host as php will try to connect to remote mysql server.