Results 1 to 7 of 7
Thread: MySQL remote connections
-
04-16-2005, 08:34 PM #1Disabled
- Join Date
- Jan 2005
- Location
- USA
- Posts
- 1,379
MySQL remote connections
Hello,
I'd like to know your opinions on this matter. What are the risks in allowing MySQL remote connections? I've met a few people who think it is a large security risk, and some who don't think it is much of a risk at all.
I do have a few customers who like to connect remotely, so I don't want to disable it without good reason.
Further, is it possible to enable only certain IP addresses to connect remotely? I'm using CPanel 10.1.0.
Thanks for any comments on this.
-
04-16-2005, 09:05 PM #2Web Hosting Evangelist
- Join Date
- Jul 2002
- Posts
- 500
This is possible, all you should need to do is login to phpMyAdmin as your MySQL root user. Go to the "mysql" database and browse the user table. Find the entry for the user you want to allow remote access and duplicate it (with the exception of the host column). All you need to do is change the host column to match their IP address and then reload MySQL.
That should do it .
-
04-17-2005, 01:15 AM #3Retired Moderator
- Join Date
- Jan 2003
- Posts
- 9,049
Generally, Mysql have their own host checking rules as well as a relatively robust permissioning framework (on top of login/password), the user must be additionally granted permissions to access to a certain db before they can access it. So I would say it's no different from having a FTP server which is even far less secure.
••• Like us on Facebook to qualify for discounts! •••
••• http://www.sprintserve.net •••
••• Offering: | Internap FCP Bandwidth! | Rebootless Kernel Updates! | Magento Optimized Hosting | Wordpress Hosting | •••
••• Services: | Managed Multiple Cores 64bit Servers | Server Management | •••
-
04-17-2005, 09:14 AM #4Disabled
- Join Date
- Jan 2005
- Location
- USA
- Posts
- 1,379
I see. Thank you for your replies.
-
04-17-2005, 09:35 PM #5WHT Addict
- Join Date
- Feb 2005
- Location
- Sydney
- Posts
- 140
You can do this in CPanel under the MySQL area, see "Access Hosts:"
--
Damian
-
04-17-2005, 10:00 PM #6Disabled
- Join Date
- Jan 2005
- Location
- USA
- Posts
- 1,379
Does networking in my.cnf have to be enabled for this to be configured?
-
04-17-2005, 11:49 PM #7Retired Moderator
- Join Date
- Jan 2003
- Posts
- 9,049
By default, Mysql listens on port 3306. As long as your firewall allows it, you should be able to access it remotely.
••• Like us on Facebook to qualify for discounts! •••
••• http://www.sprintserve.net •••
••• Offering: | Internap FCP Bandwidth! | Rebootless Kernel Updates! | Magento Optimized Hosting | Wordpress Hosting | •••
••• Services: | Managed Multiple Cores 64bit Servers | Server Management | •••