Changing mysql default port

cleibesouza · 07-19-2011, 09:12 AM

Hi all,
I'm trying to change the default mysql port with no success. I looked at my.cnf file and there's no reference to port. I also looked at the iptables and mysql is running on 3306 (default).
I've changed the iptable file but mysql fails to restart.
If I add port = [my port number] to the my.cnf file, mysql fails to start.

I'm surely missing something. Any ideas?

Thanks.

acid_kewpie · 07-19-2011, 09:42 AM

well that's the right thing to do, so what actually happens when you add "port=1234" ?

cleibesouza · 07-19-2011, 10:08 AM

Quote:

well that's the right thing to do, so what actually happens when you add "port=1234" ?

After I change port number mysql doesn't start.

acid_kewpie · 07-19-2011, 10:19 AM

yes you said that already. what errors are there? have you run mysqld in the foreground to look?

cleibesouza · 07-19-2011, 10:34 AM

Quote:

yes you said that already. what errors are there? have you run mysqld in the foreground to look?

No errors. It just says [FAIL] after the restart command.
Sorry but I don't know what you mean by "have you run mysqld in the foreground to look?", but I'm willing to do it if you explain me how.

Thanks.