Can't Bind to Port

2007-03-02 Thread Drew Jenkins
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

Re: Can't Bind to Port

2007-03-02 Thread Drew Jenkins
- 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 sh

Re: Can't Bind to Port

2007-03-02 Thread Drew Jenkins
Oops. Forgot to add I passed it tcp as the protocol and it returned blank: # netstat -nlp tcp| grep 3306 # I presume that means nothing's listening on that port? If so, then why did nmap return mysql on that port? At any rate, what do? TIA, Drew

Re: Can't Bind to Port

2007-03-02 Thread Drew Jenkins
26- Original Message From: Tommy Nordgren <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Friday, March 2, 2007 7:32:16 PM Subject: Re: Can't Bind to Port server312# netstat -nlap tcp | grep 3306 tcp4

Re: Can't Bind to Port

2007-03-03 Thread Drew Jenkins
- Original Message From: Tommy Nordgren <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Saturday, March 3, 2007 5:00:26 AM Subject: Re: Can't Bind to Port >Try the command: >find / -name mysql 2>/dev/null >then

Re: Can't Bind to Port

2007-03-03 Thread Drew Jenkins
- Original Message From: ed <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Sent: Saturday, March 3, 2007 10:24:54 AM Subject: Re: Can't Bind to Port >be root/superuser; >try it as "find / -name mysql" and then, (as in 2nd) send they instances

Re: Can't Bind to Port

2007-03-03 Thread Drew Jenkins
26- Original Message From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Sent: Saturday, March 3, 2007 10:53:45 AM Subject: Re: Can't Bind to Port >kill off the first instance, the port will/should free up and then you >

Re: Can't Bind to Port

2007-03-03 Thread Drew Jenkins
- 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/mysq

Re: Can't Bind to Port

2007-03-03 Thread Drew Jenkins
- Original Message From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Sent: Saturday, March 3, 2007 12:03:40 PM Subject: Re: Can't Bind to Port >At this point, make >certain that the mysql instance that you started (pid

Re: Can't Bind to Port

2007-03-03 Thread Drew Jenkins
- Original Message From: Tommy Nordgren <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Saturday, March 3, 2007 12:34:37 PM Subject: Re: Can't Bind to Port >There is no need to be superuser to run find. But there can be p

Re: Can't Bind to Port

2007-03-03 Thread Drew Jenkins
- Original Message From: Tommy Nordgren <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Sent: Saturday, March 3, 2007 1:03:30 PM Subject: Re: Can't Bind to Port >You are probably using another shell than bash or another sh variant. No, I'm using

Re: Can't Bind to Port

2007-03-03 Thread Drew Jenkins
- Original Message From: ed <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Sent: Saturday, March 3, 2007 1:06:16 PM Subject: Re: Can't Bind to Port None of those directories existed on my system. So I decided to try and find the ones to which you referred.

Re: Can't Bind to Port

2007-03-03 Thread Drew Jenkins
- Original Message From: Tommy Nordgren <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Sent: Saturday, March 3, 2007 1:39:14 PM Subject: Re: Can't Bind to Port Well, I don't know what you do with this one, Tommy. I just cut and pasted your command, but w

Re: Can't Bind to Port

2007-03-03 Thread Drew Jenkins
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

Re: [MySQL] Re: Can't Bind to Port

2007-03-03 Thread Drew Jenkins
- Original Message From: Ashley M. Kirchner <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Saturday, March 3, 2007 4:09:41 PM Subject: Re: [MySQL] Re: Can't Bind to Port >This indicates that you did indeed start the daemon. >So then why are you trying to start it again? Of course i

Crashed Again!

2007-03-09 Thread Drew Jenkins
I built a new server at my server farm because the old one was corrupt. I had a hunch it had to do with the new 500 GB hard drive I bought. I told them to check it out. Apparently, they didn't. It zapped my database. I went to deinstall and reinstall mysql from FBSD port, but when I run it I get

Re: Crashed Again!

2007-03-09 Thread Drew Jenkins
Never mind. I forgot this command: /usr/local/bin/mysql_install_db --user=mysql Drew2 Drew Jenkins <[EMAIL PROTECTED]> wrote: I built a new server at my server farm because the old one was corrupt. I had a hunch it had to do with the new 500 GB hard drive I bought. I told them to check

Problems w/ Grant Tables

2007-03-09 Thread Drew Jenkins
Hi; I rebuilt mysql and injected the database which had user "mysqluser" and a root user. Both got wiped out. It looks like the data is intact other than that. Look at this: mysql> CREATE USER dev IDENTIFIED BY 'pass'; Query OK, 0 rows affected (0.04 sec) mysql> CREATE USER mysqluser IDENTIFIED

Re: Problems w/ Grant Tables

2007-03-09 Thread Drew Jenkins
Problem solved: /usr/local/bin/mysql_fix_privilege_tables2 Drew Jenkins <[EMAIL PROTECTED]> wrote: Hi; I rebuilt mysql and injected the database which had user "mysqluser" and a root user. Both got wiped out. It looks like the data is intact other than that. Look at this: my