0

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?

kapa
  • 77,694
  • 21
  • 158
  • 175
shikarishambu
  • 2,219
  • 6
  • 35
  • 57
  • did you flush privilege? Try restarting the MySQL service. Sometime it helps solving many problem :) – Rifat Oct 08 '11 at 15:09

1 Answers1

1
  • Stop MySQL server
  • Restart it on the command line, skipping authorizations: mysqld.exe --skip-grant-tables
  • Fix your permissions (add both a localhost and a 127.0.0.1 record for root to the mysql.user table)
  • Stop MySQL server
  • Start MySQL normally
stivlo
  • 83,644
  • 31
  • 142
  • 199