从不同服务器访问数据库

Question

I want to access my database that is on another server. My database lies on server A. User accessing webpage is lies on server B. I have made one config.php file is act as third party or intermediate between server A and server B that lies on server A. The config.php access database according to requirement and send data to user on server B. I am passing a bulk of data through URL parameter using config.php.

But, It shows me Error like

"Forbidden

You don't have permission to access /DataScripts/home.php on this server."

Anyone suggest me what is this error and what can I do?

Answer 1

Assuming this is MySQL, and that you control both servers, on server B, ssh in and edit my.cnf. Scroll down to the `[mysqld] section and add this line:

bind-address=SERVER-B-IP-ADDRESS

Save and exit. Launch mysql.

Type the following pseudo-SQL:

GRANT ALL ON *.* TO adminuser@'SERVER-A-IP' IDENTIFIED BY 'PASSWORD';

Depending on your firewall setup you may have to whitelist server A's IP address as well as add it to the remote access list.