I lost mysql admin (root user) password. How do I reset a lost MySQL admin (root) password under UNIX or Linux or BSD operating systems?
Type the following commands. First, stop current MySQL database server:
/etc/init.d/mysql stop
OR
/etc/init.d/mysqld stop
OR
/usr/local/etc/rc.d/mysql-server stop
Now, start mysql server without password so that you can restart the password:
mysqld_safe --skip-grant-tables &
Login without a password, enter:
mysql -u root
Finally, setup a new MySQL root user password, enter::
USE mysql; UPDATE USER SET password=PASSWORD("NEW-ROOT-PASSWORD") WHERE USER='root'; FLUSH privileges; quit
Replace NEW-ROOT-PASSWORD with actual password you want to use. Restart running mysql server:
/etc/init.d/mysql restart
Test it:
mysql -u root -p
🐧 2 comments so far... add one ↓
Category | List of Unix and Linux commands |
---|---|
File Management | cat |
Firewall | Alpine Awall • CentOS 8 • OpenSUSE • RHEL 8 • Ubuntu 16.04 • Ubuntu 18.04 • Ubuntu 20.04 |
Network Utilities | dig • host • ip • nmap |
OpenVPN | CentOS 7 • CentOS 8 • Debian 10 • Debian 8/9 • Ubuntu 18.04 • Ubuntu 20.04 |
Package Manager | apk • apt |
Processes Management | bg • chroot • cron • disown • fg • jobs • killall • kill • pidof • pstree • pwdx • time |
Searching | grep • whereis • which |
User Information | groups • id • lastcomm • last • lid/libuser-lid • logname • members • users • whoami • who • w |
WireGuard VPN | Alpine • CentOS 8 • Debian 10 • Firewall • Ubuntu 20.04 |
sir would you help me sir , i have problem with using ubuntu
its my brother 6years old have changing my user privileges and set its none , i also cant goes as a root ,(crying)ehm i dont know how to set it back also i cant us my password in terminal to sudo su , its wont work did you know how i can get its back without reinstalling ?
please help me sir
thanks
Thanks alot!