SmartVPS - the complete multi-account hosting solution! Each individual account comes with free backups, addon domains, PHP-FPM with OPcache and server-side caching for lightning-fast sites. And all this at a great price!
75% OFF ALL NEW PLANS + 100-DAY MONEY-BACK GUARANTEE
75% OFF ALL NEW PLANS

Deleting a MySQL database/user

You can delete MySQL 5 and MySQL 8 databases and users only through the MySQL Databases section of the hosting Control Panel.

Note: The MySQL 5 and MySQL 8 servers are separate and do not share databases or users, so if you have two databases or users for MySQL 5 and MySQL 8 with the same name and delete one of them, the other one will not be deleted.

Deleting a MySQL database

To delete a MySQL database, you need to follow these steps:

  1. Log in to your hosting Control Panel.
  2. Enter the MySQL Databases section.
  3. Navigate to the Databases tab.
  4. Select the MySQL version of your database from the MySQL version drop-down menu.
  5. Click on the Delete button next to the database you wish to delete.
  6. Click OK in the confirmation window.

Note: MySQL users that were associated only with the deleted database will not get deleted automatically. You should delete such MySQL users manually.

Deleting a MySQL user

You can delete a MySQL user by following these steps:

  1. Log in to your hosting Control Panel.
  2. Enter the MySQL Databases section.
  3. Navigate to the MySQL users tab.
  4. Select the MySQL version of your database from the MySQL version drop-down menu.
  5. Click on the Delete (cancel_a.png) button next to the MySQL user you wish to delete.
  6. Click OK in the confirmation window.