Gossamer Forum
Home : Products : Others : MySQLMan :

First Time User

Quote Reply
First Time User
Hi,
I have MysqlMan up and running on my server but I have no idea how to use it.
I've looked everywhere but I can't find any user documentation.
What do all the terms mean??
(e.g TYPE - TINYINT,SMALLINT,MEDIUMINT,INT,BIGINT,FLOAT,etc)
(e.g ATTRIBUTES - BINARY,UNSIGNED,UNSIGNED ZEROFILL)
How do I set everything up?
Where can I find a SIMPLE tutorial on how to use MysplMan?
Thanks
Simon.

Quote Reply
Re: First Time User In reply to
Start with the docs on the mysql site http://mysql.org.

All MySQLMan is is a graphical, web-based interface to the MYSQL database. It's not an end-user application in and of itself. It just makes getting to the MySQL server _much_ easier to do things for other running applications.

Rather than having to go into telnet, and use the mysql> prompt command-line, interactively, you can get the information and "click" on commands from a web browser.

Since you have it running, the following probably doesn't apply to you, but I'll add it here anyway:

If you are using LinkSQL, and want to use this as an interface, move the 'mysqlman' directory into the ../cgi-bin/links/admin subdirectory, and it meshes perfectly, and is automatically password secured by the admin password you should have set up for Links.

If you are using it without LinkSQL, just put it in your /cgi-bin/mysqlman subdirectory.

It's a _really_ easy program to set up. Just copy it to your server in ASCII, set the file permission on mysql.cgi to 755 (rwxr-xr-x) and point your browser to the url of that file! _MOST_ systems will up and run at that point. On a few, you need to edit the top of the file to have the path, but that is explained _in_ the file itself.

Then, you need to have an SQL based application to use this interface on :) If you don't have DBMAN SQL, or LinksSQL, or some other SQL based program working on your site, then you can find other SQL based applications at sites like http://cgi-resources.com and can follow their installation instructions, using the power of mySQLman to set up the databases, and look at your data, rather than doing it from the telnet mysql> prompt.

Good luck!

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