Reset MySQL Root Password on Red Hat Enterprise Linux 8 - Step by Step Process ?
This article covers how to reset or change your MySQL root password on Red Hat Enterprise Linux 8.
MySQL is an open source relational database management system (RDBMS) with a client-server model for creating and managing databases based on a relational model.
To Reset the MySQL root password:
You must run the commands in the following steps as the root user.
Therefore, you can either log in directly as the root user (which is not recommended for security reasons), or use the su or sudo commands to run the commands as the root user.
To reset the root password for MySQL, follow these steps:
1. Log in to your account using SSH.
2. Stop the MySQL server using the appropriate command for your Linux distribution:
For CentOS and Fedora, type:
$ service mysqld stopFor Debian and Ubuntu, type:
$ service mysql stop3. Restart the MySQL server with the —skip-grant-tables option. To do this, type the following command:
$ mysqld_safe --skip-grant-tables &4. Log into MySQL using the following command:
$ mysql5. At the mysql> prompt, reset the password. To do this, type the following command, replacing new-password with the new root password:
UPDATE mysql.user SET Password=PASSWORD('new-password') WHERE User='root';6. At the mysql> prompt, type the following commands:
FLUSH PRIVILEGES;
exit;7. Stop the MySQL server using the following command.
You will be prompted to enter the new MySQL root password before the MySQL server shuts down:
$ mysqladmin -u root -p shutdown8. Start the MySQL server normally. To do this, type the appropriate command for your Linux distribution:
For CentOS and Fedora, type:
$ service mysqld startFor Debian and Ubuntu, type:
$ service mysql start
Fix VM created using a User Template not booting in OnApp
This article covers how to fix VM created using a User Template not booting issue in OnApp.
Install DirectAdmin in ec2 - A step by step guide ?
This article covers the steps involved in installing DirectAdmin in EC2. In fact, An EC2 instance is nothing but a virtual private server in Amazon Web Services terminology. It stands for Elastic Compute Cloud server. It is a web service where an AWS subscriber can request and provision a compute server in AWS cloud.
"Disk is full" Acronis error - How to fix it ?
This article covers methods to fix the "Disk is full" Acronis error. This is also known as the Acronis True Image: Backup Fails with "Disk is full" Or "Write error".
Virtualmin System is not setup to use itself as a DNS server - Ways to fix it ?
This article covers method to resolve the error, Virtualmin System is not setup to use itself as a DNS server. In fact, this error happens as a result of changes in your IP address being obtained by DHCP. By default, the DHCP client will set a number of things, including the DNS servers.
Virtualmin is configured to setup DNS zones, but this system is not setup to use itself as a DNS server. Either add 127.0.0.1 to the list of DNS servers, or turn off the BIND feature on the module config page.
Quota not working in Virtualmin - How to fix this issue ?
This article covers methods to fix Quota not working in Virtualmin for our customers. In fact, Quotas are used to limit the amount of disk space a user or group can use on a filesystem. Without such limits, a user could fill up the machine’s disk and cause problems for other users and services.
How to install Quota Tools on Ubuntu ?
To set and check quotas, we first need to install the quota command line tools using apt. Let’s update our package list, then install the package:
$ sudo apt update
$ sudo apt install quota
You can verify that the tools are installed by running the quota command and asking for its version information:
$ quota --version
How to enable Quotas on Ubuntu ?
Before finally turning on the quota system, we need to manually run the quotacheck command once:
$ sudo quotacheck -ugm /
This command creates the files /aquota.user and /aquota.group.
- u: specifies that a user-based quota file should be created.
- g: indicates that a group-based quota file should be created.
- m: disables remounting the filesystem as read-only while performing the initial tallying of quotas. Remounting the filesystem as read-only will give more accurate results in case a user is actively saving files during the process, but is not necessary during this initial setup.
