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=xxxx" 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 <username> -p<password> -h <host> -D <database>
- mysqladmin -u <username> -p<password> -h <host> 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 <hint>)?
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]