Follow these steps to optimize mysql from PLESK: Login to your Plesk panel. Under ‘Domains’ section, click on particular domain Click on ‘Databases’ option Click on ‘phpMyAdmin’ option for database you wish to optimize. Scroll down to the bottom and check the ‘Check all’ checkbox and click ‘Optimise table’ from the drop down menu beside …
Follow these steps to run or execute MySQL queries in cPanel using phpMyAdmin: Login to your cPanel account. Under the Databases section, select the phpMyAdmin icon. Select the database on which you want to run the query in the phpMyAdmin interface. Select the SQL tab. Enter the required MYSQL Queries in the SQL Editor and …
How to run / execute mysql queries using phpmyadmin in cPanel? Read More »
==> Please follow the below steps to create tables using PhpMyAdmin in cPanel: Login to cPanel account. Click on the MySQL Databases icon. Click on ‘phpMyAdmin’ option Select the database in which you want to create the table from the left-hand menu. Select the “Create Table” option. Enter the following information in the “Create Table” …
How to create a table using PhpMyAdmin in cPanel? Read More »
Please follow the below steps to check and repair MySQL database tables: Login to cPanel account. Click on the MySQL Databases icon. In the Modify Databases section, click on the Check Database or Repair Database button next to the database that you want to check or repair. If you are asked for a password, enter …
To change a database password from cPanel account, follow the steps below: Login to cPanel account. Select the ‘MySQL Database’ option. From ‘Current Users’ section, select desired user and click on ‘Change Password. Enter new password in ‘Password’ section and confirm the password from ‘Confirm Password’ fields and click on ‘Change Password’ button. The password …
Follow the steps below to optimise your database from your cPanel: Login in to your cPanel account. In the ‘Databases’ section, select the ‘phpMyAdmin’ option. On the left side, select the database name you want to optimise. Scroll down to the bottom and check the ‘Check all’ checkbox and select ‘Optimise table’ from the drop …
To delete a database from your cPanel account, follow the steps below: Login to your cPanel account Select the ‘MySQL Database’ option Select the database to be deleted from the ‘Current Databases’ section Click on ‘Delete’ in the row of the database name. You will be asked for confirmation, click on ‘Delete Database’ if you …
From your cPanel account login to phpMyAdmin section and follow the below steps to restore database. Select the database name from the left handside of window. Click on ‘Import’ option located at top of window. Under ‘File To Import’ section, click on ‘Choose File’ and select the backup file from your computer you wish to …
From your cPanel account login to phpMyAdmin section and follow the below steps to create database backups. Select the database name from the left handside of window Click on ‘Export’ option located at top of window You will find two options ‘Quick’ and ‘Custom’, select ‘Quick’ option, ‘Custom’ option allows you to select the specific …
Follow these steps to create a MySQL database in cPanel: >>Login to your cPanel account. >>Click on the option “MySQL Databases”. Enter a name for your database in the “Create New Database” section. Select the “Create Database” option as shown below. Once, the database is created it will show up in “Current Database” section as …
How To Create And Maintain MySQL Databases in cPanel? Read More »
