How do I create databases and manage them?

1) In cPanel select the link "MySQL Databases."

2) In the "Db:" section, specify a name for the database that you are creating (ex: store, forum, etc..). After you have specified the name click "Add Db" and the database will be created.

3) In the "Users:" section specify a "Username," & "Password" for the database that you are creating (Note: you may use the same User/Password for all of your Databases).

4) At the bottom of the "Databases:" section you will now see "User: (username_yourname)," "Db: (username_databasename)." Select the "User" from the left dropdown menu and "Db" from the right dropdown menu that you want to use. "Click Add User to Db."

After your database is created you can manage it from phpmyadmin. This can be found at the very bottom of the MySQL page.

Was this answer helpful?

 Print this Article

Also Read

Please read before setting up a subdomain

To create a subdomain, cPanel asks for the name you wish to use. MAKE SURE the subdomain name you...

What scripts are available in Fantastico?

To view all the scripts currently offered inside Fantastico please visit:...

Do you have a manual for the control panel?

Yes, a manual for our control panel (cPanel) is available. Please surf to...

What is a subdomain?

www.yourdomain.com is a domain name. A subdomain is anything that replaces the www in a domain...

Why can't I log into my cPanel or webmail?

If you are attempting to access your cPanel or webmail from an office building or hotel, you...