xxxxxxxxxx
UPDATE users
SET password = 'new_password'
WHERE user_id = '123';
xxxxxxxxxx
1) sudo mkdir -p /var/run/mysqld
2) sudo chown mysql:mysql /var/run/mysqld
3) sudo chmod 755 /var/run/mysqld
4) sudo mysqld_safe --skip-grant-tables &
5) mysql -u root
6) ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
7) FLUSH PRIVILEGES;
xxxxxxxxxx
sudo service mysql stop
sudo mysqld_safe --skip-grant-tables&
mysql -u root