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

How do I add database and user for database?

Create: If you are using any type of PHP software or keeping a collection of records which...

What is subdomain, parked domain and addon domain?

A subdomain is a second website, with its own unique content, but there is no new domain...

What is Fantastico?

Fantastico De Luxe is the leading auto installer for cPanel servers. With more than 10,000...

public_html folder?

The public_html folder is the web root for your primary domain name. This means that...

How do I backup/restore/move in cPanel?

How can I restore my site with old/previous content? AdriaHost will restore your recreate...