SitePoint Sponsor |
|
User Tag List
Results 1 to 4 of 4
Thread: setting up a server
-
Jun 15, 2001, 22:55 #1
- Join Date
- Apr 2001
- Location
- BC, Canada
- Posts
- 630
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
setting up a server
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?Last edited by slighltywhacked; Jun 15, 2001 at 22:59.
-
Jun 15, 2001, 23:00 #2
- Join Date
- Jul 1999
- Location
- Chicago
- Posts
- 2,629
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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.
-
Jun 15, 2001, 23:14 #3
- Join Date
- Apr 2001
- Location
- BC, Canada
- Posts
- 630
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
thanx a lot
do you have a url for the phpadmin thing?
-
Jun 15, 2001, 23:30 #4
- Join Date
- Jul 1999
- Location
- Chicago
- Posts
- 2,629
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Bookmarks