Welcome! Guest
[ Login ]
21 Nov, 2008
Home | Customer Centre | Support Centre
RSS | Set Homepage | Favorite
Search:
Browse:

Database and user naming syntax for PostgreSQL and MySQL

Date Created: 19 Aug, 2008 Viewed: 91 Rating: 

Overview

Database and user naming syntax for PostgreSQL and MySQL
Click to Enlarge
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.

Things to keep in mind:
  • 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.


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.
The above information is for reference only
Was this article helpful?
You can bookmark it with your tracker:DiggredditDeliciousGoogle BookmarksWindows LiveFacebookSlashdot BookmarksPropellerTechnoratiBlinkListYahoo bookmarksMa.gnoliaSquidoo
Permalink:  
 
ec2Biz.com Interactive Multimedia Ecommerce Online Shop Solutions
©2008 Focus Network Company. All Rights Reserved.