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 […]
For storage of data for applications, you must need a Database. Traditionally we use a command-line interface for creating a database and assigning a user to it. In DirectAdmin, we can perform all the actions using the graphical user interface. Let’s see how to create and manage databases, users in DirectAdmin? How to create a […]
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 […]
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. […]
How to Change WordPress Default Admin Name? You’ve been reading about securing WordPress and figured it was time to change the default administrator name to something other than admin or Admin, in an effort to secure your site. In order to target your admin account and break in, a hacker will need to guess the […]
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 […]
How to Find WordPress Posts with the Most Spam Comments using SQL? The below query will help you identify the top 7 posts having the most comments that have been flagged as spam. How to Find WordPress Posts with the Most Comments using SQL? The below query will help you identify the top 7 posts […]