CODEWITHSUNDEEP
mysqlremote-access
user264341
user264341

Reputation: 157

Remote MySql connection from other server

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

Upvotes: 0

Views: 337

Answers (2)

Manigandan Arjunan
Manigandan Arjunan

Reputation: 2265

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

Upvotes: 1

oezi
oezi

Reputation: 51817

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

Upvotes: 1

Related Questions