Category: Databases

1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. Click the Expand icon from the navigation tree in the left sidebar. 4. Scroll down and mark Check All. Then click on the drop-down arrow and select Repair table. If the table has been repaired successfully, it will show […]

1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. Click on the Expand icon from the navigation tree in the left sidebar. 4. Scroll down and mark Check All. Click on the drop-down option and select Optimize tables. The table has been successfully optimized.

1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. Click on the Expand icon from the navigation tree in the left sidebar. 4. Select the appropriate table you want to delete. If you’re going to delete table “wp_links”, choose it. 5. Now click on Operations. 6. Scroll down […]

1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. From the navigation tree in the left sidebar. Please select an appropriate database that you want to export to your computer 4. Click on Export. 5. Select SQL format and then click Export. SQL file will be downloaded within […]

1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. Click on the Expand icon from the navigation tree in the left sidebar. 4. Select the appropriate table you want to edit. If you wish to change the blog name of WordPress, then select “wp-options”. 5. Click on Edit […]

1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. From the navigation tree in the left sidebar, select an appropriate database in which you want to import data using the SQL file. 4. Click on Import. 5. Under File to import, click on Choose File and select SQL […]

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3. Scroll down to the end of the page and under Add User to Database. Select a user from the drop-down list, and choose a Database from the list. 4. Click on Add. 5. On Manage User Privileges. Mark […]

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3. Under MySQL Users, in the Username field, enter the new username you want to create. 4. Enter your new password or use a password generator.5. Click on Create a User. Tip: Write down the database username and password […]

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3. Under Current Databases, you can see a list of all your databases. Locate the database you want to remove and click on Delete. 4. Click on Delete Database.

1. Log in to your cPanel account. 2. In the Databases section, click on MySQL Databases. 3. Under Current Databases, you can see a list of all your databases. Locate the Database and then click on Rename.4. Change the database name and click on Proceed.