You mean to say, you cannot execute the "GRANT" command.
regards anandkl On 7/19/07, Banyan He <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]> identified by 'password'; > and then try you mysqldump > > regards > anandkl > > > On 7/19/07, *Banyan He* <[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]>> 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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > Skype: banyan.he > Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > 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/[EMAIL PROTECTED] > > -- --------------- Banyan He IronPort Customer Support MSN: [EMAIL PROTECTED] Skype: banyan.he Email: [EMAIL PROTECTED] http://www.rootong.com