Category: MySQL
How to Repair MySQL Database via cPanel ?
In this tutorial we will understand how to repair MySQL Database via cPanel. For this follow the steps as mention below :…
MySQL Max User Connections Error
Warning: mysql_connect() [function.mysql-connect]: User cPanel-user_site already has more than ‘max_user_connections’ active connections in /home/cPanel-user/public_html/general_lib/packages/cmf/v2/mysql.class.inc.php on line 2120 When accessing your website, you…
Steps to change the Database Engine of a MySQL Database Table
In this article you will understand how to change the Database engine of a MySQL database table. The database engine is a…
How to Drop Columns from a Database Using phpMyAdmin?
With phpMyAdmin, users will create alterations to their MySQL and MariaDB databases. This tool is available on cPanel, Plesk and DirectAdmin additionally.…
Learn to Empty a MySQL Database in Simple Steps
You can empty the content of a MySQL database Using phpMyAdmin or SSH. But you have to make sure that you take…
How to Modify Database User Privileges in Plesk Panel?
Privileges grant users the flexibility to change and manage databases. You’ll reassign or modify the Maria dB database user privileges with Plesk.…
Learning About information_schema Database
There is an extra database named as information_schema within the MySQL version 5.02. You’ll be able to notice this database in cPanel…
How to Restart MySQL Server from WHM?
If you’ve have made some configurations like applying an update to the software or a rolling restart of the server you may…
How to Grant all Privileges to a User in MySQL with cPanel?
In a database The MySQL privilege system authenticates a user to make specific changes. Supported the privileges granted, a user will carry…
How to Enable Remote MySQL in the Domain cPanel Interface?
In cPanel servers, remote MySQL connections are disabled by default as they’re considered as a potential security threat. it’s possible to add…