0

I have to use MySql database which is lie on other server. I have it's IP, username and password.

How I can make connection with remote MySql data base. Is there need to give any permission to my IP address by remote MySql database provider. I think that would be mandatory

Give your opinions.

Thanks

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user264341
  • 137
  • 1
  • 6
  • 14
  • My opinion is you haven't even tried to connect. You might try and report the approach and the error you get back – Llistes Sugra Dec 05 '11 at 08:55
  • I have tried with this way but still errors related to mysql connectivity.SEE url : http://elbuso.softquanta.org/oslo – user264341 Dec 05 '11 at 09:16

2 Answers2

1

there are a few steps to do, just follow this tutorial.

basically, you'll have to:

  • enable networking
  • set a bin-address
  • grant access from another ip to your database-user
oezi
  • 51,017
  • 10
  • 98
  • 115
1

To access Mysql database from another server, you have to enable mysql remote connection in the current server.So that you can access it. For more info just refer the following link http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

Manigandan Arjunan
  • 2,260
  • 1
  • 25
  • 42