How to Create a New Web Hosted Database

You need to create your database within your web host’s control panel and create a special database user who has permission to access it. When you are installing a web application or script that requires a database from your control panel, the installer will most likely be able to create its own database and user. When you are building your site manually, you need to create a database and user.

The exact steps required to create a database vary from control panel to control panel, but most are essentially the same as the following steps, which are for cPanel. To create a new database automatically, do the following:

  1. Log in to your control panel.

  2. Click the MySQL Database Wizard in the Databases section.

  3. Type a name for the database.

    On most control panels, the name of the database can be a maximum of eight letters.

  4. Click Create Database.

  5. Type a username.

    On most control panels, the username can be a maximum of seven letters and should be a word unique to the user.

  6. Type a password for the user and then retype it in the next box.

    You can use the password generator to generate a very secure password, but don’t forget to make a note of what it is!

  7. Click Create User.

  8. Select the privileges the new user will have on the database.

    Unless you know of specific privileges you want to exclude the user from having, it’s best to click All Privileges.

  9. Click Next Step.

Alternatively, you can create a database manually by using the following steps:

  1. Log in to your control panel.

  2. Click MySQL Database in the Databases section.

  3. Type a name for the database.

    On most control panels, the name of the database can be a maximum of eight letters.

  4. Click Create Database.

  5. Scroll down to the section titled MySQL Users and type a username.

    On most control panels, the username can be a maximum of seven letters and should be a word unique to the user.

  6. Type a password for the user and then retype it in the next box.

    You can use the password generator to generate a very secure password, but don’t forget to make a note of what it is!

  7. Click Create User.

  8. Scroll down to the Add User to Database section and select your database and username from the drop-down menus.

  9. Click Add.

  10. Select the privileges the new user will have on the database.

    Unless you know of specific privileges you want to exclude the user from having, it’s best to click All Privileges.

  11. Click Make Changes.

blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.