On Fri, 19 Nov 2004 13:17:38 -0600 "Brian Densmore" <DensmoreB@ctbsonline.com> wrote:

I'm installing postgres and mysql on my home server and want to be able to access the db from other places on the LAN and perhaps from the intranet. I was wondering what people recommend for managing and accessing the db. I want to be able to add/manage users,passwords,tables from inside of a gui frontend. Also any notes on setting up for remote access would be appreciated.

There is pgAdmin which you can find on http://gborg.postgresql.org. Never used it myself. It is just too easy to ssh into the box and use the commandline tools. Never seen a need for a GUI. --------------------------------- Frank Wiles <frank@wiles.org> http://www.wiles.org ---------------------------------

I have experience with MySQL using; MySQLCC (older combined tool) MySQL-administrator (new Server tool) MySQL-query-browser (new Client Query tool) There are ebuilds for all three and I think that MySQL-query-browser is a slick package. Regards, Steven On Fri, 19 Nov 2004 13:17:38 -0600, Brian Densmore <densmoreb@ctbsonline.com> wrote:

I'm installing postgres and mysql on my home server and want to be able to access the db from other places on the LAN and perhaps from the intranet. I was wondering what people recommend for managing and accessing the db. I want to be able to add/manage users,passwords,tables from inside of a gui frontend. Also any notes on setting up for remote access would be appreciated.

Thanks, Brian Densmore _______________________________________________ Kclug mailing list Kclug@kclug.org http://kclug.org/mailman/listinfo/kclug

Brian Densmore wrote:

I'm installing postgres and mysql on my home server and want to be able to access the db from other places on the LAN and perhaps from the intranet. I was wondering what people recommend for managing and accessing the db. I want to be able to add/manage users,passwords,tables from inside of a gui frontend. Also any notes on setting up for remote access would be appreciated.

You could also try webmin. Not only has access to postgresql and mysql, but an entire host of just about anything you want to add (web server, init start up scripts, sshd, ftpd, ....). Also has webmin user controls as well as system user controls and ACL's. You can get it at http://www.webmin.com -- Steve Vaitl, D.C. Certified Chiropractic Sports Physician Laser Pain Relief Center 319 SE Main St. Lee's Summit, MO 64063 docv@relievemypain.com (816)524-7000 Adjunct Professor, Biology and Human Anatomy Kansas City Kansas Community College