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.
- 03-24-2005 #1Linux 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
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?Code:0 0 * * 0 mysqldump -uroot -p******* phpbb > /backup/zachtib_sun.sql
- 03-24-2005 #2Linux User
- Join Date
- Feb 2005
- Posts
- 290
create an account with limited access and grant it to dump the database .. ....
good luck
- 03-24-2005 #3Linux User
- Join Date
- Dec 2004
- Location
- Speed School of Engineering
- Posts
- 267
how do I create a mysql account?
Reply With Quote 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
