Non urgent question re mysql ports

[vivaciti]

Hi,
I have been asked the below question from one of my customers:

At present MySQL uses the default port of 3306. If I was to ask for the default port to change to another port what is the probability of this say to use another port.

Anyone able to answer this for me?

Cheers.

[eUKShane]

Hey,

Yes, you can change MySQL Server default port using following procedure :

Go to /etc/my.cnf :

For example

[client]
port=3306
socket=/tmp/mysql.sock

[mysqld]
port=3306
socket=/tmp/mysql.sock
key_buffer_size=16M
max_allowed_packet=8M

[mysqldump]
quick

and then replace 3306 by required port. Also you have to open new port in your firewall.

That's it !

[vivaciti]

Would that effect it across the board or just for that one customer?

[eUKShane]

Hey,

Definitely, in this way you can change MySQL Server default port and this will be a server wide setting.

So you have to notify to all your customers to use new port for remote MySQL Server access.