script/command for taking automatic backup of mysql database

Ankush Grover ankush174 at gmail.com
Tue Aug 2 12:07:56 UTC 2005


> > password where as the password is given in the command in my case the
> > password for root user is  *F298CEE6BE03DAEB0D515166F40879C6DD1D24F3"
> > .
> >
> 
> remove the space between "-p" and the password.  ie, use
> 
>    -p*F298CEE6BE03DAEB0D515166F40879C6DD1D24F3
> 


I did remove the space but still it is not working.
The "*F298CEE6BE03DAEB0D515166F40879C6DD1D24F3" is encrypted password
and may be mysqldump does not recognizes the encrypted password.The
encrypted password is created through "select password(' ankush') " at
the mysql prompt.

Do you know the minimum requirements for a user to issue mysqldump
command.Means what privlieges it requires like select,lock tables etc.

Thanks & Regards

Ankush Grover




More information about the fedora-list mailing list