This article describes how to grant a user all privileges in MySQL. The MySQL privilege system allows a user to make particular modifications to a database after they have been verified. A user can perform database actions such as INSERT, SELECT, DELETE and UPDATE, based on the abilities allowed in cPanel. To give a user …
How to Grant all Privileges to the User in cPanel Read More »
This tutorial will explain how to optimize and repair MySQL Database using phpMyAdmin in cPanel. Why Optimise and Repair MySQL Database? Before moving further on the process of optimizing and repairing the MySQL database let us understand why it is necessary to do so: 1. Databases develop to a considerable extent when a website receives …
Why & How to Optimise & Repair MySQL Database using phpMyAdmin in cPanel Read More »
The process of changing MySQL database user password from cPanel is described in this article. Let’s follow the steps to change the MySQL database user password from cPanel: 1. Enter in your cPanel account. 2. You will enter into the cPanel homepage. Select the “Database” section and click on the “MySQL Databases” icon from it. …
How to change MySQL database user’s password from cPanel Read More »
Introduction The root MySQL user’s password needs to be changed if an error takes place in the WHM or cPanel as shown below. In this KB, we have outlined simple steps to change the password. The error you might encounter in cPanel & WHM is: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: …
How to change the password of the MySQL root user Read More »