108 reputation
3
bio website vintem.com.br
location Quebec
age 32
visits member for 1 year, 10 months
seen Jun 13 '12 at 20:12

Web Developer for more then ten years working with asp, asp.net, java, c#, sql server and other things. Geek, I love tech, but I always find time to do some sports.


Jun
13
comment Error in login in with root user in new mysql server
Perfect, that was it!!!
Jun
13
comment Error in login in with root user in new mysql server
The first query returned root@localhost for the USER() and CURRENT_USER(). The second query return root for 3 different hosts: localhost, localhost.localdomain and 127.0.0.1. Only root@localhost had its password set. The other two were empty. I ran the command UPDATE mysql.user A INNER JOIN mysql.user B USING (user) SET A.password=B.password WHERE A.password='' AND B.password<>''; FLUSH PRIVILEGES; And after that the other two had passwords, but the issue continues.