Knowledgebase: Databases
Creating a New Database
Posted by Joe Rebis (Import) on 16 September 2006 09:32 PM

 

To create a new database you will need to login to your control panel. We support several control panels so the instructions and button names vary accordingly.

Linux Web Hosting Plans:

  1. Login to your Account.
  2. Click on the "Control Panel" button.
  3. Click or search for "MySQL Database" icon in the Databases section.
  4. Type in your database name.
  5. Click "Create Database".
  6. Scroll down and type in new user name.
  7. Enter a Password for the database. NOTE: Using the Password Generator will provide a good quality secure password
  8. Click "Create User".

After Creating the Database and User you must now Add the user to the Database.

  1. Using the 'User' drop down list, select the user
  2. Using the 'Database' drop down list, select the database
  3. Click "Add" and you will be presented with the permissions to assign to the user of the database. NOTE: if installing WordPress often it is "All Privileges"
  4. Select Permissions and click "Make Changes".

Please Note: Use "localhost" when connecting to the database from your website. Click or search for the PHPMyAdmin link to modify your database.

 

Windows Web Hosting Plans:

  1. Login to your Account.
  2. Click on the "Control Panel" button.
  3. Click or search for the "Database" icon.
  4. Select the type of database.
  5. Click "Create Database".
  6. Enter database name and "Save".
  7. Click "Create User".
  8. Enter a username and password and "Save".
  9. Assign/add user to database and "Save".
  10. Click database name to assign user to database.

Please Note: The IP address can be found by clicking on the database. Use the internal IP address (192.168.XXX.XXX) when connecting to the database from your website. Use the external IP address (64.87.XXX.XXX) to connect to your database remotely. If using MySQL you can login to PHPMyAdmin by clicking the "View Database" link from the control panel.

SEE ALSO "Important IP Addresses" knowledge base article.

 

 

(1366 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).

Copyright © 2015 EPhost, Inc. All rights reserved.