thx Ananda. I will try.
Cheers,
Ananda Kumar wrote:
> Hi Banyan,
> Permission can vary from database to database.
> Please ask your dba to grant you the permission and then try the
> mysqldump
>
>
> On 7/19/07, Banyan He <banyan@stripped> wrote:
>>
>> The question is in this server, I cannot backup the database by issuing
>> mysqldump. On another server, I can. I am sure nobody changes the
>> settings. That's confusing to me.
>> > ant command because you don't have permission to do so.
>> > The GRANT command allows you to set permissions on databases and
>> > tables, thereby giving access to possibly sensitive data.
>> >
>> > It is in no way a serious restriction, it is a very important security
>> > feature.
>> >
>> > If you don't have the grant permission and need it, ask your database
>> > administrator to set up rights.
>> > Don't assume that what may be easier for you in other software
>> > environments, is the better solution. In this case, it clearly is not.
>> >
>> > regards,
>> >
>> > boro
>> >
>> > Banyan He schreef:
>> >> Yes, the server shows me that. I cannot execute the grant command.
>> >> This is a serious restriction software works with mysql.
>> >>
>> >> Ananda Kumar wrote:
>> >>> You mean to say, you cannot execute the "GRANT" command.
>> >>>
>> >>> regards
>> >>> anandkl
>> >>>
>> >>>
>> >>> On 7/19/07, *Banyan He* <banyan@stripped
>> >>> <mailto:banyan@stripped>> wrote:
>> >>>
>> >>> Thx Ananada. Actually, I don't have the admin permission on
> this
>> >>> server.
>> >>> The grant command is unavailable for me. I have no ideas about
>> >>> this. I
>> >>> install the software on two machines, one of them can issue
> this
>> >>> command
>> >>> and works fine with it. Another cannot.
>> >>>
>> >>> OS: windows 2003
>> >>>
>> >>> Cheers,
>> >>> Ananda Kumar wrote:
>> >>> > Looks like this user does hot have permission on
>> message_tracker
>> >>> while
>> >>> > connecting on the local host.
>> >>> >
>> >>> > try this.
>> >>> >
>> >>> > grant all on message_tracker to 'admin'@'localhost'
>> >>> > <mailto:%27admin%27@%27localhost%27> identified by
> 'password';
>> >>> > and then try you mysqldump
>> >>> >
>> >>> > regards
>> >>> > anandkl
>> >>> >
>> >>> >
>> >>> > On 7/19/07, *Banyan He* <banyan@stripped
>> >>> <mailto:banyan@stripped>
>> >>> > <mailto: banyan@stripped
> <mailto:banyan@stripped>>>
>> wrote:
>> >>> >
>> >>> > Hi Guys,
>> >>> >
>> >>> > I encounter an issue once I backup the database.
>> >>> >
>> >>> > mysqldump -u admin -phost --databases message_tracker
> > z:
>> >>> > sqlbackup.sql
>> >>> >
>> >>> > mysqldump: Got error: 1044: Access denied for user
>> >>> 'admin'@'localhost'
>> >>> > to database 'message_tracker' when using LOCK TABLES
>> >>> >
>> >>> > I am using windows as the OS.
>> >>> >
>> >>> > Any advices will be appreciated.
>> >>> >
>> >>> > Regards,
>> >>> >
>> >>> > --
>> >>> > ---------------
>> >>> > Banyan He
>> >>> > IronPort Customer Support
>> >>> > MSN: banyan.he@stripped
> <mailto:banyan.he@stripped>
>> >>> <mailto:banyan.he@stripped
> <mailto:banyan.he@stripped>>
>> >>> > Skype: banyan.he
>> >>> > Email: banyan@stripped
> <mailto:banyan@stripped>
>> >>> <mailto: banyan@stripped
> <mailto:banyan@stripped>>
>> >>> > http://www.rootong.com
>> >>> >
>> >>> >
>> >>> >
>> >>> >
>> >>> > --
>> >>> > MySQL General Mailing List
>> >>> > For list archives: http://lists.mysql.com/mysql
>> >>> > <http://lists.mysql.com/mysql>
>> >>> > To
>> >>> > unsubscribe:
>> >>> http://lists.mysql.com/mysql?unsub=1
>> >>> >
>> >>> >
>> >>>
>> >>> --
>> >>> ---------------
>> >>> Banyan He
>> >>> IronPort Customer Support
>> >>> MSN: banyan.he@stripped <mailto:banyan.he@stripped>
>> >>> Skype: banyan.he
>> >>> Email: banyan@stripped <mailto:banyan@stripped>
>> >>> http://www.rootong.com
>> >>>
>> >>>
>> >>>
>> >>
>> >>
>> ------------------------------------------------------------------------
>> >>
>> >>
>> >>
>> >
>> >
>> >
>>
>> --
>> ---------------
>> Banyan He
>> IronPort Customer Support
>> MSN: banyan.he@stripped
>> Skype: banyan.he
>> Email: banyan@stripped
>> http://www.rootong.com
>>
>>
>>
>
--
---------------
Banyan He
IronPort Customer Support
MSN: banyan.he@stripped
Skype: banyan.he
Email: banyan@stripped
http://www.rootong.com
