‘service mysql’ stop
wait until MySQL shuts down. Then run
mysqld_safe –skip-grant-tables &
then you will be able to login as root with no assword.
mysql’ ‘-uroot mysql
In MySQL command line prompt issue the following command:
UPDATE user SET password=PASSWORD(abcd ») WHERE ser= »root »;
FLUSH’ ‘PRIVILEGES;
EXIT
/etc/init.d/mysqld restart
At this time your root password is reset to »abcd » and MySQL will ow
know the privileges and you’ll’ ‘be able to login with your new password:
mysql -uroot -p
taper »abcd » »’
