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
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 it out
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 BY
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:
mysql CREATE USER dev
- 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 you will find out if you have multiple
- 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
of mysql that you do not want to /dev/null
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
can start your [second] instance.
# ps wax
- 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
- 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 801) is shut down
properly, then probe
- 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 problems
if there is another
- 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 bash...the standard shell. Didn't
- 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. The matches were inexact
- 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 when I hit the up arrow
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
- 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 it's
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#
- 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
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
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 0 0 *.3306
19 matches
Mail list logo