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@hotmail.com
Skype: banyan.he
Email: banyan@rootong.com
http://www.rootong.com

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' identified by
'password';
and then try you mysqldump

regards
anandkl


On 7/19/07, Banyan He <banyan@rootong.com> 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@hotmail.com
> Skype: banyan.he
> Email: banyan@rootong.com
> http://www.rootong.com
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=anandkl@gmail.com
>

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@rootong.com
> <mailto:banyan@rootong.com>> 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@hotmail.com <mailto:banyan.he@hotmail.com>
> Skype: banyan.he
> Email: banyan@rootong.com <mailto:banyan@rootong.com>
> 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=anandkl@gmail.com
>
>

--
---------------
Banyan He
IronPort Customer Support
MSN: banyan.he@hotmail.com
Skype: banyan.he
Email: banyan@rootong.com
http://www.rootong.com

You mean to say, you cannot execute the "GRANT" command.

regards
anandkl


On 7/19/07, Banyan He <banyan@rootong.com> 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@rootong.com
> > <mailto:banyan@rootong.com>> 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@hotmail.com <mailto:banyan.he@hotmail.com>
> > Skype: banyan.he
> > Email: banyan@rootong.com <mailto:banyan@rootong.com>
> > 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=anandkl@gmail.com
> >
> >
>
> --
> ---------------
> Banyan He
> IronPort Customer Support
> MSN: banyan.he@hotmail.com
> Skype: banyan.he
> Email: banyan@rootong.com
> http://www.rootong.com
>
>
>

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@rootong.com
> <mailto:banyan@rootong.com>> 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@rootong.com
> <mailto:banyan@rootong.com>
> > <mailto: banyan@rootong.com <mailto:banyan@rootong.com>>> 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@hotmail.com <mailto:banyan.he@hotmail.com>
> <mailto:banyan.he@hotmail.com <mailto:banyan.he@hotmail.com>>
> > Skype: banyan.he
> > Email: banyan@rootong.com <mailto:banyan@rootong.com>
> <mailto: banyan@rootong.com <mailto:banyan@rootong.com>>
> > 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=anandkl@gmail.com
> >
> >
>
> --
> ---------------
> Banyan He
> IronPort Customer Support
> MSN: banyan.he@hotmail.com <mailto:banyan.he@hotmail.com>
> Skype: banyan.he
> Email: banyan@rootong.com <mailto:banyan@rootong.com>
> http://www.rootong.com
>
>
>

--
---------------
Banyan He
IronPort Customer Support
MSN: banyan.he@hotmail.com
Skype: banyan.he
Email: banyan@rootong.com
http://www.rootong.com

You cannot execute the grant 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@rootong.com
>> <mailto:banyan@rootong.com>> 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@rootong.com
>> <mailto:banyan@rootong.com>
>> > <mailto: banyan@rootong.com <mailto:banyan@rootong.com>>> 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@hotmail.com <mailto:banyan.he@hotmail.com>
>> <mailto:banyan.he@hotmail.com <mailto:banyan.he@hotmail.com>>
>> > Skype: banyan.he
>> > Email: banyan@rootong.com <mailto:banyan@rootong.com>
>> <mailto: banyan@rootong.com <mailto:banyan@rootong.com>>
>> > 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=anandkl@gmail.com
>> >
>> >
>>
>> --
>> ---------------
>> Banyan He
>> IronPort Customer Support
>> MSN: banyan.he@hotmail.com <mailto:banyan.he@hotmail.com>
>> Skype: banyan.he
>> Email: banyan@rootong.com <mailto:banyan@rootong.com>
>> http://www.rootong.com
>>
>>
>>
>
> ------------------------------------------------------------------------
>
>
>

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@rootong.com
>>> <mailto:banyan@rootong.com>> 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@rootong.com
>>> <mailto:banyan@rootong.com>
>>> > <mailto: banyan@rootong.com <mailto:banyan@rootong.com>>> 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@hotmail.com <mailto:banyan.he@hotmail.com>
>>> <mailto:banyan.he@hotmail.com <mailto:banyan.he@hotmail.com>>
>>> > Skype: banyan.he
>>> > Email: banyan@rootong.com <mailto:banyan@rootong.com>
>>> <mailto: banyan@rootong.com <mailto:banyan@rootong.com>>
>>> > 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=anandkl@gmail.com
>>> >
>>> >
>>>
>>> --
>>> ---------------
>>> Banyan He
>>> IronPort Customer Support
>>> MSN: banyan.he@hotmail.com <mailto:banyan.he@hotmail.com>
>>> Skype: banyan.he
>>> Email: banyan@rootong.com <mailto:banyan@rootong.com>
>>> http://www.rootong.com
>>>
>>>
>>>
>>
>> ------------------------------------------------------------------------
>>
>>
>>
>
>
>

