How to connect to the MySQL database

How to connect to the MySQL server remotely

Remote MySQL connections are disabled by default in cPanel servers because they are considered a potential security threat.

Please note that HDWEBPROVIDER™ Shared customers are not permitted to use remote MySQL connections in order to ensure the security of the other customers on the same server. Remote mysql connections can only be enabled for Dedicated and VPS customers (cloud hosting).



On cloud/private servers:


Configuration Settings:

Host = localhost (really, put localhost)
Database name = (cpanelusername_databasename)
Database username = (cpanelusername_databaseusername)
Database password = (******)

It is possible for someone to use their cPanel username and password to connect to the database. However, we NEVER recommend doing this because the first time you change or reset your cPanel password, then your databases will stop working.

 

 




 



  • Email, SSL
  • 12000 Users Found This Useful
Was this answer helpful?

Related Articles

Accessing Web Disk

Web disk (also known as Web Dav) is a drag-and-drop interface which allows you to access your...

Apache Error Logs

When you check the error logs, you can see many things.Some things you can ignore:File does not...

Apache modules that are on all of our shared servers

core.c mod_authn_file.c mod_authn_dbm.c mod_authn_dbd.c mod_authn_default.c mod_authn_alias.c...

Can I password protect directories?

To password protect directory: Wait! Why read this when you can watch the movie tutorial...

CGI center

The following CGI Scripts are pre-installed and ready to use on your account: Simple CGI Wrapper...