|Marty O'Brien on 5 Aug 2008 09:08:59 -0700|
I'd like to recommend PHPMyAdmin (since you are using PHP anyway), which DOES come in a .deb package in the repos. It provides a web interface to manage your MySQL instance, by default connected to your localhost instance. It will also automatically set up the web interface to http://localhost/phpmyadmin in debian (or ubuntu :-).
Actually, you shouldn't need it for what you're trying to do, and it can't do anything that MySQL Administrator can't do, but it has a slick interface and makes learning MySQL management a lot easier IMHO. Plus, it will enable you to manage your database remotely without opening a remote MySQL port to the world (which IS a bad idea).
All of this stuff is really easy to figure out and worth learning.
I don't have any experience with the particular webapp you're trying to deploy, but there are usually scripts included to set up the database, sometimes you have to edit a config file to enter a username and password for the database, sometimes there is a web page (with php script backend) that will ask you for the info and do it for you.
I'd also like to recommend that you create a seperate user for each web app you deploy and either MANUALLY create the database it needs and only allow it full access to it or ONLY give it create access to the database server. This is just another level of control to keep your app from messing with anything else you end up using the DB server for.
Anyway, I really enjoy this stuff so I don't mind typing for hours about it, but I have to get back to REAL work :-)
Hope this helps and doesn't just make things more confusing.
On Tue, Aug 5, 2008 at 11:56 AM, Michael Leone <email@example.com> wrote:
___________________________________________________________________________ Philadelphia Linux Users Group -- http://www.phillylinux.org Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce General Discussion -- http://lists.phillylinux.org/mailman/listinfo/plug