patternsqlMinor
mysql backup password without root home
Viewed 0 times
withoutpasswordmysqlroothomebackup
Problem
What's the best way to provide a MySql root password (
the server I'm using is centos
~/.my.cnf) to cron job without root to have the home folder?the server I'm using is centos
Solution
What's the best way to provide a MySql ... password
Using a separate configuration file, as described in the Manual.
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.
Using a separate configuration file, as described in the Manual.
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.
Context
StackExchange Database Administrators Q#310555, answer score: 3
Revisions (0)
No revisions yet.