[SOLVED] mysql fails to start up on different port

tuxstar · 12-05-2011, 02:31 AM

I'm using Fedora 15, disabled my firewall and installed mysql server 5.5.14
I'm trying to get mysql to listen on port 3315 instead of the default 3306.
When I include the variable port=3315 in the /etc/my.cnf file, mysql fails to start up.
The /var/log/mysqld.log logs the following:

111202 13:28:52 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied
111202 13:28:52 [ERROR] Do you already have another mysqld server running on port: 3315 ?
111202 13:28:52 [ERROR] Aborting

However there is nothing running on port 3315, the following returns nothing:
netstat -antpd | grep 3315

telnet localhost 3315
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused

When I remove the port=3315 variable from the my.cnf, mysql starts up fine on port 3306 and I can connect on port 3315 as well.
netstat -antpd | grep mysql
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 3569/mysqld

Please help me figure out why mysql doesn't want to listen on port 3315. Thanks.

corp769 · 12-05-2011, 02:36 AM

Before you dig too deep into this, do you have your firewall configured to allow traffic on port 3315? This may be an issue, especially if you have a defaulting reject or drop for your iptables.

Cheers,

Josh

bathory · 12-05-2011, 11:02 AM

Since you're running Fedora, this looks like a SELinux problem
Have a look here to see what you need to do

Regards

tuxstar · 12-06-2011, 12:02 AM

Thanks Bathory, I ran the command
sudo /usr/sbin/semanage port -a -t mysqld_port_t -p tcp 3315
and this solved my problem.
You guys rock!!! Thanks a mil.