Hello,

Below are the tricks to secure mysql service on your cpanel server.

A. Change MySQL Default port :: Suppose if you want to configure mysql on port 5123 then edit my.cnf and configure 5123 as given below

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port=5123

B. Restrict access to MySQL service for specific ips :: Add remote server ip in cPanel >> Mysql >> Access host

C. Encrypt the information transferred between them :: 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 (your server and remote server to which you wish to give access).

Subscribe ME