This script looks pretty good but I have a few questions...

1) Do you we need to install anything relating to mySQL before using this script or will this script take care of everything?

2) If we need to install something dealing with mySQL before using this script, are there any instruction on how to do that without telnet access?

I am totally new to mySQL and have been looking at a tutorial at www.inlink.com/~perlguy/sql/ and it says I need to do two things:

-Install and configure a SQL database (I'm assuming that this script will do it)
-Load the DBI modules for perl (I can't find the right one)

If you already have MySQL installed in your server, then no. If you don't, then you need to first install MySQL, which can be found at http://www.mysql.com.

Again...if you do not have MySQL installed in your server, then you will need to download it from http://www.mysql.com. Also, make sure that you have all the appropriate PM files installed in your server, like CGI.pm.

Actually, MySQLMan is only a web emulator for your MySQL server. Again, for the third time, you need to install MySQL if you do not have it installed already.

Regards,

Eliot Lee

Ok, I have contacted my host and we do in fact have mySQL installed on the server. Now, I ran the script for mySQLman and it's at http://www.hyrum.net/cgi-bin/cgiwrap/hyrum/mysql.cgi When I try to create a database I get an error saying couldn't connect to SQL server. Can anyone help me out with that one? I have also contacted my host to see if there is anything special I ned to know (eg. I needed cgiwrap for scripts).

You need to find out the host name of your MySQL server. Typically, the default configuration for the host is localhost.

Use localhost in the login screen or leave it blank.

Regards,

Eliot Lee

"localhost" works if MySQL is on the same machine as your website (translated: the script that makes the database call -- if you proxy to a cgi server, the database has to be local to _that_ server, where 'localhost' returns the _same_ machine as the fully qualified database machine's name) -- usually only if you have a dedicated server set up.

Otherwise, you'd probably have a name like database.myisp.com, mysql.myisp.com or db.myisp.com or something like that.

Usually, the ISP will install one copy of mysql for their users, on a separate machine that is tuned to run a database.

Most dedicated servers don't get to use that ... they have to run their own, and put up with all the other features that this gives them -- such as the ability to create databases (not just tables), use 'localhost' rather than a remote machine, restart/reload the server anytime they make a permissions change, etc. :) Oh well..... dedicated server people will just have to live with all that ;)

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/