Category Archives:
MySQL Archives - Page 3 of 4 - OWS KB

In this tutorial we will understand how to repair MySQL Database via cPanel. For this follow the steps as mention below : To Repair MySQL Database via cPanel 1. Log in to your cPanel account. 2. Go to the DATABASES section and click on MySQL® Databases. 3. Find the Modify Databases section and select the database from the drop-down list of […]

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 might face the error as above. This is due to the limitation of MySQL max user connections on the server. To fix the above error you will have to increase the max user […]

In this article you will understand how to change the Database engine of a MySQL database table. The database engine is a component of the Database Management System (DBMS) and it can create, read, update and delete data from a database. Follow the below steps to change the database engine : Method 1 : 1) […]

With phpMyAdmin, users will create alterations to their MySQL and MariaDB databases. This tool is available on cPanel, Plesk and DirectAdmin additionally. You’ll be able to even delete columns from a database via phpMyAdmin. Following are the simple steps to Drop Columns from a Database Table via phpMyAdmin : Step 1. Log in to your […]

You can empty the content of a MySQL database Using phpMyAdmin or SSH. But you have to make sure that you take a backup of your database (phpMyAdmin or SSH) before making any changes to your databases. Empty a MySQL Database Using phpMyAdmin As compared to other ways this is the easiest way to empty […]

Privileges grant users the flexibility to change and manage databases. You’ll reassign or modify the Maria dB database user privileges with Plesk. To Modify Database User Privileges follow the easy steps as given below: 1. Log in to your Plesk using login details. 2. From the navigation menu Select Databases . In your Plesk account, […]

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 >> Databases >> phpMyAdmin. It permits you to access the database information for corresponding user. information_schema database stores the information concerning all alternative databases. For instance, data type of columns, a database or […]

In a database The MySQL privilege system authenticates a user to make specific changes. Supported the privileges granted, a user will carry functions like SELECT, INSERT, UPDATE, DELETE etc. on the database. you’ll be able to access this method in cPanel. To Grant all Privileges in MySQL with cPanel follow the steps as below: Step […]

In cPanel servers, remote MySQL connections are disabled by default as they’re considered as a potential security threat. it’s possible to add remote hosts with the help of tools within the domain-level cPanel interface that the server permits to connect to the MySQL service. Prior to using the subsequent technique, you’ll have to be compelled […]