Articles in this category
Adding MySQL Users to Databases
You can create MySQL users to help you organize your database management, giving each user access to specific databases and specific privileges. You can…
Allowing Remote Database Access
Remote database access may be needed for third-party apps but is disabled by default due to security risks. Learn when and how to enable…
Backing Up a MySQL Database
Protect your website data before making major changes. Learn how to manually back up your MySQL databases using cPanel, the command line, or Plesk.
Backup a Cloud Sites MSSQL Database Using a cron
Follow these steps to create a cron to back up your MSSQL databases.
Batch converting MySQL table engines
MySQL batch table engine conversion: MyISAM InnoDB. Get CLI scripts, rollback prep, & robust methods. *Always backup data first!*
Change a MySQL User Password
Changing MySQL passwords to something new and secure is easy via the command line.
Change a MySQL User Password via cPanel
If you aren't familiar with using the command line interface, using cPanel makes it easy to change MySQL user passwords.
Checking Your MySQL Version
If you are using MySQL databases, you might need to occasionally check the version of MySQL that is installed on your server. It's easy…
Creating a MySQL User
Control MySQL database access by creating user-specific restrictions for databases, tables, and privileges. Use cPanel or the command line to create MySQL users.
Deleting a MySQL Database
Deleting unused databases frees up space but the action is permanent! We strongly recommend backing up your database before you delete it, just in…
Deleting MySQL Users
If you are using MySQL databases with multiple users, you may need to control database access by deleting database users. You can delete MySQL…
How to Delete a MySQL Database in cPanel
Whether getting rid of an unneeded database or a corrupted one, this tutorial walks through how to delete a MySQL database in cPanel.