=== Mysql DB backup script===
  
  * root@btm:/usr/local/bin# cat xxx-DB.sh
  * #!/bin/bash
  * # Database credentials
  * user="bkupdb"
  * password="p*Bu_$]QSd8K"
  * host="localhost"
  * db_name="service_quiz"
  * #
  * # Other options
  * backup_path="/var/backup/xxx-DB"
  * date=$(date +"%b-%d-%Y")
  * #
  * # Set default file permissions
  * umask 177
  * #
  * # Lock the database and sleep in background task
  * mysql --user=$user --password=$password -e "FLUSH TABLES WITH READ LOCK; DO SLEEP(3600);" &
  * sleep 3
  * #
  * # Dump database into SQL file
  * mysqldump --user=$user --password=$password --host=$host --opt $db_name | gzip > $backup_path/$db_name-$date.sql.gz
  * #
  * # When finished, kill the previous background task to unlock
  * kill $! 2>/dev/null
  * wait $! 2>/dev/null
  * 
  * echo "Finished export, and unlocked !"


''vi /etc/my.cnf without pass mysql login''

  * # add below to vi /etc/my.cnf and reboot mysql then try to login  mysql -p -u root
  * 
  * [mysqld]
  * #skip-grant-tables
  *