mysql backup password without root home



  • What's the best way to provide a MySql root password (~/.my.cnf) to cron job without root to have the home folder? the server I'm using is centos



  • What's the best way to provide a MySql ... password

    Using a separate configuration file, as described in https://oracle-base.com/articles/mysql/mysql-password-less-logins-using-option-files .

    What's the best way to provide a MySql root password

    You should not use any high-level credentials for Application connectivity. Not root, not mysql.
    Always created a dedicated account for your Application, grant it appropriate permissions, and use that.

    Why? You should always keep the Best Tools in the ToolBox for yourself - so that you can clean up the mess made by everybody else!

    ... without root to have the home folder?

    The Linux root account will always have access to the mysql home folder.
    By design, root must have access to everything.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2