How To Reset MySQL Root Password In REDHAT 8.5
To Reset MySQL Root Password On REDHAT 8.5
Introduction:
MySQL is a well-known open-source relational database management system developed, distributed, and supported by Oracle Corporation which is used with PHP.
Step 1: Check the installed version of OS by using the below command
[root@linuxhelp ~]# cat /etc/os-release
NAME="Red Hat Enterprise Linux"
VERSION="8.5 (Ootpa)"
Step 2: Try to login MySQL as root user by using the below command
[root@linuxhelp ~]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Notes: am Forget my my sql password
Step 3: Stop MySQL Service by using the below command
[root@linuxhelp ~]# systemctl stop mysqld
Step 4: Run the below command to bypass MySQL authentication
[root@linuxhelp ~]# mysqld --skip-grant-tables --user=mysql &
[1] 35564
Step 5: Login MySQL server as a root user by using the below command
[root@linuxhelp ~]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Server version: 8.0.26 Source distribution
Step 6: Flush the Privileges by using the below command
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
Step 7: Alter the password for root user by using the below command
mysql> alter user 'root'@'localhost' identified by 'Linuxc#4';
Query OK, 0 rows affected (0.01 sec)
Step 8: Quit MySQL server by using the below command
mysql> \q
Bye
Step 9: Check the MySQL Background process by using the below command
[root@linuxhelp ~]# ps -aux
root 190 0.0 0.0 0 0 ? S 18:02 0:00 [irq/27-pciehp]
root 191 0.0 0.0 0 0 ? S 18:02 0:00 [irq/28-pciehp]
root 192 0.0 0.0 0 0 ? S 18:02 0:00 [irq/29-pciehp]
root 193 0.0 0.0 0 0 ? S 18:02 0:00 [irq/30-pciehp]
root 194 0.0 0.0 0 0 ? S 18:02 0:00 [irq/31-pciehp]
root 35289 0.0 0.0 0 0 ? I 18:27 0:00 [kworker/0:0-events_power_efficient]
mysql 35564 0.8 10.0 1814108 382488 pts/1 Sl 18:28 0:01 mysqld --skip-grant-tables --user=mysql
root 35695 0.0 0.0 7316 908 ? S 18:30 0:00 sleep 60
root 35732 0.0 0.1 61660 4112 pts/1 R+ 18:30 0:00 ps -aux
Step 10: Kill The MySQL Background process by using process id
[root@linuxhelp ~]# kill -9 35564
[1]+ Killed mysqld --skip-grant-tables --user=mysql
Step 11: Start the MySQL service by using the below command
[root@linuxhelp ~]# systemctl start mysqld
Step 12: Login MySQL as a root user by using the below command
[root@linuxhelp ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Step 13: Flush the privileges by using the below command
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
Step 14: Quit
mysql>\q
Bye
Conclusion:
We have reached the end of this article. In this guide, we have walked you through the steps required to Reset MySQL Root Password on REDHAT 8.5. Your feedback is much welcome.