Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-16 Thread Érico
ok

I have tried these :

ifconfig -a
lo0: flags=8049UP,LOOPBACK,RUNNING,MULTICAST mtu 16384
inet6 ::1 prefixlen 128
inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1
inet 127.0.0.1 netmask 0xff00
gif0: flags=8010POINTOPOINT,MULTICAST mtu 1280
stf0: flags=0 mtu 1280
fw0: flags=8863UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST mtu 4078
lladdr 70:cd:60:ff:fe:eb:72:ea
media: autoselect full-duplex
status: inactive
en1: flags=8863UP,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 0x broadcast 169.254.255.255
media: autoselect
status: active
en0: flags=8863UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST mtu 1500
ether c8:2a:14:1a:47:ea
media: autoselect (none)
status: inactive
wc2: flags=822BROADCAST,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
ff801403c280 stream  0  00
ff801403b20000 /tmp/mysql.sock
ff801403a9c0 stream  0  0 ff801bbb78b8
000 /tmp/mysql.sock
ff8013fb0bc0 stream  0  0 ff8014aa8078
000 /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 claudio.na...@gmail.com

 Hi


   |  | ericomtxmacbookpro.local |
  *E85DC00A0137C6171923BE35EDD809573FB3AB4F |
  


 mysql DELETE FROM mysql.user WHERE user='';
 mysql FLUSH PRIVILEGES;

 maybe helps?

 Cheers

 --
 Claudio



Fosdem 2014 MySQL Friends devroom and Community Dinner

2014-01-16 Thread Frédéric Descamps
Hi all, 

The schedule for the devroom is now online
https://fosdem.org/2014/schedule/track/mysql/

and please don't forget to register for the Community Dinner:
http://www.eventbrite.com/e/fosdem-mysql-and-friends-community-dinner-2014-tickets-10152563591

See you as much as possible in Brussels !


-- 
Frédéric Descamps, Consultant, Percona
Mob: +32 495698668 (CET) 
Skype: lefred.descamps
Jabber: frederic.desca...@percona.com

24/7 Emergency Line +1 888 401 3401 ext 911

Our Services: http://www.percona.com/services.html
Our Blog: http://www.mysqlperformanceblog.com/

Percona Training Workshops: http://www.percona.com/training/





signature.asc
Description: This is a digitally signed message part