MySQL remote access

Submitted by brucelet on Tue, 03/23/2010 - 16:10

How do I allow remote access to MySQL for one virtual server? They want to attach with Connector/ODBC.

Status: 
Closed (fixed)

Comments

Submitted by andreychek on Tue, 03/23/2010 - 16:35

Once MySQL is listening for TCP connections, you can enable remote access for a given user by going into "Edit Databases", and adding their IP address to the "Remote Hosts" area. That will grant their username permission to be accessed from that IP address.

MySQL doesn't listen for TCP connections by default, to allow that, you'd have to go into Webmin -> Servers -> MySQL Database Server -> MySQL Server Configuration, and set the port to 3306, and make sure it's set to listen on "Any" address.

Submitted by sgrayban on Wed, 03/24/2010 - 03:29

And if you are using a firewall make sure you open port 3306

Submitted by Issues on Thu, 04/08/2010 - 07:20

Automatically closed -- issue fixed for 2 weeks with no activity.