First kill the running mysql service:
kill `cat /var/run/mysqld/mysqld.pid`
Now, start mysql without permission tables:
mysqld_safe --skip-grant-tables &
Now start mysql as root without password:
mysql -u root
Now, within mysql import password tables and change the password:
mysql> FLUSH PRIVILEGES; mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass'); mysql> FLUSH PRIVILEGES;
Now, kill the running mysql service and restart the service:
service mysql restart
Joel G Mathew, known in tech circles by the pseudonym Droidzone, is an opensource and programming enthusiast.
His favorite pastime is grappling with GNU compilers, discovering newer Linux secrets, writing scripts, hacking roms, and programs (nothing illegal), reading, blogging. and testing out the latest gadgets.
When away from the tech world, Dr Joel G. Mathew is a practising ENT Surgeon, busy with surgeries and clinical practise.