Linux Today: Linux News On Internet Time.

Allow remote connections to your MySQL server

Dec 28, 2009, 17:03 (0 Talkback[s])
(Other stories by Jack Wallen)

"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: