Mysqldump launched by cron and password security

by

Quoting the MySQL docs(http://dev.mysql.com/doc/refman/5.1/en/password-security-user.html):

Store your password in an option file. For example, on Unix you can list your password in the [client] section of the .my.cnf file in your home directory:

[client]
password=your_pass

To keep the password safe, the file should not be accessible to anyone but yourself. To ensure this, set the file access mode to 400 or 600. For example:

shell> chmod 600 .my.cnf

To name from the command line a specific option file containing the password, use the --defaults-file=file_name option, where file_name is the full path name to the file.

More Related Contents:

  1. #1071 – Specified key was too long; max key length is 1000 bytes
  2. How can I access the MySQL command line with XAMPP for Windows?
  3. How can I get rid of these comments in a MySQL dump?
  4. Are dynamic mysql queries with sql escaping just as secure as prepared statements?
  5. Restore the mysql database from .frm files
  6. script to convert mysql dump sql file into format that can be imported into sqlite3 db
  7. What characters have to be escaped to prevent (My)SQL injections?
  8. Reference: What is a perfect code sample using the MySQL extension? [closed]
  9. Are table names in MySQL case sensitive?
  10. MySQL: is a SELECT statement case sensitive?
  11. 1114 (HY000): The table is full
  12. UPDATE multiple tables in MySQL using LEFT JOIN
  13. How to raise an error within a MySQL function
  14. What is maximum query size for mysql?
  15. Finding all parents in mysql table with single query (Recursive Query)
  16. How do I retrieve my MySQL username and password?
  17. How to execute a MySQL command from a shell script?
  18. Select most common value from a field in MySQL
  19. Returning the ‘last’ row of each ‘group by’ in MySQL
  20. How does a MYSQL Self-Join Work?
  21. How to change the default port of mysql from 3306 to 3360
  22. Is it possible to reference one column as multiple foreign keys?
  23. No Entity Framework provider found for ‘MySql.Data.MySqlClient’ ADO.NET provider
  24. Split a string and loop through values in MySQL stored procedure
  25. MySQL Select Query – Get only first 10 characters of a value
  26. Create an index on a huge MySQL production table without table locking
  27. MySQL concurrency, how does it work and do I need to handle it in my application
  28. mysql select id and name from other table and join query
  29. Detecting utf8 broken characters in MySQL
  30. django cannot connect mysql in docker-compose

Leave a Comment