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