ankush, i wasn't aware that mysql 'allowed' you to access the mysql db/table using an 'encrypted' passwd. furthermore, i'm not sure that this would get you where you want to go anyway. you seem to want to set up a process to allow the db/table to be backed up. to do this, mysql requires the use of the username/passwd. you hope to provide an encrypted passwd, to allow your process to work. but if mysql allowed this, then wouldn't someone be able to still access your mysql db/table in the same manner???? so, either way, you need to provide a 'passwd' in a manner that someone with the appropriate access privs will unfortunately still be able to see. you're not the 1st to want to accomplish this, so i would imagine that there are various methods to accomplish this. check the mysql website, or post this question to the mysql email list if you haven't already. i'm pretty sure you'll get your answer fairly quickly! -bruce -----Original Message----- From: fedora-list-bounces@xxxxxxxxxx [mailto:fedora-list-bounces@xxxxxxxxxx]On Behalf Of Ankush Grover Sent: Tuesday, August 02, 2005 5:08 AM To: gb spam; For users of Fedora Core releases Subject: Re: script/command for taking automatic backup of mysql database > > 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 -- fedora-list mailing list fedora-list@xxxxxxxxxx To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list
