The MySQL Access Hosts tool within WHM enables you to designate specific hostnames and IP addresses for automatic inclusion across all users and databases on your server. Follow the steps:…
Category: MySQL
How to import and export a MySQL database in cPanel
October 27, 2023 / MySQLIn this article, we will provide you with step-by-step instructions for importing and exporting your MySQL database using cPanel and phpMyAdmin. Before we begin, please ensure that you have already…
How to access phpMyAdmin in cPanel
July 3, 2023 / MySQLphpMyAdmin is a web-based tool in cPanel that allows you to manage MySQL databases through a browser. This article explains how to access phpMyAdmin in cPanel to view, edit, and…
How to Revoke Privileges from a MySQL User
May 9, 2023 / MySQLThis article explains how cPanel users can revoke database privileges from a MySQL user using either the cPanel interface or the MySQL command line. Method 1: Revoke Privileges via cPanel…
How to create a table using phpMyAdmin
May 8, 2023 / MySQLIn this tutorial, we will explain how to create a table using phpMyAdmin. Let’s look into how to build a table in a database using phpMyAdmin. Log in to your…
How to check the size of MySQL database using phpMyAdmin
May 7, 2023 / MySQLIn this article, we will explain how to check the size of a MySQL database using phpMyAdmin. There are several reasons to check the size of the MySQL database, but…
How to set up an MySQL/MariaDB database with Plesk
April 19, 2023 / MySQLThis guide will explain to you how to set up a MySQL/MariaDB Database with Plesk. MySQL stands for Microsoft SQL Server; it is a relational database management system. To set…
How to set privileges to a MySQL user account in cPanel
March 22, 2023 / MySQLThis article explains how to set and manage privileges for a MySQL user account in cPanel. Assigning the correct permissions helps ensure database security and allows users to perform only…
How to rename MySQL database through cPanel
March 11, 2023 / MySQLThis article explains how to rename a MySQL database through cPanel. MySQL is a popular open-source relational database management system (RDBMS) that uses Structured Query Language (SQL) for managing data.…
How to modify the collation for a table using phpMyAdmin in cPanel
March 10, 2023 / MySQLIn this article, you will learn how to modify the collation for a table using phpMyAdmin in cPanel. A collation is a set of rules that defines how to relate and…