ok
I have tried these :
ifconfig -a
lo0: flags=8049<UP,LOOPBACK,RUNNING,MULTICAST> mtu 16384
inet6 ::1 prefixlen 128
inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1
inet 127.0.0.1 netmask 0xff000000
gif0: flags=8010<POINTOPOINT,MULTICAST> mtu 1280
stf0: flags=0<> mtu 1280
fw0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 4078
lladdr 70:cd:60:ff:fe:eb:72:ea
media: autoselect <full-duplex>
status: inactive
en1: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500
ether e4:ce:8f:04:7c:f8
inet6 fe80::e6ce:8fff:fe04:7cf8%en1 prefixlen 64 scopeid 0x5
inet 169.254.99.150 netmask 0xffff0000 broadcast 169.254.255.255
media: autoselect
status: active
en0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500
ether c8:2a:14:1a:47:ea
media: autoselect (none)
status: inactive
wc2: flags=822<BROADCAST,SMART,SIMPLEX> mtu 1500
ether 00:02:55:11:19:76
media: 1000baseT (<unknown type>)
=========================================================================
mac:bin ericomtx$ nslookup localhost
;; connection timed out; no servers could be reached
=========================================================================
mac:bin ericomtx$ netstat -an | grep 3306
tcp46 0 0 *.3306 *.* LISTEN
tcp4 0 0 *.3306 *.* LISTEN
=========================================================================
mac:bin ericomtx$ netstat -ln | grep mysql
ffffff801403c280 stream 0 0 0
ffffff801403b200 0 0 /tmp/mysql.sock
ffffff801403a9c0 stream 0 0 ffffff801bbb78b8
0 0 0 /tmp/mysql.sock
ffffff8013fb0bc0 stream 0 0 ffffff8014aa8078
0 0 0 /opt/local/var/run/mysql5/mysqld.sock
*** here ... this last one is related to a previous mysql macports version
***
=========================================================================
mac:lib ericomtx$ ps xa | grep mysqld
231 ?? S 0:00.01 /bin/sh /opt/local/lib/mysql5/bin/mysqld_safe
--datadir=/opt/local/var/db/mysql5
--pid-file=/opt/local/var/db/mysql5/mac.local.pid
295 ?? S 0:00.74 /opt/local/libexec/mysqld --basedir=/opt/local
--datadir=/opt/local/var/db/mysql5 --user=_mysql
--log-error=/opt/local/var/db/mysql5/mac.local.err
--pid-file=/opt/local/var/db/mysql5/mac.local.pid
--socket=/opt/local/var/run/mysql5/mysqld.sock
2175 s000 S 0:00.02 /bin/sh
/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/bin/mysqld_safe
--datadir=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data
--pid-file=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data/mac.local.pid
2273 s000 S 0:00.35
/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/bin/mysqld
--basedir=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86
--datadir=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data
--plugin-dir=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/lib/plugin
--user=mysql
--log-error=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data/mac.local.err
--pid-file=/Users/ericomtx/development/mysql/mysql-5.6.15-osx10.6-x86/data/mac.local.pid
=========================================================================
I have uninstalled everything related to mysql ports
these dirs no longer exist :
/opt/local/lib/mysql5
/opt/local/libexec
I don't know from where they are getting called
2014/1/15 Claudio Nanni <[email protected]>
> Hi
>
>
>> > > | | ericomtxmacbookpro.local |
>> > *E85DC00A0137C6171923BE35EDD809573FB3AB4F |
>> > >
>>
>
> mysql> DELETE FROM mysql.user WHERE user='';
> mysql> FLUSH PRIVILEGES;
>
> maybe helps?
>
> Cheers
>
> --
> Claudio
>