Marty O'Brien on 5 Aug 2008 09:08:59 -0700

[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PLUG] More fun w/help desk software

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.

--Marty O'Brien

On Tue, Aug 5, 2008 at 11:56 AM, Michael Leone <> wrote:
On Tue, Aug 5, 2008 at 11:52 AM, Sean C. Sheridan <> wrote:
> Once you've installed mysql you need to do 2 things...
> 1) set up password for root user
> shell> mysql -u root
> mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd');
> mysql> SET PASSWORD FOR ''@'host_name' = PASSWORD('newpwd');
> The hostname option let's you connect remotely.  But not until you open a
> port in the firewall (some people will tell you this is EXTREMELY
> dangerous).
> 2) download and install mysql admin.  It is AWESOME!

That's the beauty of packages ... when you install the .debs for MySQL
and MySQL Admin, it does all this for you. Plus, when security updates
or whatever are released, you get updated automatically. I would
definitely use packages, whenever possible. Especially for something
as common as MySQL ...

Michael J. Leone, <>

PGP Fingerprint: 0AA8 DC47 CB63 AE3F C739 6BF9 9AB4 1EF6 5AA5 BCDF
Photo Gallery: <>

"Sometimes your lack of sympathy gets hard to explain,
So on your mask of make-up you just paint a little parody of pain"
 "When You Were Young", Del Amitri
Philadelphia Linux Users Group         --
Announcements -
General Discussion  --

Philadelphia Linux Users Group         --
Announcements -
General Discussion  --