I can't connect to my database locally or remotely, do I have the correct server, username and password?

Since we run a shared hosting environment, we have to uniquely identify your MySQL Users to your account ONLY. We do this by attaching your system username and an underscore("_") before all the MySQL Databases and MySQL Users YOU create. Example:

    I added a new database (or user) and I filled in the name: mydatabase
    The Real Database Name: username_mydatabase

This applies to ONLY your database name and database user, your password stays normal. Things to keep in mind:

  • Your MySQL User that you enter can only be up to 7 characters long. We chop off everything else.
      Example: testuser -> username_testuser
  • You also need to remember to add your MySQL User to your database after the two are created.

Database Server/Host Address:

If your script or program is going to be accessing our database locally, meaning it is stored on your account, the server/host address will always be: localhost. Just like that, lowercase and one word.

If you're using remote database management software, the server would either be your domain name: example.com or the Shared Server IP

The shared server IP is found in the Stats section of the cPanel on left side.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What version of MySQL are you running?

The current version can be viewed in the cPanel on left side.

How do I create an empty MySQL Database

To create the database, do the following: Log into the cpanel Click the MySQL Databases icon...

How do I create a MySQL backup?

There are three options available to backup your MySQL databases: 1) Use the backup utility in...

I need to Export or Import a MySQL database

Note: PhpMyAdmin can only import and export databases up to 50 MB in size. If your database is...