Hi there,

I heard someone asking how to start Windows service from a Linux box, but how to do vice-versa? I have my database on a Linux box (Fedora/Ubuntu), from another Windows box, I want to check if mysqld status and start if needed. May telnet help? Please give me a hint.

Thanks and best regards,

Hello

Nobody uses telnet because it is usecure. Use ssh on windows machine
from windows console.

Sorry for my english. I'm from Poland.

best wishes

Janusz

Hello gruby12,

Thanks. We know that, but with an in-house system like mine, I think it's good enough.

In fact, I intend to do all these tasks in an application. If I use SSH (say OpenSSH), how can I take advance of it? A build-in command would be easy.

Now I can 'telnet' Linux box, but don't know how to run that command.

BTW, your English is good enough to communicate, don't mind.

Cheers,

You should listen to gruby12's warning. Telnet is not secure. If you have the telnetd service running on the server, you should stop it. Even uninstall it. Using ssh you can do the same thing; they both give you access to your account and you can enter the same commands you would had you used telnet. One popular ssh client for windows is putty. I would recommend installing Cygwin/X. That will give you an x server terminal as well. You could then login using ssh and use a graphical program on the server as well.

On Fedora you could use chkconfig to check if a service is running. You can use the "service" command instead as well to check on the service or start it if need be. I've never used Ubuntu, so I don't know if it uses the same type of scripts & controls when they start with "chkconfig" but it should have the service command to control the scripts. You can also start the service by calling the mysql script in /etc/init.d/.

You probably want to download the mysql manual. There may be a safe_mysql or mysql_safe command that you should use to start the server manually. Also, a chapter in the manual deals with securing the server. There is a test database you might want to drop, and you will want to give the root user a password. Since you mentioned that the mysql server will be installed either on Fedora or Ubuntu, I'm assuming it hasn't been installed yet.

Thanks for your good advice, jschiwal!

I got the way as you recommend:

C:\putty> plink 10.0.0.1 -l test -pw test /etc/init.d/mysqld status

It works, jschiwal! Thank you very much!

I'll take a look at MySQL manual.

Have a nice day!