Allow remote connections to your MySQL server

"Now, it's time to see how you can extend that MySQL server to remote machines.

"Why would you want to do this? A database server is a precious commodity in the world of data. To have that same server pitch other forms of data and other service could quickly become a detriment to your MySQL in both performance and security categories. Because of this it is wise to isolate that MySQL such that it is only used for that service. But to do this you have to configure that server to be able to serve up databases to remote machines. Although not terribly complicated, without knowing where to look and what to do, this task can be seemingly impossible. But after this tutorial, your databases will be accessible to user/machines you configure – and only those user/machines.

"Before we begin

"You will be glad to know, assuming you have MySQL up and running, there is no installation necessary for this task. You will need access to the MySQL administrators password as well as administrative access so you can edit a MySQL configuration file. Other than that simple necessity (and a terminal window), you are ready to get cracking."

Complete Story

Related Stories:

• MySQL 6 Features Roll Into MySQL 5.5 Milestone(Dec 22, 2009)
• Opposition mounts to Oracle's MySQL acquisition(Dec 14, 2009)
• Oracle's pledges on MySQL are 'purely cosmetic', say critics(Dec 14, 2009)
• DRBD and MySQL - Excellent Low-cost HA Solution(Dec 10, 2009)
• Manage your MySQL databases with an easy to use GUI(Dec 08, 2009)
• Learning The MYSQL Basics(Dec 07, 2009)