ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
Article:
  Apache Web-Serving With Mac OS X, Part 5
Subject:   Can't start server: Bind on TCP/IP port: Address already in use
Date:   2002-06-30 03:24:47
From:   mrx1
OS X Client 10.1.5 with default Apache/PHP installed (and working)
MySQL: mysql-3.23.49.pkg from Marc Liyanage.


First of, I’m a total newbie in this stuff, so please be nice to me! :)
The install seems fairly straight forward and the instructions are clear BUT:


After installing the package, when I try runnig the “sudo ./scripts/mysql_install_db” I get this:


Password:
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
ERROR: 1062 Duplicate entry 'localhost-root' for key 1
ERROR: 1062 Duplicate entry 'localhost-root' for key 1
020630 9:50:49 ./bin/mysqld: Shutdown Complete


This ERROR thing at the end doesn’t look too good but I don’t give up! I still follow the instructions and change the owner with “chown” etc...: Then, when I run the “mysql test” I get this:


ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)


To try to get a clue on what’s going on, I look at the error log:


[localhost:local/mysql/data] dabest% tail localhost.err


020630 09:59:04 mysqld started
020630 9:59:04 Can't start server: Bind on TCP/IP port: Address already in use
020630 9:59:04 Do you already have another mysqld server running on port: 3306 ?
020630 9:59:04 Aborting


020630 9:59:04 /usr/local/mysql/bin/mysqld: Shutdown Complete


020630 09:59:04 mysqld ended


OK, this error log looks pretty consistant with the ERROR from the install (although the author says lower that it's a message that can be ignored, I just mention it in case). BUT, as I said, I’m just trying to follow the instructions and I have no idea how to fix that or what it means. Looks like I got twice the same thing but that’s the first time I try installing MySQL and I’m not on OSX Server so I don’t think it comes pre-installed... I don’t know how to check what’s using this “TCP/IP port” and even if I did, I wouldn’t know what to do about it...
What to do? Help anyone? Thanks!