Re: error once backing up database

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
>
Received on Thu Jul 19 04:41:21 2007