How to reset MySQL root password on Linux Debian 11.3
To Reset MySQL Root Password On Debian 11.3
Introduction:
MySQL is a well-known open-source relational database management system developed, distributed, and supported by Oracle Corporation which is used with PHP.
Procedure:
Step 1: Check the installed version of OS by using the below command
[root@linuxhelp ~]# lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description: Debian GNU/Linux 11 (bullseye)
Release: 11
Codename: bullseye
No LSB modules are available.
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 mysql password
Step 3: Check the status from MySQL Service by using the below command
[root@linuxhelp ~]# systemctl status mysql
MySQL. Service - MySQL MySQL community-server
Loaded: loaded (/lib/system/system/MySQL. Service; enabled; vendor preset: >
Active: active (running) since Wed 2022-05-25 03:04:30 IST; 1 day 2h ago
Docs: man: MySQL(8)
https://mysql.com/kb/en/library/systemd/
Main PID: 782 (MySQL)
Status: "Taking your SQL requests now..."
Step 4: Stop MySQL Service by using the below command
[root@linuxhelp ~]# systemctl stop mysql
Step 5: Check the status from MySQL Service by using the below command
[root@linuxhelp ~]# systemctl status mysql
MySQL. Service - MySQL community-server
Loaded: loaded (/lib/system/system/MySQL. Service; enabled; vendor preset: >
Active: Inactivate (dead) since Wed 2022-05-25 03:04:30 IST; 1 day 2h ago
Docs: man: MySQL(8)
https://mysql.com/kb/en/library/systemd/
Main PID: 782 (MySQL)
Status: "Taking your SQL requests now..."
Step 6: Run the below command to bypass MySQL authentication by using the below command
[root@linuxhelp ~]# mysqld --skip-grant-tables --user=mysql &
[1] 34275
Step 7: 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 8: Flush the Privileges by using the below command
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)
Step 9: Alter the password for root user by using the below command
mysql> alter user 'root'@'localhost' identified by 'Linuxc#9';
Query OK, 0 rows affected (0.01 sec)
Step 10: Quit MySQL server by using the below command
mysql> \q
Bye
Step 11: 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 34275 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 12: Kill The MySQL Background process by using process id
[root@linuxhelp ~]# kill -9 34275
[1]+ Killed mysqld --skip-grant-tables --user=mysql
Step 13: Start the MySQL service by using the below command
[root@linuxhelp ~]# systemctl start mysqld
Step 14: Check the status from MySQL Service by using the below command
[root@linuxhelp ~]# systemctl status mysql
MySQL. Service - MySQL MySQL community-server
Loaded: loaded (/lib/system/system/MySQL. Service; enabled; vendor preset: >
Active: active (running) since Wed 2022-05-25 03:04:30 IST; 1 day 2h ago
Docs: man: MySQL(8)
https://mysql.com/kb/en/library/systemd/
Main PID: 782 (MySQL)
Status: "Taking your SQL requests now..."
Step 15: 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 16: Flush the privileges by using the below command
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
Step 17: 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 Debian 11.3. Your feedback is much welcome.