--
---------------
Banyan He
IronPort Customer Support
MSN: banyan.he@hotmail.com
Skype: banyan.he
Email: banyan@rootong.com
http://www.rootong.com

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@rootong.com> 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@rootong.com
> >>> <mailto:banyan@rootong.com>> 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@rootong.com
> >>> <mailto:banyan@rootong.com>
> >>> > <mailto: banyan@rootong.com <mailto:banyan@rootong.com>>> 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@hotmail.com <mailto:banyan.he@hotmail.com>
> >>> <mailto:banyan.he@hotmail.com <mailto:banyan.he@hotmail.com>>
> >>> > Skype: banyan.he
> >>> > Email: banyan@rootong.com <mailto:banyan@rootong.com>
> >>> <mailto: banyan@rootong.com <mailto:banyan@rootong.com>>
> >>> > 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=anandkl@gmail.com
> >>> >
> >>> >
> >>>
> >>> --
> >>> ---------------
> >>> Banyan He
> >>> IronPort Customer Support
> >>> MSN: banyan.he@hotmail.com <mailto:banyan.he@hotmail.com>
> >>> Skype: banyan.he
> >>> Email: banyan@rootong.com <mailto:banyan@rootong.com>
> >>> http://www.rootong.com
> >>>
> >>>
> >>>
> >>
> >>
> ------------------------------------------------------------------------
> >>
> >>
> >>
> >
> >
> >
>
> --
> ---------------
> Banyan He
> IronPort Customer Support
> MSN: banyan.he@hotmail.com
> Skype: banyan.he
> Email: banyan@rootong.com
> http://www.rootong.com
>
>
>

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@rootong.com> 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@rootong.com
>> >>> <mailto:banyan@rootong.com>> 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@rootong.com
>> >>> <mailto:banyan@rootong.com>
>> >>> > <mailto: banyan@rootong.com <mailto:banyan@rootong.com>>>
>> 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@hotmail.com <mailto:banyan.he@hotmail.com>
>> >>> <mailto:banyan.he@hotmail.com <mailto:banyan.he@hotmail.com>>
>> >>> > Skype: banyan.he
>> >>> > Email: banyan@rootong.com <mailto:banyan@rootong.com>
>> >>> <mailto: banyan@rootong.com <mailto:banyan@rootong.com>>
>> >>> > 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=anandkl@gmail.com
>> >>> >
>> >>> >
>> >>>
>> >>> --
>> >>> ---------------
>> >>> Banyan He
>> >>> IronPort Customer Support
>> >>> MSN: banyan.he@hotmail.com <mailto:banyan.he@hotmail.com>
>> >>> Skype: banyan.he
>> >>> Email: banyan@rootong.com <mailto:banyan@rootong.com>
>> >>> http://www.rootong.com
>> >>>
>> >>>
>> >>>
>> >>
>> >>
>> ------------------------------------------------------------------------
>> >>
>> >>
>> >>
>> >
>> >
>> >
>>
>> --
>> ---------------
>> Banyan He
>> IronPort Customer Support
>> MSN: banyan.he@hotmail.com
>> Skype: banyan.he
>> Email: banyan@rootong.com
>> http://www.rootong.com
>>
>>
>>
>

--
---------------
Banyan He
IronPort Customer Support
MSN: banyan.he@hotmail.com
Skype: banyan.he
Email: banyan@rootong.com
http://www.rootong.com

Ananda, I cannot host the reasons. Just add one more parameter to avoid
"LOCK TABLES".

mysqldump --lock-tables=false db

That works.

Cheers,

Thx guys.

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@rootong.com> 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@rootong.com
>> >>> <mailto:banyan@rootong.com>> 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@rootong.com
>> >>> <mailto:banyan@rootong.com>
>> >>> > <mailto: banyan@rootong.com <mailto:banyan@rootong.com>>>
>> 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@hotmail.com <mailto:banyan.he@hotmail.com>
>> >>> <mailto:banyan.he@hotmail.com <mailto:banyan.he@hotmail.com>>
>> >>> > Skype: banyan.he
>> >>> > Email: banyan@rootong.com <mailto:banyan@rootong.com>
>> >>> <mailto: banyan@rootong.com <mailto:banyan@rootong.com>>
>> >>> > 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=anandkl@gmail.com
>> >>> >
>> >>> >
>> >>>
>> >>> --
>> >>> ---------------
>> >>> Banyan He
>> >>> IronPort Customer Support
>> >>> MSN: banyan.he@hotmail.com <mailto:banyan.he@hotmail.com>
>> >>> Skype: banyan.he
>> >>> Email: banyan@rootong.com <mailto:banyan@rootong.com>
>> >>> http://www.rootong.com
>> >>>
>> >>>
>> >>>
>> >>
>> >>
>> ------------------------------------------------------------------------
>> >>
>> >>
>> >>
>> >
>> >
>> >
>>
>> --
>> ---------------
>> Banyan He
>> IronPort Customer Support
>> MSN: banyan.he@hotmail.com
>> Skype: banyan.he
>> Email: banyan@rootong.com
>> http://www.rootong.com
>>
>>
>>
>

--
---------------
Banyan He
IronPort Customer Support
MSN: banyan.he@hotmail.com
Skype: banyan.he
Email: banyan@rootong.com
http://www.rootong.com