mysqlroot-access

MySQL on Windows - Access denied for user ''@'localhost' - cannot connect from any host


I tried to update my Mysql instance to support remote access. I went to MySQL Administration UI and added % (any host) for user root and removed all other entries.

Now I cannot access MySQL as root from any machine including localhost. What is the best way to fix this?


Solution