Re: error once backing up database
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]
Re: error once backing up database
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]
Re: error once backing up database
You mean to say, you cannot execute the GRANT command. regards anandkl On 7/19/07, Banyan He [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] 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
Re: error once backing up database
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]
Re: error once backing up database
You cannot execute the grant 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error once backing up database
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]
Re: error once backing up database
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
Re: error once backing up database
thx Ananda. I will try. Cheers, Ananda Kumar wrote: 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 -- --- 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]
Re: error once backing up database
Ananda, I cannot host the reasons. Just add one more parameter to avoid LOCK TABLES. mysqldump --lock-tables=false db That works. Cheers, Thx guys. Ananda Kumar wrote: 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 -- --- 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]