Hi Banyan, Permission can vary from database to database. Please ask your dba to grant you the permission and then try the mysqldump
On 7/19/07, Banyan He <[EMAIL PROTECTED]> wrote:
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
