[rt-users] RE: Can't connect to local MySQL server through socket

[Ed Vazquez, Jr.]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I managed to get it running by compiling from source.

I had to set up the mysql user and group (since by default MySQL will
not run as root), and then give that as an option during compile
(--with-mysqld-user=mysql).  Once I did this, I was able to su up to the
mysql user and start the daemon.

I've come in late on this thread, but ISTR that http://www.mysql.com/
kept a fairly complete set of documentation online, including
step-by-steps to building, installing and first-time running of the
database.

HTH,

- -- 
Ed Vazquez
Senior Security Engineer
Inflow, Inc. (http://www.inflow.com/home.asp)
303.942.3211

These days, if I owned the M$ division that built Lookout and
SexChange, I'd trade it for a dog, and then I'd shoot the dog.
- --Mike Andrews in the Monastery.

On Thu, 31 May 2001, Scott McClelland wrote:

> Date: Thu, 31 May 2001 15:50:52 -0700
> From: Scott McClelland <smcclell at vortexdata.com>
> To: "'rt-users at lists.fsck.com'" <rt-users at lists.fsck.com>
> Cc: "'CChang at thesupply.com'" <CChang at thesupply.com>
> Subject: [rt-users] RE: Can't connect to local MySQL server through socket
>
> Here is Cassie's reply.  Anybody have any idea what to try next?  Maybe
> reinstall MySQL from rpms or srpms?
>
> A reinstall should also stop any mysql servers during the installation.  You
> could also try killall mysqld, (or reboot the server).  It does appear to be
> running, if you were able to attach to it.
>
> /*------------------------------------------
> Scott McClelland, CNE, MCP
> Network Administrator
> Vortex Data Systems
> http://www.vortexdata.com
> --------------------------------------------*/
>
>
>
> > -----Original Message-----
> > From: Cassie Chang [mailto:CChang at thesupply.com]
> > Sent: Thursday, May 31, 2001 3:27 PM
> > To: 'Scott McClelland'
> > Subject: RE: Can't connect to local MySQL server through socket
> >
> >
> > Scott,
> >
> > What distribution of Linux (cat /etc/issue)
> >  - Redhat Linux 7.1
> >    Kernel 2.4 2-2 on an i686
> >
> > What version of MySQL, and what install method - rpm, binary,
> > source (rpm -q
> > MySQL)
> >   - 3.23.38  binary
> >
> > Did you install MySQL as root?
> >   - yes
> > Are you trying to run safe_mysqld as root?
> >   - yes
> >
> > I ran mysqladmin -h budlight(my host name) --port=3306 variables
> > (as stated in 22.3 mysql online doc), it tells me my socket is
> > /tmp/mysql.sock
> >
> > that means I already have a mysql server running on that port 3306
> > but I can not see the process in ps, I can not find mysql.sock file
> > I do not know how to either remove that server on that port or ?
> >
> > Cassie
> >
> >
> > /*------------------------------------------
> > Scott McClelland, CNE, MCP
> > Network Administrator
> > Vortex Data Systems
> > http://www.vortexdata.com
> > --------------------------------------------*/
> >
> >
> >
> > > -----Original Message-----
> > > From: Cassie Chang [mailto:CChang at thesupply.com]
> > > Sent: Thursday, May 31, 2001 2:20 PM
> > > To: 'Scott McClelland'
> > > Subject: RE: Can't connect to local MySQL server through socket
> > >
> > >
> > > Scott,
> > >
> > > I rename my.cnf to my.cnf1
> > > I do ps -ax | grep mysql - no mysql process running
> > >
> > > I bin/safe_mysqld &
> > >   -it said mysql ended
> > >
> > > I check the hostname.err
> > > error message is:
> > > "Can't start server: Bind on TCP/IP port; Address already in use
> > > Do you have another server running on port 3306"
> > >
> > > ? Thanks
> > > Cassie
> >
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (OpenBSD)
Comment: For info see http://www.gnupg.org

iD8DBQE7Fs3IsgiUrZLjn0MRAkY5AJ9/Sqxaye1F+SrrkYtON/ru3HO5IQCgjr8K
XBy39LtRQkVdm4f3+Fu67kQ=
=mVc2
-----END PGP SIGNATURE-----