Randall Perry wrote:
Well, this command is running in a cron job -- so that's not an option.
Be aware that you password is visible (unix anyway with a "ps -ef"..) when you
pass the password like -ppassword. Usually you can enter the password later
if
you use usr/local/mysql/bin/mysqldump --opt --all-databases -p
which avoids the password being visible..
Cormac.
On 12-Nov-2003 Randall Perry wrote:
Ok, I was confused about the password thing. It works now that I'm passing root's password in the command:
/usr/local/mysql/bin/mysqldump --opt --all-databases -prootpassword > /usr/local/mysql/data/mysqldump
You're joking, right? (Perhaps you thought the original question was a joke, too, as root normally has access to all dbs?)
As I understand the manual <http://www.mysql.com/doc/en/GRANT.html>, that will give root access to every db, from every host except localhost, with no password! I can't imagine that's a good idea. And even so, I don't think this will help, as he's connecting from localhost.
If we take the question at face value, it appears he has some dbs that root can't access. (I've never tried it, but I supppose it's possible to revoke root's access to a particular db.) If we assume [EMAIL PROTECTED] has a password we don't want to change, the correct command would be
GRANT ALL ON *.* to [EMAIL PROTECTED];
If he wants to change root's password at the same time, he would need to add the IDENTIFIED BY clause
GRANT ALL ON *.* to [EMAIL PROTECTED] IDENTIFIED BY 'newpassword';
Am I missing something?
-- Randall Perry sysTame
Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales
http://www.systame.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
---------------------------------- E-Mail: Cormac Tiernan <[EMAIL PROTECTED]> Date: 12-Nov-2003 Time: 15:01:53
This message was sent by XFMail
----------------------------------
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
