Find the answer to your Linux question:
Results 1 to 3 of 3
is there a way to allow a user to perform an sql dump without a password? my crontab contains Code: 0 0 * * 0 mysqldump -uroot -p******* phpbb > ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux User
    Join Date
    Dec 2004
    Location
    Speed School of Engineering
    Posts
    267

    MySQL dumping


    is there a way to allow a user to perform an sql dump without a password?
    my crontab contains
    Code:
    0 0 * * 0 mysqldump -uroot -p******* phpbb > /backup/zachtib_sun.sql
    where ******* is my password, but it seems strange to have the password sitting there in a file, so can I allow root to perform a dump without a password?

  2. #2
    Linux User
    Join Date
    Feb 2005
    Posts
    290
    create an account with limited access and grant it to dump the database .. ....

    good luck

  3. #3
    Linux User
    Join Date
    Dec 2004
    Location
    Speed School of Engineering
    Posts
    267
    how do I create a mysql account?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •