How to connect remotely to MySQL

You can connect to your MySQL database remotely on our Linux servers. You will need to use a client such as:

EMS SQL Manager for MySQL: http://www.sqlmanager.net/products/mysql/manager/

or

MySQL Administrator: http://www.mysql.com/products/workbench/admin

You will need to set up access using the Remote MySQL icon in the “Databases” icon group in your cPanel. Just enter your own IP address in the field beneath “Add Access Host.” If you don’t know your IP address, you can

Additionally, you must create a database as well as a user and then add the user to the database prior to establishing a connection. 

When you connect, the hostname will be your domain name and the port is 3306.

If you need help with your HostPapa account, please open a support ticket from your dashboard.

This article is also available in: French Spanish German

Related Articles