Error in login in with root user in new mysql serverThe 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.