Here is my bash script to execute msyql command !/bin/bash tglblk=$(date –date=”8 days ago” +%Y-%m-%d) tglhapus=”$tglblk 23:00:00″ SQL=”DELETE FROM Events WHERE EndTime<=’$tglhapus’;” MYSQL_USER=”root” MYSQL_PASS=”” MYSQL_DB=”mydb” echo $SQL | mysql –user=$MYSQL_USER –password=$MYSQL_PASS $MYSQL_DB Then I put it into crontab to run at specific time.