netstat -nlp | grep 3306
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]