- Mysql root password forgotment solution
1. First stop mysql # /etc/init.d/mysql stop 2. Start mysql # mysqld_safe --skip-grant-table & 3. Change root password 123456 # mysql mysql mysql> Update User Set Password = Password (/ '123456 /') Where user = / 'root /'; mysql> flush privileges; mysql> exit 4. Stop mysql again Run Killall MySQLD # / etc / init.d / MySQL Start # mysql -u root -p Enter Password:
