Yes, the server shows me that. I cannot execute the grant command.
This is a serious restriction software works with mysql.
Ananda Kumar wrote:
You mean to say, you cannot execute the "GRANT" command.
regards
anandkl
On 7/19/07, *Banyan He* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> 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:[EMAIL PROTECTED]> identified by 'password';
> and then try you mysqldump
>
> regards
> anandkl
>
>
> On 7/19/07, *Banyan He* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
> <mailto: [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]>
<mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
> Skype: banyan.he
> Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
<mailto: [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] <mailto:[EMAIL PROTECTED]>
Skype: banyan.he
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
http://www.rootong.com
--
---------------
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]