{"id":1183,"date":"2021-04-07T15:55:25","date_gmt":"2021-04-07T12:55:25","guid":{"rendered":"https:\/\/www.scalahosting.com\/kb\/?p=1183"},"modified":"2023-03-01T16:49:46","modified_gmt":"2023-03-01T14:49:46","slug":"how-to-create-or-delete-a-mysql-database-or-user","status":"publish","type":"post","link":"https:\/\/www.scalahosting.com\/kb\/how-to-create-or-delete-a-mysql-database-or-user\/","title":{"rendered":"How to Create or Delete a MySQL Database or User"},"content":{"rendered":"

Databases are designed to store essential details and information across a set of tables <\/span>controlled by a Database Management System<\/b> (DBMS). <\/span><\/i>MySQL is one of the most popularly used Database Management Systems.\u00a0<\/span><\/p>\n

It is a free-to-use software that provides the <\/span>stability, reliability, and security<\/b> required for an effective database management system. This article provides<\/span> a walkthrough process of creating or deleting a MySQL database or user.<\/b><\/p>\n

How To Create A MySQL Database<\/b><\/h2>\n

To create a <\/span>MySQL Database<\/b>, use the following steps:<\/span><\/p>\n

Login to your <\/span>Control Panel<\/b><\/p>\n

\"How<\/p>\n

Go to the <\/span>Databases <\/b>section. You can type in the keyword \u2018database\u2019 for an accessible location.<\/span><\/p>\n

Click on <\/span>MySQL Databases<\/b><\/p>\n

\"How<\/p>\n

Give your new database a name.<\/span><\/p>\n

\"How<\/p>\n

Click on the <\/span>Create Database<\/b> button.,<\/span><\/p>\n

\"How<\/p>\n

If you created your database successfully, a success message would be displayed. It will also add your new database will also be added to <\/span>the list of existing databases.<\/b><\/p>\n

How To Delete A MySQL Database<\/b><\/h2>\n

To delete a MySQL Database:<\/span><\/p>\n

Go to the <\/span>Existing Databases<\/b> section<\/span><\/p>\n

\"How<\/p>\n

Click the <\/span>Delete <\/b>button for the exact database you wish to delete<\/span><\/p>\n

\"How<\/p>\n

A confirmation box will pop up. Click on the <\/span>YES <\/b>button to confirm the delete action.<\/span><\/p>\n

\"How<\/p>\n

By doing this, you will successfully delete your database.\u00a0<\/span><\/p>\n

Creating A MySQL Database User<\/b><\/h2>\n

We create a MySQL database to provide additional security and authentication for your website\u2019s database. The user is assigned a login username and password, which differs from<\/span> the Windows login credentials and the <\/b>cPanel.<\/b><\/a>\u00a0<\/b><\/p>\n

Before any user, aside from the website owner, accesses a database, it would request the registered login credentials to validate its authenticity.\u00a0<\/span><\/p>\n

How To Create A MySQL Database User<\/b><\/h3>\n

To create a new MySQL Database User, follow these steps:<\/span><\/p>\n

    \n
  1. Login to your cPanel account<\/span><\/li>\n<\/ol>\n

    \"How<\/p>\n

    Go to the <\/span>Databases <\/b>section. You can type in the keyword \u2018database\u2019 for an accessible location. Click on MySQL Databases<\/span><\/p>\n

    \"How<\/p>\n

    2. Scroll to the <\/span>New MySQL User<\/b> section, Type in the <\/span>Username<\/b>, <\/span>Password <\/b>and <\/span>Repeat the Password<\/b><\/p>\n

    \"How<\/p>\n

    3. Click on the <\/span>Create User<\/b> button.<\/span><\/p>\n

    \"How<\/p>\n

    You have successfully created a new MySQL database user. This user account differs from that of a web and mail administrator account.<\/span><\/p>\n

    How To Delete A MySQL Database User<\/b><\/h2>\n

    When you wish to delete a database user:<\/span><\/p>\n

    Go to the <\/span>Existing MySQL Users<\/b> section and select the Username you wish to delete<\/span><\/p>\n

    \"How<\/p>\n

    Click the <\/span>Delete <\/b>button<\/span><\/p>\n

    \"How<\/p>\n

    Define User\u2019s Privileges<\/b><\/h2>\n

    Now that you have successfully created a new user account, it is vital to assign user privileges to determine the user\u2019s control level over the database. As a website owner, <\/span>you do not want to grant full database access to just anyone.<\/b><\/p>\n

    Assign Database User Privileges<\/b><\/h3>\n

    To assign privileges to a database user, follow these steps:<\/span><\/p>\n

    Login to your cPanel account<\/span><\/p>\n

    \"How<\/p>\n

    Go to the <\/span>Databases<\/b> section. You can type in the keyword \u2018database\u2019 for an accessible location. Click on <\/span>MySQL Databases<\/b><\/p>\n

    \"How<\/p>\n

    Scroll to the <\/span>Grant Access To Database<\/b> section<\/span><\/p>\n

    \"How<\/p>\n

    Select the user you would like to assign database privileges to and select the specific database assigned to the user.<\/span><\/p>\n

    \"How<\/p>\n

    Click on <\/span>Add user<\/b> to database<\/span><\/p>\n

    \"How<\/p>\n

    You have successfully assigned privileges to a database user.<\/span><\/p>\n

    Conclusion<\/b><\/h2>\n

    By following the step-by-step processes outlined in this article you have learned <\/span>how to create and delete databases.\u00a0<\/span><\/p>\n

    You have also learned<\/span>\u00a0<\/span>how to create MySQL database users and assign user privileges.\u00a0<\/b><\/p>\n

    If you encountered any hitches while setting up any of this processes, please leave a comment below and<\/span> we would be happy to help out.<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"

    Databases are designed to store essential details and information across a set of tables controlled by a Database Management System (DBMS). MySQL is one of the most popularly used Database Management Systems.\u00a0 It is a free-to-use software that provides the stability, reliability, and security required for an effective database management system. This article provides a […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_seopress_robots_primary_cat":"none","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[67],"tags":[],"class_list":["post-1183","post","type-post","status-publish","format-standard","hentry","category-getting-started"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/posts\/1183","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/comments?post=1183"}],"version-history":[{"count":6,"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/posts\/1183\/revisions"}],"predecessor-version":[{"id":5417,"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/posts\/1183\/revisions\/5417"}],"wp:attachment":[{"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/media?parent=1183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/categories?post=1183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.scalahosting.com\/kb\/wp-json\/wp\/v2\/tags?post=1183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}