Call us today 253-891-9648 or Toll-Free: (866) 932-9778
Follow Notable Web on Facebook

Support Topics

Contact Information

Phone:

Local:(253) 891-9648
Toll Free: (866) 932-9778

Fax:Contact Notable Web Today
    (253) 891-9412

Mailing Address:
    P.O. Box 7762
    Bonney Lake, WA
    98391

NOTABLE WEB - Support Center

Support Home Page » cPanel Administration » How do I create a MySQL database, a user, and then delete if needed?

How do I create a MySQL database, a user, and then delete if needed?

Create: If you are using any type of PHP software or keeping a collection of records which need to be accessed in some way, you will need to create a database. Below will show you how to create a MySQL database in cpanel.

  1. Click the MySQL Databases icon
  2. In the box to the right of New Database, please provide a name for the database. Please note cPanel will create the full name of the database as cpaneluser_databasename
  3. Click the Create Database button

You have now successfully add the database, You will now need to crate a user to access the database.

Create User: Whenever you have any type of MySQL database, you will need to assign a user to be able to access the database. If you would like to create a user and give them access to the database, please do the following:

  1. Click MySQL Databases
  2. Scroll down until you see the Current Users section
  3. Under this section and to the right of User name, please provide a user name for a database
  4. Please note that that full database user will be cpaneluser_databaseuser
  5. To the right of Password, please type the password for which you would like to create for this database user.
  6. Click Create User

You have now created a database user. You can manage it from PhpMyAdmin, found in the Databases section in cPanel.

You now need to give the user privileges for your specified database.

  1. In the drop down menu to the right of User, please sect the user for which you would like give privileges to.
  2. To the right of Database, please select a database for which you would like the user to have privileges to.
  3. Under privileges please choose what type of privileges you would like the user to have.
  4. Click Add User To Database button You have now created a new database with a privileged user. You can now input the information into a php script or another script to access it locally

You have now just gave a user permissions to a database.

Delete: If you are deleting a script or would like to restart a new database, the first step is to delete the old MySQL database. To do so, please do the following:

  1. Click MySQL Databases
  2. Under Current Databases, you will find the names of all your current databases.
  3. Click Delete next to the name of the database you would like to delete.

You have now deleted a MySQL Database.

Note: You may also need to delete the user who is accessing the database as well, if you would like not to have any further traces of the that database lingering.




Web Site Hosting

Web Site HostingWe know exactly what it takes to make a business successful on the Internet.

Our web hosting plans are very diverse and designed for almost any type of website or e-commerce solution. Notable Web has combined the best hardware, latest software and the ...
Read More!

Web Site Design

Website DesignThe team at Notable Web strives to create websites that are easy to navigate by both human visitors and by various search engine spiders. The clean slicing and coding we use provides the fastest possible page loads. Our websites are extremely versatile and allow maximum flexability for updates. ..
Read More!

Domain Name Registration

Domain Name RegistrationA domain name is the alias that identifies a certain organizations' presence on the Internet. For example, Microsoft uses the Internet address http://www.microsoft.com.

The choice, which you make for your personal or business domain name ...
Read More!

Notable Web Incorporated © 1996 - 2018. All Rights Reserved.