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
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 ---------------------------------
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
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. | | Thanks, | Brian Densmore
I suggest phpMyAdmin and phpPgAdmin. They are easy to use and provide a nice interface that is web accessable.
Chris - -- I digitally sign my emails. If you see an attachment with .asc, then that means your email client doesn't support PGP digital signatures. http://www.gnupg.org/(en)/documentation/faqs.html#q1.1
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
Our Lumenation framework includes a complete DB Manager for PostgreSQL and MySQL within it. It also provides this in an integrated Data Access framework of a Data Dictionary as well allowing for the movement or automatic learning of schemas for easy access. Lumenation is FREE as well.
On Fri, 2004-11-19 at 16:40 -0600, Steven Hildreth wrote:
From:Steven Hildreth sphildreth@gmail.com Reply-To: Steven Hildreth sphildreth@gmail.com To: Brian Densmore <densmoreb@ctbsonline.com
Don P. Keeler CTO, Co-Founder Lumen Software P:816.880.0066 x115 F:816.880.0440
The Lumen Genesis Initiative™ – Catalyst for the Rapid Growth of Linux Solutions.
Lumen Software™, LightBulb™, Lumenation™, Lumen Linux Terminal Services™, Linux Enterprise Network Suite™, EzThin™, LISG™, and LSDG™ are trademarks of GeKL Technologies, Inc.
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
-
Brian Densmore -
Chris Bier -
docv -
Don Keeler -
Frank Wiles -
Steven Hildreth