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]