[GRLUG] mysqld problem

[Adam Tauno Williams]

On Tue, 2012-08-21 at 20:33 -0500, L. V. Lammert wrote:
> On Tue, 21 Aug 2012, Ben DeMott wrote:
> > Hi Lee,
> > What happens if you try to start mysql yourself without the daemon /
> > service script?
> > perhaps 'mysqld --console'
> > Is there an exit code from the process?
> I tried starting it without the script, but it complained that another
> copy was already using 3306.

fuser -n tcp 3306

strace mysqld --console  would probably tell you if it is actually
trying to open the port and failing or checking a related lock file.

> Also tried forcing MyISAM recover and InnoDB recover options in my.cnf,
> but no difference.
> mysqld_save and the init script would both delay for a time and then
> return a status of failure.
> Using mysqld without the startup script complained about the port being in
> use, however netstat -an and telnet'ing to 3306 from an outside machine

telnet is a *bad* way to test the use of a port, a variety of things can
make it impossible to connect to a listening port.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
URL: <http://shinobu.grlug.org/pipermail/grlug/attachments/20120822/c0550c43/attachment.pgp>