How do I create a database?

This demo assumes you've already logged in to cPanel

Now let's learn how to create a MySQL database

1. Click MySQL Database Wizard

 

 

2. Enter a name for the new database, and Click Next Step

 

3. Now we have to create a user for this database... enter a username here

 

4. Then enter and confirm a password. When ready, click Create User.

 

5. Check here to assign All Privileges to the user. After that Click "Make Changes".

 

By this you can create databases.

 

The MySQL DB has been created, and the DB new username added to the DB. The database name, username and password will all be needed for scripts that need to connect to the database.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What version of mySQL are you running?

Login to your control panel. On the left side under "Server Info" it tells the mysql version

Restoring a mysql database via SSH

In order to restore your database via SSH or Telnet you will require 2 things:1. SSH or Telnet...

MS SQL Server - Installation

MS SQL Server - InstallationSQL Server supports two types of installation    1. Standalone    2....

How to Backup & Restore a MySQL Database

How to backup Mysql Database.   First, log in to your cPanel using your username and password....

Insert data into your database

Once you have your MySQL database, you can use the phpMyAdmin and insert data into your...