20----- Original Message ---- From: ed <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Sent: Saturday, March 3, 2007 12:16:42 PM Subject: Re: Can't Bind to Port
I figured it wouldn't hurt anything to change permissions on files, so I went ahead and changed all the permissions everywhere. I even deleted the symlinks and copied over the original files to which they pointed and changed those permissions to mysql:mysql. That didn't work. Again, here are the dirs in which I changed permissions: /usr/local/include/mysql /usr/local/lib/mysql /usr/local/libdata/ldconfig/mysql /usr/local/share/mysql /var/db/mysql /var/db/mysql/mysql (Actually, some of these were already changed.) I changed permissions on this file, tried my command that has kept failing, then changed them back: /usr/local/libexec/mysqld I didn't change permissions for the following: /usr/local/bin/mysql They're still owned by root. Is that correct? Seemed it needed to be owned by root. At any rate, unless I've missed something, I think that settles the issue of this not being a permissions problem...I think! Any other ideas? Tommy, still can't run your command. TIA, Drew Drew Jenkins wrote: > ----- Original Message ---- > From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > To: Drew Jenkins <[EMAIL PROTECTED]> > Sent: Saturday, March 3, 2007 11:25:37 AM > Subject: Re: Can't Bind to Port > > I rebooted, then... > > server312# ps wax|grep mysqld > server312# /usr/local/bin/mysqld_safe & > [1] 801 > server312# Starting mysqld daemon with databases from /var/db/mysql > > server312# ps wax | grep mysqld > 801 p0 S 0:00.01 /bin/sh /usr/local/bin/mysqld_safe > 849 p0 S 0:00.16 /usr/local/libexec/mysqld --basedir=/usr/local > --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/my > server312# /usr/local/libexec/mysqld -uroot -hlocalhost > --max_allowed_packet=999M > 070303 9:42:18 InnoDB: Started; log sequence number 0 46403 > /usr/local/libexec/mysqld: Table 'mysql.general_log' doesn't exist > 070303 9:42:18 [ERROR] Can't start server: Bind on TCP/IP port: Address > already in use > 070303 9:42:18 [ERROR] Do you already have another mysqld server running on > port: 3306 ? > 070303 9:42:18 [ERROR] Aborting > > 070303 9:42:18 InnoDB: Starting shutdown... > 070303 9:42:20 InnoDB: Shutdown completed; log sequence number 0 46403 > 070303 9:42:20 [Note] /usr/local/libexec/mysqld: Shutdown complete > > I must be the only person in this conversation that remains unconvinced that > there are *two* mysql servers running. > TIA, > Drew > > > > > ____________________________________________________________________________________ Get your own web address. Have a HUGE year through Yahoo! Small Business. http://smallbusiness.yahoo.com/domains/?p=BESTDEAL
