Hi GeethuV,
Yes. i have added following in Mysql DB server to allow remote access
GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY “root” WITH GRANT OPTION;
FLUSH PRIVILEGES;
From wordpress application server, I was able to login through mysql client. I think the remote access is working fine. I don’t have GUI access to wordpress server so CpPanel is not an option to me.
mysql -h db-ip -u root -p
Besides, when i look the apache server log on wordpress server. It has following error
Permission denied in /var/www/html/wp-includes/wp-db.php on line 1538
Any guidance?
Thanks
Fan