if [ -z "$1" ] && [ -z "$2" ]; then
  read -sp "Old Password: " oldPassword
  read -sp "New Password: " newPassword
else
  oldPassword="$1"
  newPassword="$2"
fi

mysql -uroot -p${oldPassword} -e "SET PASSWORD FOR root@'localhost' = PASSWORD('$newPassword');"