Looking something like Mirosoft Access

[stevewabc]

I'm looking for the following: ( maybe StarOffice ?)

- Creating a new database
- Launching a database wizard
- Editing and saving tables
- Establishing keys and relationship
- Importing and exporting table data
- Printing the easy way
- Creating and saving marcos
- administrating and securing data
- Publishing data on the web

[bigrigdriver]

I'd suggest that you investigate two apps: MySQL and Webmin. MySQL is a database app (command-line) and Webmin is a web-based system administration tool (run within any web browser once configured properly; comes with my distro:OpenLinux). If you try to use MySQL on its own, it strictly command-line, no gui. If you have Webmin installed, the latest version has modules you can install, which includes a MySQL module, which allows you to create Databases, tables, etc; assign permisions, all within the Webmin gui. You can run queries, searches, etc within command-line windows in Webmin, create dbases, specify how many fields each record must have, etc.; all from Webmin. If it's not convenient to have root doing it all, except user enties, changes, deletes, etc, then give user permisions to edit data (not metadata); which means, let root create the dbase and tables, and let user populate the tables.

[KarrottoP]

if you do not know sql good luck, thats all I have to say, its not like Access where you get vbs to play with, you could also actually just run access on linux with either wine or crossover office.....but your best bet is to learn sql, it rocks, after you learn it.

[stevewabc]

OK were do you start looking for info on MySQL and how to learn it and use it. "O" also info on Webmin.

thanks everyone

[IRQ5]

http://www.mysql.com/documentation/mysql/
http://www.mysql.com/products/mysqlcc/index.html
Not sure about Webmin, but the second's a link to a gui.

Looked kinda neat, but kinda akward to update or keep in your head what was going on. I dunno. I like databases, though.

[stevewabc]

Do I or Don't I have MySQL already under redhat ?
and if so how do I get this going?

[iDxMan]

No telling if you have it installed or not - look around.


find / -name mysqld


You may also want to look at MySQL's new control center.

http://www.mysql.com/products/mysqlcc/index.html

I seriously doubt you're going to find anything "just like" access that does everything for you, but the control center is a very nice interface. .... although deploying to the web is another story.

-r