How to Create a MySQL Database

Creating a MySQL Database

Most dynamic websites and applications require a MySQL database to store content, user accounts, and settings. SillyHost makes it easy to create and manage databases through cPanel.

Creating a Database in cPanel

1. Log in to your cPanel control panel.
2. Scroll to the Databases section and click MySQL Databases.
3. Under Create New Database, enter a name for your database. The name will be prefixed with your cPanel username (e.g., username_mydb).
4. Click Create Database.

Creating a Database User

A database needs a user account to connect to it:

1. On the same MySQL Databases page, scroll to MySQL Users.
2. Enter a username and a strong password. Use the password generator for a secure password.
3. Click Create User.

Assigning the User to the Database

1. Scroll to Add User to Database.
2. Select the user and database from the dropdown menus.
3. Click Add.
4. On the privileges screen, tick All Privileges to grant full access, or select only the specific permissions your application requires.
5. Click Make Changes.

Connecting Your Application

To connect your website or application to the database, you will need these details:

• Database name – The full name including the prefix (e.g., username_mydb).
• Database user – The full username including the prefix.
• Database password – The password you created for the user.
• Database host – Usually localhost for applications on the same server.

Using the MySQL Database Wizard

If you prefer a guided process, use the MySQL Database Wizard in cPanel. It walks you through creating a database, creating a user, and assigning privileges in a simple step-by-step format. This is ideal for beginners.