How to perform a mysqldump without a password prompt?

by

Since you are using Ubuntu, all you need to do is just to add a file in your home directory and it will disable the mysqldump password prompting. This is done by creating the file ~/.my.cnf (permissions need to be 600).

Add this to the .my.cnf file

[mysqldump]
user=mysqluser
password=secret

This lets you connect as a MySQL user who requires a password without having to actually enter the password. You don’t even need the -p or –password.

Very handy for scripting mysql & mysqldump commands.

The steps to achieve this can be found in this link.

Alternatively, you could use the following command:

mysqldump -u [user name] -p[password] [database name] > [dump file]

but be aware that it is inherently insecure, as the entire command (including password) can be viewed by any other user on the system while the dump is running, with a simple ps ax command.

More Related Contents:

  1. How to get a ranking result for special record in mysql [closed]
  2. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  3. How to reset AUTO_INCREMENT in MySQL
  4. MySQL Query GROUP BY day / month / year
  5. MySQL Server has gone away when importing large sql file
  6. How do I use on delete cascade in mysql?
  7. How to access remote server with local phpMyAdmin client?
  8. How to copy data from one table to another new table in MySQL?
  9. How to connect mysql workbench to running mysql inside docker?
  10. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
  11. Calculate the time difference between of two rows
  12. What’s the difference between using INDEX vs KEY in MySQL?
  13. MySQL/Writing file error (Errcode 28)
  14. mysql select top n max values
  15. MySQL Group By and Sum total value of other column
  16. MySQL : Multiple row as comma separated single row
  17. MySQL Trigger: Delete From Table AFTER DELETE
  18. Return a default value if single row is not found
  19. How to find out the MySQL root password
  20. Django – installing mysqlclient error: mysqlclient 1.3.13 or newer is required; you have 0.9.3
  21. Removing duplicates with unique index
  22. Getting number of rows inserted for ON DUPLICATE KEY UPDATE multiple insert?
  23. How to restrict a column value in SQLite / MySQL
  24. Does MySQL foreign_key_checks affect the entire database?
  25. How to connect locally hosted MySQL database with the docker container
  26. MySql Query Replace NULL with Empty String in Select
  27. What are the max number of allowable parameters per database provider type?
  28. How to handle a query with special characters / (forward slash) and \ (backslash)
  29. Does MySQL support historical date (like 1200)?
  30. mySQL query to search all tables within a database for a string?

Leave a Comment