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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
