Hosting Question? Find the Solution -

KNOWNHOST KNOWLEDGE BASE

Browse our Guides, Articles, and How-To's

WordPress is an open-source content management system. It is more popular due to versatility and the community contribution towards wordpress to make it a multipurpose platform. In some cases, WordPress might get affected by malicious code/plugin leading to a whole cPanel compromise; in that case, we always recommend removing the affected plugins, themes and the […]

You might have interacted with the PhpMyAdmin to manage the database tables, repair the database table, and for many small tasks. Before that, we will learn more about how to check the MySQL version and how to repair and create a table using PhpMyAdmin? Check MySQL Version MySQL is the most popular Relational Database Management […]

JetBackup is a suitable and ready-to-use backup functionality that KnownHost offers with the web hosting services*. If you have web hosting services with us, you will most likely see Jetbackup 5 option within the control panel. Learn, How to restore Database backup using JetBackup 5? 1. Log in to cPanel using Username & Password. i.e; (https://yourdomain.com:2083 or https://yourdomain.com/cpanel) 2. Navigate to Files → JetBackup 5. 3. To view […]

MySQL users are used to connect to MySQL Databases in all sorts of different website based applications. Within cPanel this is performed by tying a MySQL user to a MySQL database in which that user will then authenticate to connect and access that database. Sometimes, you may find that you need to change the password […]

How to repair MySQL database in cPanel?

Category: cPanel
Tags: # # # #

Databases in MySQL can sometimes be fickle as the tables within the database grow in size. As this happens you may experience table errors or corruption that cause issues with your website loading properly. The first thing you should attempt to do is repair the database and see if that corrects the issue. cPanel provides […]

Creating a MySQL database, User, and assigning that User to the Database through a command-line interface may get tricky for newbies who don’t know of it. Through cPanel, this job gets easier. All you have to do is perform some informed clicks and VOILA! You’re good to go! How to create a MySQL Database? 1. […]

Option 1: Login to phpMyAdmin, highlight your database and browse the tables. Check the “Type” column to see what type of tables they are… Option 2: Use phpMyAdmin SQL tab and run the query to find the tables that might still be MyISAM: Why Change WordPress Database from MyISAM to InnoDB? Depending on when you […]