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

["Sean C. Sheridan" <scs@CampusClients.com>]

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');
mysql> FLUSH PRIVILEGES;

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!
http://dev.mysql.com/downloads/gui-tools/5.0.html



> On Tue, Aug 5, 2008 at 11:41 AM, Sean C. Sheridan <scs@campusclients.com>
> wrote:
>> yum install mysql mysql-server
>> service start mysqld
>
> Adam is using a Debian distro, so just using aptitude to install the
> mySQL server should install that. And if there's an osticket package,
> I imagine it should configure the MySQL tables and settings the way it
> wants them.
>
> Is there such a beast as a .deb of osticket?
> --
> Michael J. Leone, <mailto:turgon@mike-leone.com>
>
> PGP Fingerprint: 0AA8 DC47 CB63 AE3F C739 6BF9 9AB4 1EF6 5AA5 BCDF
> Photo Gallery: <http://www.flickr.com/photos/mikeleonephotos>
>
> "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         --
> http://www.phillylinux.org
> Announcements -
> http://lists.phillylinux.org/mailman/listinfo/plug-announce
> General Discussion  --
> http://lists.phillylinux.org/mailman/listinfo/plug
>


-- 
Sean C. Sheridan
scs@CampusClients.com

Campus Party, Inc.
444 North Third St.
Philadelphia, PA 19123
(215) 320-1810, xtn 117
(215) 320-1814 fax
http://www.CampusClients.com
http://www.CampusParty.com
___________________________________________________________________________
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