Client Portal

What are the Basic Connection Settings for MySQL?

There are two different ways to connect to a MySQL database:

Locally - from a script on the server, to the server for which the settings are:
Hostname: localhost
Username: username_dbuser
Password: dbpassword db_name: username_dbname db_table: dbname_table 

Remotely - from a remote computer, using Shell, ODBC, or Navicat. The settings are the same as above, but you must use yourdomain.com in place of 'localhost'. Clients connecting remotely (not using localhost or 127.0.0.1 as database hostname) should first enable 'Remote MySQL' in cPanel.

Java hosting clients should check What JDBC string and driver should I use to connect to your database servers?