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