How to reset mysql password?

Question

MySQL

Doing: sudo service mysql stop
then: sudo mysqld --skip-grant-tables --user=root , after that:
mysql -u root and :
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/ var/run/mysqld/mysqld.sock' (2)
What is the reason? If you do sudo service mysql start, it connects, but you can't log in due to an incorrect password.

Answer 1

Try: mysqladmin -u root password NEWPASSWORD
If it doesn't help: https://www.cyberciti.biz/tips/recover-mysql-root-...

Answer 2

sudo service mysql stop
sudo dpkg-reconfigure mysql-server-5.5
sudo service mysql start