Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
4
Impact
~1k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
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.