Re: mysqlshow question
Berman, Mikhail wrote: Hi Danny, Thank you for helping me here. Yes, I am aware of need to have the space between --host=xxx and --user=xxx, and command I am executing actually has a space. It looks like you believe that my problems related to security of remote logon. That is something, I am going to investigate more closely. My "mysql" command hangs, too. But, I have not done complete research on all its variations and has not done complete investigation on remote security. Best, Mikhail Berman -Original Message- From: Danny Stolle [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 4:47 PM To: Berman, Mikhail; mysql@lists.mysql.com Subject: Re: mysqlshow question Berman, Mikhail wrote: Hi everyone, My "/usr/local/mysql/bin/mysqlshow --host=xxx--user=xxx --password=" command hangs. I can ping host from local machine I can "locally" execute mysqlshow command on the host. I can "locally" execute mysqlshow command on remote server My environment is UNIX with MySQL 4.1.xx installed on both local server and host. Any help is greatly appreciated, Mikhail Berman Hi Berman, sorry if i might ask some simple questions ... but can you logon remotely at all(?), using the client tools like: - mysql -u -p -h -D - mysqladmin -u -p -h flush-tables are you granted for a remote logon? does your mysql-client tools hang as well? the statement show a no-space between '--host=xxx--user=xxx' it should be '--host=xxx --user=xxx' or are you aware of that? Best Regards, Danny Stolle Netherlands Hi Berman, i am not sure if it IS a security matter. What version are you running? mysql> \s mysql> mysql Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686) mysql> ... it could be that you are running a firewall, so the port is blocked and the client is still waiting for an answer (network problems )? if it excually was a security matter, you would get error messages, like 'Access denied ... ' or what ever. 'Sorry for the mishap for the space between the statement.' Try to log: use a my.cnf and put inside some logging under the [mysqld] section, like: log-error = "location/error.log" or locate where you have put your log-files, by: mysql>show variables like "log%" Danny Stolle Netherlands ps. If you have solved the problem, please let us know so we can learn from it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqlshow question
Hi Danny, Thank you for helping me here. Yes, I am aware of need to have the space between --host=xxx and --user=xxx, and command I am executing actually has a space. It looks like you believe that my problems related to security of remote logon. That is something, I am going to investigate more closely. My "mysql" command hangs, too. But, I have not done complete research on all its variations and has not done complete investigation on remote security. Best, Mikhail Berman -Original Message- From: Danny Stolle [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 4:47 PM To: Berman, Mikhail; mysql@lists.mysql.com Subject: Re: mysqlshow question Berman, Mikhail wrote: > Hi everyone, > > My "/usr/local/mysql/bin/mysqlshow --host=xxx--user=xxx > --password=" command hangs. > > I can ping host from local machine > I can "locally" execute mysqlshow command on the host. > I can "locally" execute mysqlshow command on remote server My > environment is UNIX with MySQL 4.1.xx installed on both local server > and host. > > Any help is greatly appreciated, > > Mikhail Berman > Hi Berman, sorry if i might ask some simple questions ... but can you logon remotely at all(?), using the client tools like: - mysql -u -p -h -D - mysqladmin -u -p -h flush-tables are you granted for a remote logon? does your mysql-client tools hang as well? the statement show a no-space between '--host=xxx--user=xxx' it should be '--host=xxx --user=xxx' or are you aware of that? Best Regards, Danny Stolle Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlshow question
Berman, Mikhail wrote: Hi everyone, My "/usr/local/mysql/bin/mysqlshow --host=xxx--user=xxx --password=" command hangs. I can ping host from local machine I can "locally" execute mysqlshow command on the host. I can "locally" execute mysqlshow command on remote server My environment is UNIX with MySQL 4.1.xx installed on both local server and host. Any help is greatly appreciated, Mikhail Berman Hi Berman, sorry if i might ask some simple questions ... but can you logon remotely at all(?), using the client tools like: - mysql -u -p -h -D - mysqladmin -u -p -h flush-tables are you granted for a remote logon? does your mysql-client tools hang as well? the statement show a no-space between '--host=xxx--user=xxx' it should be '--host=xxx --user=xxx' or are you aware of that? Best Regards, Danny Stolle Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]