setting up a server

[slighltywhacked]

hey all...
A friend and I are setting up a server(Apache). We have PHP and mysql working... but we need to know how to set up the server so we can login through tel net to edit/create databases. Is there anywhere with good documentation for this?

[qslack]

Telnet poses a security risk: all your passwords are sent across the Internet in plaintext. That means that any of the networks your data passes through can steal your password.

So you should use ssh. It's essentially telnet, but encrypted.

The PuTTY client is an excellent client for Windows. For the SSH server, try OpenSSH. It comes with good installation instructions.

Once you've logged in, do this:
export PATH=$PATH:/usr/local/mysql/bin

Then you can login to mysql like this:
mysql -u <username> -p

And run commands from there.

Alternatively, you could set up phpMyAdmin. It's a PHP program that allows you to edit, create, and delete DBs from a WWW interface.

[slighltywhacked]

thanx a lot
do you have a url for the phpadmin thing?

[qslack]

http://www.phpwizard.net/projects/phpMyAdmin/