I am looking for a front end application that will allow me to enter in all my server / workstation data into a MySQL back end running on Linux. I have been told that I need to take all 75 servers we have in our server room and keep a database of the following:

- Make
- Model
- O.S.
- I.P.
- Hostname
- Serial #
- Company Asset #
- Warranty Expiration Date
- Room Location

Does anyone know of a program or easiest way I can enter all this data into a MySQL database and manage it as things change and move around? Right now I am using a spreadsheet from OpenOffice and it's not efficient if you know what I mean. Anyone have any tips / suggestions?

Have you looked at phpMyAdmin ?

I think so. A long time ago. That just lets me interface with MySQL via a GUI, right?

Check it out - it's pretty powerful. Let's you do just about anything with MySQL.

http://www.phpmyadmin.net/

I have an app already written that does this in SQLite, if you're interested. It's CLI only at the moment, though.

It's pretty beta, however I'm more than happy to share.

No if I have a server called 'database' which is running MySQL on it. I am assuming just from the link you posted I also need to install phpmyadmin also on this server.

So can I actually access the phpmyadmin / MySQL applications from a different machine on the same LAN? Basically the 'database' server has no GUI installed nor can I install one so I need to make sure I can open the GUI on my desktop PC. Is this possible with phpmyadmin?

You might want to just download the MySQL admin tool from their website:
http://www.mysql.com/products/workbench/

openoffice.org base is a database front end that can be connected to a variety of backends, including mysql... on a linux workstation, i installed unixODBC followed by the mysql-connector from mysql (libmyodbc.so), edited /etc/odbc.ini and /etc/odbcinst.ini, and then openoffice base was able to connect to my mysql databases! My mysql server is on a remote host.

However, I haven't used openoffice.org base as a front end to mysql long enough to give any report on stability, etc. I think it was easier to set it up than to build it.

I think that if you run apache and php on the admin workstation (or if you already have them running elsewhere in your lan), you can still use phpAdmin to administer the remote mysql server without having to install gui software on the mysql server itself...

I was half way through building a front end with ltk + clsql when I discovered openoffice base, and figured there was no reason to reinvent the wheel..

openoffice.org base is a database front end that can be connected to a variety of backends, including mysql...

on a linux workstation, i installed unixODBC followed by the connector-odbc (libmyodbc.so) from mysql, edited /etc/odbc.ini and /etc/odbcinst.ini, and then openoffice base was able to connect to my mysql databases! My mysql server is on a remote host.

However, I haven't used openoffice.org base as a front end to mysql long enough to give any report on stability, etc.

I think that if you run apache and php on the admin workstation (or if you already have them running elsewhere in your lan), you can still use phpAdmin to administer the remote mysql server without having to install gui software on the mysql server itself...

I was half way through building a front end with ltk + clsql when I discovered openoffice base, and figured there was no reason to reinvent the wheel..