Overview
Database and user naming syntax for PostgreSQL and MySQL
Since we run a shared hosting environment, we have to uniquely identify your usernames to your account ONLY.
We do this by attaching your system user name and an underscore("_") before all the databases and users YOU create.
Example:
Your added a new database(or user) and your filled in the name:
mydatabase
The Real Database Name:
username_mydatabase
(e.g.
C0801001234567_mydatabase)
* Where C0801001234567 replace your system user name.
This applies to ONLY your database name and database username, you password stays normal.
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.
Attention
Please note that the database name, username and passwords are case sensitive.
Your username can only be up to 10 characters long. We chop off everything else.
Example: billyboboard -> C0801001234567_billyboboa
You also need to remember to add you user to your database after the two are created.
Related Links
*** The above information is for reference only, Please seek independent technical advice if found necessary.
