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), and Remotely (from a remote computer, using Shell, ODBC, or Navicat)

Locally, the settings are:
Hostname: localhost
Username: username_dbuser
Password: dbpassword
db_name: username_dbname
db_table: dbname_table

Remotely, the settings are the same, but you must use yourdomain.com in place of 'localhost'.  Also, your IP address must be whitelisted on our end in order to get through our firewall. You can whitelist your IP address inside the cPanel under "Remote mySQL".
  • 43 Users Found This Useful
Was this answer helpful?

Related Articles

Do you support ASP pages and Access databases?

Unfortunately, we do not. We currently only support MySQL, PHP, CGI, and Perl.

How do I restore a database from cPanel?

With the Backups tool in Cpanel, you may generate, download or restore backup files, MySQL...

How do I create a MySQL backup?

You can take a backup of your MySQL databases using phpMyAdmin.  To do this, follow these...

What version of MySQL are you running?

We are currently running 5.0.45.