MySQL failure

[James Gray]

On Fri, 12 May 2006 01:32 am, Michael Satterwhite wrote:
> I'm sure I'm ignoring the obvious on this and another one that I'll post
> about later.
>
> This morning I upgraded to the latest level of KDE. Since that time, I
> can't get mysql to start.  I get the following:
>
> michael at photon:/var/log$ sudo mysqld_safe
> Starting mysqld daemon with databases from /var/lib/mysql
> mysqld_safe[9710]: started
> STOPPING server from pid file /var/run/mysqld/mysqld.pid
> mysqld_safe[9716]: ended
> michael at photon:/var/log$
>
> Looking at the logs, it's possible that something has port 3306 (From
> syslog May 11 10:26:58 photon mysqld[9765]: 060511 10:26:58 Can't start
> server: Bind on TCP/IP port: Cannot assign requested address
> May 11 10:26:58 photon mysqld[9765]: 060511 10:26:58 Do you already have
> another mysqld server running on port: 3306 ?)
>
> I definitely don't have another instance of mysql running. I'm sure I'm
> missing the obvious, but I need to get this going. Would one of you offer a
> little help. I'd really appreciate it.

Kernels don't lie - if port 3306 is already bound to another process, then 
SOMETHING has it :)

sudo lsof -P | grep :3306
sudo netstat -tadln

Should reveal the culprit.  If you're still turning up blanks, try piping the 
output of that "lsof" through "less" and search for stuff inside less.  Hint: 
hitting "/" followed by search term in less will search for and highlight 
each occurence of the search term.  To jump to the next occurence of a search 
term, hit "n".  "man less" for all the nitty-gritty.

HTH,

James
-- 
You know it's going to be a long day when you get up, shave and shower,
start to get dressed and your shoes are still warm.
		-- Dean Webber
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20060512/13066c1b/attachment.sig>