At 10:09 AM +0307 7/8/01, Tonu Samuel wrote:
>Use the utility "perror" to get meaning of OS low level errors. This
>is an "Access denied" and means that in some reason you are not
>allowed to write into this "/" directory. I think, this is normal :)
I had checked the directory to make sure I had permission (chmod 777)
but the problem was actually that I neglected to realize I was
connecting to the mysql client with an admin Un/password that did not
have access to the database. When I logged in as root (using sudo) I
was able to perform the BACKUP.
Funny but I had used Grant as follows:
GRANT ALL ON *.* TO mylogin IDENTIFIED BY "xxx";
flush privileges;
And the mysql.user table shows the following:
Host | User | Password
% | mylogin | 50c0b4554dfdf0a
(and a Y on everything but Grant)
Doesn't that mean I can log in to administer MySQL with that username?
BTW I do not have any my.cnf file.
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
||| Seattle, WA, USA ||| http://www.lassodev.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
