Database Management ==> Creating My SQL Database or Postgres SQL  
     
  Creating My SQL Database ?  
     
 
SQL stands for Structured Query Language. SQL is an international standard in querying and retrieving information from databases. MySQL is essentially an SQL server - it responds to requests for information that are written in SQL. You can communicate with MySQL using a wide variety of programming languages (PHP being one of the most common). MySQL is Open Source software and free for use.
 
     
  [1] Go to www.yourdomain.com/cpanel [ example :www.techfreedomonline.com/cpanel]  
       
  [2] You will be prompted for user name & password  
       
  [3] Supply the user name and password provided by Tech Freedom Online  
       
  [4] Click on MySQL or Postgres SQL Databases menu  
       
  [5] Enter the name of the database in the Db field.  
       
  [6] Click on the Add Db button. The database will be added to the /var/lib/mysql folder.  
       
    Creating a Database User  
       
  [7] Enter the user's name in the Username field and the user's password in the Password field.  
       
  [8] Click on the Add User button  
       
    Binding User to Database  
       
   
Choose the specific user from the User drop-down list and the specific database to grant permissions to from the Db drop-down list.

Click on the Add User to Db button. The user now has permission to use that database and sample connection strings are shown in the MySQL window
 
       
 
Database names will be prefixed with the cPanel user name . For example : democp_data. where democp is your cPanel user name and data is your database name entered in the text box.
 
       
  Avoid using lengthy database names.  
       
  Make sure you create a user and bind the user to the database.  
       
  You might not be able to access your database if your connectivity is slower.

If your user name or password is wrong, you will not be able to access your database.

If your account is suspended due to excess bandwidth usage or server usage, your access will be suspended.
 

2005 Tech Freedom Online. All rights reserved