Change Default Mysql Port and restrict to IP ?

[Rodricks]

I want to connect 2 servers that are in different Data centers together using MySql

My thoughts so far are to do the following if possible:

1. Change MySQL Default port away from 3306

2. Lock down incoming connections on this new port to MySQL to a single IP of the other server

3. Encrypt the information transferred between them

Firstly what impact if any will Cpanel have on any of the above, i.e. does Cpanel require a hard coded 3306 for instance and if i change it will Cpanel updates change it back ?

Anyone else done anything similar who can give advice ?

[Glenn]

Hello,

Yes it is possible on cpanel server.

1. Change MySQL Default port away from 3306
Solution :: Suppose if you want to configure mysql on port 5123 then edit my.cnf as given below
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port=5123


2. Lock down incoming connections on this new port to MySQL to a single IP of the other server
Solution :: Add remote server ip in cPanel >> Mysql >> Access host

3. Encrypt the information transferred between them
Solution :: Configure secured port for mysql you can configure it as 5124 in the file stunnel.conf but make sure this file should be exist on both servers.


Firstly what impact if any will Cpanel have on any of the above, i.e. does Cpanel require a hard coded 3306 for instance and if i change it will Cpanel updates change it back ?
Solution :: Nothing to worry about cPanel and cPanel updates.

Regards,
Glenn....