I have installed MySQL server in Ubuntu 12.04 and I forgot password for user named
How I can reset password for this user?
Easy steps to reset mySQL root password:
Check the version of
apt-cache policy mysql-server
and you will see string like this:
it means that you have a
mysql-server-5.5 installed in your system
sudo dpkg-reconfigure mysql-server-5.5 < version of mysql server
Change the password on this screen:
mysql -u root -p
You can read full answer by this link.