Answered by the Webhosting Experts

Access your database remotely on a cPanel hosting

First of all, it is important to explain how the database/database user names are formed. The names consist two parts — your cPanel username and the actual database/username name. For example — if your username is “user” and if you named your database “databasename” you should use:

user_databasename

Same for database username:

user_username

So, if you would like to access your database remotely you should add your IP to remote hosts list firs. This could be done via you cPanel -> MySQL database. You will see on the bottom of your page Access Hosts section.

 

You can see your IP at https://www.whatismyip.com. If you have dynamic IP address you can add % instead which will allow connections from every IP.

To add a group of servers or an IP range you can use:

%.domain.com or 192.168.1.% for example.

As soon as you have your IP added you can access your database using the following information:

MySQL host: your doamin name or the server hostname/IP address

MySQL port: 3306 ( 99% chance to be 3306)

MySQL database: user_databasename

MySQL name: user_databaseuser

MySQL password: the password for the database applied for the user.

If you do not know the user and the password for your database you can always add a new one. This could be done via your cPanel -> MySQL database. Simply create a new user under the Current Users section and add it to the desired database with all privileges.

 

Need More Personalized Help?

If you have any further issues, questions, or would like some assistance checking on this or anything else, please reach out to us from your my.hivelocity.net account and provide your server credentials within the encrypted field for the best possible security and support.

If you are unable to reach your my.hivelocity.net account or if you are on the go, please reach out from your valid my.hivelocity.net account email to us here at: support@hivelocity.net. We are also available to you through our phone and live chat system 24/7/365.