Change MySQL port
Moderator: General Moderators
-
tristanlee85
- Forum Contributor
- Posts: 172
- Joined: Fri Dec 19, 2003 7:28 am
Change MySQL port
I'm trying to run MySQL on port 23 instead of 3306 due to blocked connections at work. I don't run a telnet server so port 23 is open, but whenever I change the port in my.cnf to port 23, I can't get the MySQL service to start. Is there any way around this?
If you are on linux did you change the entry for that port in /etc/services? I think that might make a diff, but I am no linux expert.
Blocked how? If its blocked at the firewall and you are trying to get in through the outside, its blocked for a good reason. I don't think you want port 3306 just out there on the internets for all to see. You would be better off setting up a VPN or something of the sort.
Blocked how? If its blocked at the firewall and you are trying to get in through the outside, its blocked for a good reason. I don't think you want port 3306 just out there on the internets for all to see. You would be better off setting up a VPN or something of the sort.
-
tristanlee85
- Forum Contributor
- Posts: 172
- Joined: Fri Dec 19, 2003 7:28 am
-
tristanlee85
- Forum Contributor
- Posts: 172
- Joined: Fri Dec 19, 2003 7:28 am
I changed it to mysql.Begby wrote:If you are on linux did you change the entry for that port in /etc/services? I think that might make a diff, but I am no linux expert.
Code: Select all
ftp 21/tcp
ftp 21/udp fsp fspd
ssh 22/tcp # SSH Remote Login Protocol
ssh 22/udp # SSH Remote Login Protocol
mysql 23/tcp
mysql 23/udpI run the MySQL server from my apartment. There isn't anything important on this server that will be of any use to anyone so accessing my SQL server from a remote location is the least of my security worries. I don't have the access blocked on my firewall. At work that must not allow outgoing connections to port 3306 because it times out, but if I change my program to connect to port 23, it will allow that.Begby wrote:Blocked how? If its blocked at the firewall and you are trying to get in through the outside, its blocked for a good reason. I don't think you want port 3306 just out there on the internets for all to see. You would be better off setting up a VPN or something of the sort.
Currently it works right now. I have the external port 23 re-route to internal port 3306 within my router configuration. That works just fine, but it's very slow due to the routing. That's why I would like to go directly to a SQL server running on port 23 instead of having to router an external port to an internal port. The reason I am choosing port 23 is because it works from work and it's a port that I'm not using here.