commands

By default, MySQL database server remote access disabled for security reasons. However, some time you need to provide the remote access to database server from home or from web server.

Step # 1: Login over ssh if server is outside your IDC
First, login over ssh to remote MySQL database server

Step # 2: Enable networking
Once connected you need edit the mysql configuration file my.cfg using text editor such as vi.