How to connect to MySQL remotely

Anon

I'm thinking of administering a web database with PHP and MySQL remotely with Linux OS...I understand that with Oracle, you need to install SQL*Net/Net8? Is there an equivalent software for MySQL? Does this software have to be installed on both the client and server machine? Does the client machine need both PHP and MySQL installed on it or do we only install PHP And MySQL on the server? Can the client machine be a dumb terminal?
Thanks!
Allen

Anon

You can use phpmyAdmin @ http://www.phpwizard.net/projects/phpMyAdmin/

Anon

All you need is the client on the terminals, nothing else. use the -h option when connecting to specify the host.

mysql -hwww.yourdomain.com -uuser -ppass

I think that's what you want...

---John Holmes...

Anon

December 1, 2000
Dear John,
I was just thinking....when I connect to the MySQL server remotely by
mysql -hwww.yourdomain.com -uuser -ppass
will someone be able to intercept and read the usernanme and password?
I'm running MySQL out of Dos.....if I'm on the road and if I connect to the net on my laptop via a local ISP, will I still be able to issue the above command at the dos prompt and connect to my MySQL server.
I bet the above questions are real stupid but I'm fairly new to all this so please bear with me. Thanks!!!
Allen.

Anon

Everything is passed plain text, yes. It's also passed plain text when you telnet. The only secure way to log into a server is to use ssh. You can download telnet programs with ssh from tucows.com. There are instructions in the manual for connecting to mysql through ssh, also.

You can issue that command from any dos prompt, as long as your connected to the internet and your mysql server is up, it'll work.

---John Holmes...

Anon

Thanks a lot for the additional info, John!!
Allen