Creating Databases

To create a database, sign into the control panel and then click on the "Account Manager" icon, followed by the "SQL Management" link.

 

From the main control panel menu, click the "MySQL Databases" icon and then click the "Create new Database" button.

mysql create

When setting up a database, choose a name that helps you remember what it is used for. For instance, use "chat" if it will be used for a chatting program. Your username and an underscore will always come before the database name. Therefore, if you choose "chat" for a name, the actual database name will be username_chat.

The Database Username is your login name for the database. It can be the same as the Database Name or different from it. For example, in the above case, we used a different login name (gary). Your username and an underscore will come before the Database Username as well (e.g., username_gary).

Once you have selected a database name and username, create a database password and click on "Create" to complete the setup.

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Removing Databases

To find a list of all databases in MySQL, go to the main databases menu. If you want to delete...

Adding Users to a Database

There may be times when you want to have more than one login name and password assigned to a...

Removing Users from a Database

To remove database users, first click on the database name from the main MySQL databases menu. In...

Changing Database Passwords

To change your database password, follow these steps:1. Go to the main MySQL databases menu and...