mysql-passwordless

#Create user backup
mysql -u root -p
CREATE USER 'backup'@'localhost' IDENTIFIED BY 'passrahasia';
GRANT SELECT, SHOW VIEW, RELOAD, REPLICATION CLIENT, EVENT, TRIGGER ON *.* TO 'backup'@'localhost';
#myisam
GRANT LOCK TABLES ON *.* TO 'backup'@'localhost’;
nano ~/.my.cnf
[mysql]
user=root
password=passroot

[mysqldump]
user=backup
password=passrahasia