Is there any to recover lost mysql password? I forgot my root password for mySQL database and i want to know the instructions to recover it.
Is there any to recover lost mysql password? I forgot my root password for mySQL database and i want to know the instructions to recover it.
- Stop the MySQL service :
Code:- # /etc/init.d/mysql stop
- Start the MySQL server w/o password :
Code:- # mysqld_safe --skip-grant-tables &
- Connect to the MySQL server using the MySQL client :
Code:# mysql -u root- Change root password :
Code:- UPDATE user SET password = password('.......') WHERE user = 'root' AND host='localhost'; (type the new password instead of dots)
- Stop MySQL server :
Code:# /etc/init.d/mysql stop
Access 9X Database Password 1.0 : Access 9X Database Password can instantly recover any MS Access 95/97 (MS Jet 3.0/3.5) database password. You can use standard shortcut keys and menus to select, copy and paste the password.
Download Access 9X Database Password 1.0
Bookmarks