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 <[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]
Skype: banyan.he
Email: [EMAIL PROTECTED]
http://www.rootong.com




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to