108 reputation
4
bio website vintem.com.br
location Quebec
age 33
visits member for 2 years, 4 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.


Oct
5
awarded  Popular Question
Jun
13
awarded  Scholar
Jun
13
comment Error in login in with root user in new mysql server
Perfect, that was it!!!
Jun
13
accepted Error in login in with root user in new mysql server
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.
Jun
13
awarded  Student
Jun
13
asked Error in login in with root user in new mysql server
Jun
13
awarded  Autobiographer