20 May, 2018
Welcome! Guest
[ Login ]
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   (9 year(s) ago) Viewed: 1157 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.

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.
Was this article helpful?
You can bookmark it with your tracker:DiggredditDeliciousGoogle BookmarksWindows LiveFacebookSlashdot BookmarksPropellerTechnoratiBlinkListYahoo bookmarksMa.gnoliaSquidoo
Permalink:  
 
ec2Biz.com Interactive Multimedia Ecommerce Web Hosting Online Shop Domain name Solutions
©2018 Focus Network Company. All Rights Reserved.