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

[Scott McClelland]

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
>