----- Original Message ---- From: Borokov Smith <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Friday, March 2, 2007 6:21:59 PM Subject: Re: Can't Bind to Port
>netstat -nlp | grep 3306 Option p requires a protocol. What protocol should I give it? Drew greetz, boro Drew Jenkins wrote: > Hi; > I just installed MySQL from FreeBSD port. I specified using openssl. Outside > of that, I changed nothing. I copied over the /etc/my.cnf as is, leaving the > innodb stuff commented out. In preparing to install my database, I got this > error: > > server312# mkdir /usr/local/localhost > server312# chown mysql:mysql /usr/local/localhost/ > server312# /usr/local/libexec/mysqld -uroot -hlocalhost > --max_allowed_packet=999M > InnoDB: The first specified data file ./ibdata1 did not exist: > InnoDB: a new database to be created! > 070302 15:58:29 InnoDB: Setting file ./ibdata1 size to 10 MB > InnoDB: Database physically writes the file full: wait... > 070302 15:58:29 InnoDB: Log file ./ib_logfile0 did not exist: new to be > created > InnoDB: Setting log file ./ib_logfile0 size to 5 MB > InnoDB: Database physically writes the file full: wait... > 070302 15:58:29 InnoDB: Log file ./ib_logfile1 did not exist: new to be > created > InnoDB: Setting log file ./ib_logfile1 size to 5 MB > InnoDB: Database physically writes the file full: wait... > InnoDB: Doublewrite buffer not found: creating new > InnoDB: Doublewrite buffer created > InnoDB: Creating foreign key constraint system tables > InnoDB: Foreign key constraint system tables created > 070302 15:58:29 InnoDB: Started; log sequence number 0 0 > /usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist > 070302 15:58:29 [ERROR] Can't start server: Bind on TCP/IP port: Address > already in use > 070302 15:58:29 [ERROR] Do you already have another mysqld server running on > port: 3306 ? > 070302 15:58:29 [ERROR] Aborting > > 070302 15:58:30 InnoDB: Starting shutdown... > 070302 15:58:32 InnoDB: Shutdown completed; log sequence number 0 46403 > 070302 15:58:32 [Note] /usr/local/libexec/mysqld: Shutdown complete > > # ps wax|grep mysqld > 3986 p1- I 0:00.01 /bin/sh /usr/local/bin/mysqld_safe > 4034 p1- I 0:11.16 /usr/local/libexec/mysqld --basedir=/usr/local > --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my > > server312# nmap localhost > > Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2007-03-02 16:02 UTC > Interesting ports on localhost.by2012.com (127.0.0.1): > Not shown: 1672 closed ports > PORT STATE SERVICE > 22/tcp open ssh > 25/tcp open smtp > 110/tcp open pop3 > 143/tcp open imap > 993/tcp open imaps > 3306/tcp open mysql > 8021/tcp open ftp-proxy > 8080/tcp open http-proxy > > I presume everything went well here until it went to bind to the port. > There's no other MySQL running on the server, so why can't it connect to the > port? This server isn't yet set up with an URL, so if it's reading from > rc.conf or what have you, that could be tripping it up. Please advise. > TIA, > Drew > > > > > > ____________________________________________________________________________________ > Finding fabulous fares is fun. > Let Yahoo! FareChase search your favorite travel sites to find flight and > hotel bargains. > http://farechase.yahoo.com/promo-generic-14795097 > ____________________________________________________________________________________ Looking for earth-friendly autos? Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center. http://autos.yahoo.com/green_center/
