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?
mysqld.exe --skip-grant-tables
localhost
and a 127.0.0.1
record for root to the mysql.user table)