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.