force update the mysql root credential

force_update_mysql_root_credential.txt

# bismillah, shollallahu 'alaa Muhammad
# force update the mysql root credential
# 
# mysql  Ver 14.14 Distrib 5.7.30 
# on macos10.14 (x86_64)

# step 1 : find and kill the PID of the mysql process
ps aux | grep mysqld
kill -9 [PID]

# step 2 : entering mysql console
sudo mysqld_safe --skip-grant-tables --skip-networking
mysql -uroot

# step 3 : update root credential
update mysql.user set authentication_string=password('YOUR_NEW_PASSWORD') where user='root';
flush privileges;