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