after grinding away at this, ne of my work mates got it to work. the error *seems* to have come from 1) the config file that came with the software was looking for the database in the wrong place 2) the permissions were not being set correctly ;Though the usr mysql was correctly changed, the group mysql was not included in the permissions .
It now works. Thanks to all Andrew --- [EMAIL PROTECTED] wrote: > Send vox-tech mailing list submissions to > [EMAIL PROTECTED] > > To subscribe or unsubscribe via the World Wide Web, > visit > http://lists.lugod.org/mailman/listinfo/vox-tech > or, via email, send a message with subject or body > 'help' to > [EMAIL PROTECTED] > > You can reach the person managing the list at > [EMAIL PROTECTED] > > When replying, please edit your Subject line so it > is more specific > than "Re: Contents of vox-tech digest..." > > > Today's Topics: > > 1. mysql and linux - tech help (Andrew Stein) > 2. Re: mysql and linux - tech help (Micah Cowan) > 3. Re: mysql and linux - tech help (Michael Wenk) > 4. Re: mysql and linux - tech help (Tim Riley) > 5. Re: mysql and linux - tech help (Larry Ozeran) > > --__--__-- > > Message: 1 > Date: Tue, 19 Nov 2002 13:39:52 -0800 (PST) > From: Andrew Stein <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: [vox-tech] mysql and linux - tech help > Reply-To: [EMAIL PROTECTED] > > hi, I am looking for some tech help with mysql on my > linux computers. basicly, I am getting the following > error > > ERROR 2002: Can't connect to local MySQL server > through socket '/var/lib/mysql/mysql.sock' (111) > > What I want to do is run mysql localy, not over a > network or anything odd. I have three linux boxes > which all need to be running mysql. > > Should someone be able to come in person(I live in > Davis) and help me I would be more than willing to > pay > you for your time. > > ===== > ----------------- > Andrew Stein > > --__--__-- > > Message: 2 > Date: Tue, 19 Nov 2002 14:35:37 -0800 > Subject: Re: [vox-tech] mysql and linux - tech help > From: Micah Cowan <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Reply-To: [EMAIL PROTECTED] > > > On Tuesday, November 19, 2002, at 01:39 PM, Andrew > Stein wrote: > > > hi, I am looking for some tech help with mysql on > my > > linux computers. basicly, I am getting the > following > > error > > > > ERROR 2002: Can't connect to local MySQL server > > through socket '/var/lib/mysql/mysql.sock' (111) > > > > What I want to do is run mysql localy, not over a > > network or anything odd. I have three linux boxes > > which all need to be running mysql. > > It's not a TCP or UDP socket; it's a Unix domain > socket. > > Your problem is probably one of two things: your > MySQL server is not > running, or it is not creating the socket where the > client is looking > for it. > > -Micah > > > --__--__-- > > Message: 3 > From: "Michael Wenk" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Subject: Re: [vox-tech] mysql and linux - tech help > Date: Tue, 19 Nov 2002 15:04:58 -0800 > Reply-To: [EMAIL PROTECTED] > > > Ive gotten that error twice. Both times it was due > to mysql not running as > root and some weird permissions problem with /tmp or > /var/tmp. > > Problem is right now, I don't remember exactly what > I had to do to fix > it(obviously fix the perms problem, but how is > unclear to me right now) > > Mike > > ----- Original Message ----- > From: "Andrew Stein" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, November 19, 2002 1:39 PM > Subject: [vox-tech] mysql and linux - tech help > > > > hi, I am looking for some tech help with mysql on > my > > linux computers. basicly, I am getting the > following > > error > > > > ERROR 2002: Can't connect to local MySQL server > > through socket '/var/lib/mysql/mysql.sock' (111) > > > > What I want to do is run mysql localy, not over a > > network or anything odd. I have three linux boxes > > which all need to be running mysql. > > > > Should someone be able to come in person(I live in > > Davis) and help me I would be more than willing to > pay > > you for your time. > > > > ===== > > ----------------- > > Andrew Stein > > _______________________________________________ > > vox-tech mailing list > > [EMAIL PROTECTED] > > http://lists.lugod.org/mailman/listinfo/vox-tech > > > --__--__-- > > Message: 4 > Date: Tue, 19 Nov 2002 16:03:39 -0800 > From: Tim Riley <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Re: [vox-tech] mysql and linux - tech help > Reply-To: [EMAIL PROTECTED] > > Andrew Stein wrote: > > > hi, I am looking for some tech help with mysql on > my > > linux computers. basicly, I am getting the > following > > error > > > > ERROR 2002: Can't connect to local MySQL server > > through socket '/var/lib/mysql/mysql.sock' (111) > > Does this file exist? > Does the directory "/var/lib/mysql" exist? > > I got this message when I installed mysql in > a location what was not the default. The solution > was > to edit the script "safe_mysqld" and set the > location of the socket file to "/tmp" using the > environment variable "MYSQL_UNIX_PORT". > > > > > > > What I want to do is run mysql localy, not over a > > network or anything odd. I have three linux boxes > > which all need to be running mysql. > > > > Should someone be able to come in person(I live in > > Davis) and help me I would be more than willing to > pay > > you for your time. > > > > ===== > > ----------------- > > Andrew Stein > > _______________________________________________ > > vox-tech mailing list > > [EMAIL PROTECTED] > > http://lists.lugod.org/mailman/listinfo/vox-tech > > > --__--__-- > > === message truncated === _______________________________________________ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech
