This article explains how to remove a remote server’s access to your database. cPanel allows remote servers or applications to access databases hosted on your account. You can manage this…
Category: MySQL
How to Drop the Table using PhpMyAdmin
May 12, 2023 / MySQLIn this tutorial, we will show you how to use phpMyAdmin to permanently delete tables from a database. Important: Dropping a table permanently deletes all its data and cannot be undone.…
How to manage a MySQL database with phpMyAdmin
May 11, 2023 / MySQLThe main purpose of phpMyAdmin is to manage your databases. You can import, export, drop, edit, and create new tables for MySQL databases with this tool. You may also execute…
How to clear a MySQL database
May 1, 2023 / MySQLIn this article, we will explain how to clear your MySQL database with the help of two different ways: SSH and phpMyAdmin. Using SSH Here, we will use SSH to…
How can a MySQL database be wiped out using cPanel
April 10, 2023 / MySQLThis article explains how to wipe out a MySQL database in cPanel. Follow the steps: Log in to cPanel. Select the “Databases” section and click on the “phpMyAdmin” sub-option. Select…
How to disable the parent directory’s rewrite rules for some subfolders
April 6, 2023 / MySQLIn this article, we have explained how to disable the parent directory’s rewrite rules for some subfolders. Many content management systems offer a default.htaccess file with SEO-friendly rewrite rules, including…
How to rename MySQL database through cPanel
March 1, 2023 / MySQLIn this guide, you will discover how to rename a MySQL database through cPanel. Renaming a MySQL database through cPanel can help you stay organised, secure, and efficient when managing…
How to Backup a MySQL Database Using phpMyAdmin
February 24, 2023 / MySQLThis article explains how to back up a MySQL database or selected tables using phpMyAdmin via cPanel. This method is useful when you need a full database backup or only…
How to rebuild an RPM database via WHM and command line
December 23, 2022 / MySQLThis tutorial will teach you how to rebuild an RPM database via WHM and the command line. When a crash event happens for an RPM or YUM transaction that…
How to reduce/shrink the SQL server database size
October 14, 2022 / MySQLIn this article, we explain how to reduce or shrink the SQL Server database size safely and effectively. Important Instructions Before Shrinking the Database: You cannot shrink a database while…
How to backup a MySQL database using cPanel
September 12, 2022 / MySQLThis article explains how to back up a MySQL database using cPanel. Creating regular database backups ensures that your data remains safe in case the database is accidentally deleted, becomes…
How to add a remote host to access MySQL® databases in cPanel
August 2, 2022 / MySQLThis tutorial explains the way to add a remote host in cPanel so that your MySQL® databases can be accessed by external servers or applications. The IP address or hostname…
How to add a user to a MySQL database in cPanel
July 18, 2022 / MySQLThis guide will explain to you how to add a user to a MySQL database in cPanel. MySQL databases are necessary to run many web-based applications, such as bulletin boards,…
How to change the password for a MySQL database user in cPanel
December 16, 2021 / MySQLChanging the password for a MySQL database user in cPanel enhances security, prevents unauthorised access, and resolves login issues. We will show you how to change a MySQL database user’s…