Reset MYSQL PASSWORD

reset_mysql_root_password.sh

#!/usr/bin/env bash

# Resetting mysql default password

NEW_PASSWORD='password'

su root
systemctl stop mysqld
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables --skip-networking"

echo "FLUSH PRIVILEGES;ALTER USER 'root'@'localhost' IDENTIFIED BY '$NEW_PASSWORD';" > refresh_user.sql
mysql -uroot < refresh_user.sql
rm refresh_user.sql
systemctl unset-environment MYSQLD_OPTS
systemctl restart mysqld