How to connect the mysql database remotely in Linux dedicated server ?

Silicon House is a complete solution provider for reseller hosting, dedicated servers and cloud servers. Our expertise is in implementing high availability, high performance and hybrid cloud / dedicated servers.Silicon House runs hundreds of servers serving 1000+ customers in more than 90+ countries.

Please note that you can use the below details to connect the mysql database remotely.

MySQL Hostname: Server IP
MySQL Server Port: 3306
Username: your database username
Password: your database user password

Before you are accessing the database you have to allow your ISP IP in the server firewall and remote mysql access

Procedure to allow IP in Firewall.

Go to Directadmin Panel >> Under extra features click ConfigServer Security & Firewall
In Quick Allow option, enter your IP address at “Allow IP address” >> Click the “Quick Allow”

Procedure to allow IP in remote mysql access

Kindly refer the procedure:

1) Go to Directadmin panel of the domain as a user
2) Then under account manager click MySQL Management
3) After that click the database name from the list of databases
4) Enter ” % ” at Access Hosts >> Click on “Add Host”