logging using the mysql command 1

[HumbleJoe]

Unfortunately, I was experimenting and I changed the field Host in table User from localhost to %. Now I can no longer logon via the mysql -u root command. It wants to log on as root@localhost and I want to log on as root@%. How do I fix my mistake?

Thanks for your help...

 

[DonQuichote]

If it works, try logging in through 127.0.0.1 with the -h option. If it does not, the manual helps. Look at the server options.