From: Ananda Kumar (anandklgmail.com)
Date: Thu Jul 19 2007 - 04:58:41 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

regards
anandkl

On 7/19/07, Banyan He <banyanrootong.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* <banyanrootong.com
> > <mailto:banyanrootong.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.hehotmail.com <mailto:banyan.hehotmail.com>
> > Skype: banyan.he
> > Email: banyanrootong.com <mailto:banyanrootong.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=anandklgmail.com
> >
> >
>
> --
> ---------------
> Banyan He
> IronPort Customer Support
> MSN: banyan.hehotmail.com
> Skype: banyan.he
> Email: banyanrootong.com
> http://www.rootong.com
>
>
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]