The question is in this server, I cannot backup the database by issuing
mysqldump. On another server, I can. I am sure nobody changes the
settings. That's confusing to me.
ant command because you don't have permission to do so.
The GRANT command allows you to set permissions on databases and
tables, thereby giving access to possibly sensitive data.
It is in no way a serious restriction, it is a very important security
feature.
If you don't have the grant permission and need it, ask your database
administrator to set up rights.
Don't assume that what may be easier for you in other software
environments, is the better solution. In this case, it clearly is not.
regards,
boro
Banyan He schreef:
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]