Results 1 to 6 of 6
-
11-24-2014, 05:19 AM #1Web Hosting Master
- Join Date
- Mar 2009
- Posts
- 3,700
how can i make sure my cpanel is disable remote mysql connection ?
Hi,
on my cpanel server,i make sure the TCP_IN does not have 3306 on csf.conf,
but user tell me he ever add his remote ip within his cpanel and it works,
is any way to check if 100% other server can not remote connect my server's mysql ?
-
11-24-2014, 08:04 AM #2Web Hosting Master
- Join Date
- Jul 2009
- Posts
- 1,568
You can bind Mysql to localhost by adding the following in the /etc/my.cnf file and restarting the mysql service.
bind-address=127.0.0.1| LinuxHostingSupport.net
| Server Setup | Security | Optimization | Troubleshooting | Server Migration
| Monthly and Task basis services.
| MSN : madaboutlinux[at]hotmail.com | Skype : madaboutlinux
-
11-24-2014, 08:10 AM #3Web Hosting Master
- Join Date
- Mar 2009
- Posts
- 3,700
-
11-24-2014, 09:57 AM #4Disabled
- Join Date
- Apr 2007
- Location
- Everywhere
- Posts
- 273
Mysql upgrade should not alter your my.cnf file. However, Since it needs to be done manually you need to review your my.cnf settings after any major upgrades.
You can add the following variable to your my.cnf file then restart your mysql server:
Code:skip-networking
-
11-24-2014, 10:16 AM #5Web Hosting Master
- Join Date
- Mar 2009
- Posts
- 3,700
-
11-24-2014, 10:52 AM #6Web Hosting Master
- Join Date
- Jul 2009
- Posts
- 1,568
Right, if you remove 3306 from the CSF configuration, the port will be blocked for all remote machines. To verify, you can try telnet to port 3306 of your server from your computer or other server once the port is blocked.
If you cannot achieve it for some reason, the method explained earlier will surely help. Mysql upgrade won't remove the my.cnf file, however, if you place a new my.cnf file, you have to copy the entry manually.| LinuxHostingSupport.net
| Server Setup | Security | Optimization | Troubleshooting | Server Migration
| Monthly and Task basis services.
| MSN : madaboutlinux[at]hotmail.com | Skype : madaboutlinux
Similar Threads
-
how to enable and check mysql remote connection on cpanel/csf ?
By ttgt in forum Hosting Security and TechnologyReplies: 8Last Post: 11-07-2013, 02:33 PM -
Remote Connection to MySQL (cPanel)
By Zimple in forum Hosting Software and Control PanelsReplies: 2Last Post: 07-17-2013, 12:12 PM -
Cpanel Mysql remote connection USE EXIST DB
By xilu87 in forum Hosting Security and TechnologyReplies: 0Last Post: 06-29-2009, 04:12 AM -
cPanel/WHM setting up remote mysql connection
By BurakUeda in forum Hosting Software and Control PanelsReplies: 2Last Post: 01-09-2007, 11:38 PM -
disable version number in mysql connection banner?
By ub3r in forum Hosting Security and TechnologyReplies: 1Last Post: 04-23-2006, 11:27 PM