KNOWNHOST KNOWLEDGE BASE

Hosting Question? Find the Solution - Browse our Guides, Articles, and How-To's

How to reset the MySQL root password?

Category: cPanel
Tags: # # #

DBAs (Database Administrators) need to have root-level access to MySQL; sometimes, you might need to change the MySQL password for security or other reasons. In this article, you will learn how to reset the MySQL root password? Using WHM Panel 1. First, login into WHM panel, https://your-domain.com:2087 or https://IP-address: 2087 or https://server-hostname: 2087. 2. Navigate to SQL Services → MySQL Root Password. […]

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 […]

How to backup MySQL Database using cPanel?

Category: cPanel
Tags: # # #

Frequent backups of your MySQL databases should be at the top of your priority list, especially if you have an extremely active dynamic website. This article will cover how to create MySQL Database Backups via the cPanel interface. Learn, how to backup MySQL database using cPanel interface? 1. Log in to cPanel using Username & Password. i.e; (https://yourdomain.com:2083 or https://yourdomain.com/cpanel) […]

How to create a MySQL Database in DirectAdmin?

Category: DirectAdmin
Tags: # # #

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 […]

How to change a MySQL users password in cPanel?

Category: cPanel
Tags: # # # # # #

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 […]

How to connect to MySQL Remotely in cPanel?

Category: cPanel
Tags: # # # # #

If you’re a developer and want to access the MySQL database remotely from your local system. In that case, cPanel offers Remote MySQL functionality through which you need to allow your IP to get started. Allow Remote Connections 1. Log in to cPanel using Username & Password. i.e; (https://yourdomain.com:2083 or https://yourdomain.com/cpanel) 2. Navigate to Databases → Remote MySQL®. 3. Provide […]

How to create MySQL Database and User in cPanel?

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 Manage WordPress Users

Category: WordPress
Tags: # # # # #

How to Reset a WordPress Users Password using SQL? You can quickly set a WordPress users password to the new ‘somenewpassword’ text as seen below, assuming that the user login is ‘theirusername’. Change the username and password to whatever you’d like and execute the query. How to Get a List of Subscribers? The below example […]

MySQL/MariaDB It is very simple to set up remote connections in MySQL/MariaDB thanks to the WHM and cPanel interfaces. You will need to known advance what IP/hostname, or IPs/hostnames, require database access because you will need to specify them in the panel. If your IP is dynamic, you may be able to inquire your ISP […]