Techie Corner

If you execute mysqldump manually, mysqldump will prompt you for password. If you setup mysqldump via cronjob, you need to find a solution to disable the password. I’ve setup mysqldump to backup my db via cronjob without password. All you need to do is just to add a file in your home directory and it will disable the mysqldump password prompting.

To setup mysqldump without password in Cronjob, follow the steps below:-

• Start your terminal and login to your server
• Create a .my.cnf file in the home directory
  
  vi ~/.my.cnf

  1	vi ~/.my.cnf

• Copy the content below and replace with your mysql username and password.
  
  [mysqldump] user = mysqluser password = secret

  1 2 3

  [mysqldump] user = mysqluser password = secret

• Now change the file permission to 600 to prevent other user from reading it
  
  chmod 600 ~/.my.cnf

  1	chmod 600 ~/.my.cnf

• Now you can try to execute mysqldump and system will not prompt you for password by now
• To setup the cronjob
  
  crontab -e

  1	crontab -e

  
  Append the line below to your crontab and it will run mysqldump every night at 12:00am
  
  0 0 * * * mysqldump -u mysqluser -h localhost --all-databases | gzip -9 > alldb.sql.gz > /dev/null

  1	0 0 * * * mysqldump -u mysqluser -h localhost --all-databases | gzip -9  > alldb.sql.gz > /dev/null

* for more information on mysql backup, refer to how to backup mysql database

Tags: backup mysql, MySQL Database, mysql dump without password, mysqldump, mysqldump disable password, mysqldump no password, mysqldump without password