I could now log on to mysql with my new password using webmin, but for some reason it wouldn't work on the command line.
I could see only one encrypted password for user root on host local host with permission All. Another root with host server0.tld has blank space for encrypted password and permission is ALL.
Then there is 2 anonymous users, for host localhost and server0.tld with blanks for encrypted password and permission NONE.
I don't know if this gives the clear picture of the table, but can anyone help me make things right? I tried to copy and paste the table but it keeps messing up as scrumbled eggs.