How to Reset MySQL Password Where Database is Running on Linux
This article will show you how to reset MySQL password
Stop CruzOC services:
sudo service oware stop
sudo service synergy stop
sudo service owaredb stop
Create restore password file:
echo "ALTER USER 'root'@'localhost' IDENTIFIED BY 'dorado';" > /home/synergy/restore_root_password.sql
Start mysql with restore password file:
mysqld --secure_file_priv=/home/synergy --init-file=/home/synergy/restore_root_password.sql &
Wait until mysql starts
Bounce VM
Confirm mysql password has been updated
mysql -u root -pdorado