mysql host...

[814578]

i have an admin account on mysql...
i've just changed the host field of user table, for the user admin...
it was localhost , but now localhost,85.96.145.45
now i'm unable to connect mysql, both from localhost and from the ip below...
how can i rechange the host to localhost.....
pc:i have root account on shell, no other admin level account on mysql...
thanx..

 

[TonyGroves]

The host field should only contain one address or mask. You should have added a separate record for the new IP address.

If you can connect as an ordinary user, then you could use the following trick:

1. Copy the user table files into a database to which ordinary users have write access.
2. Using an ordinary user account, change that field to read "localhost".
3. Stop the server.
4. Copy the files back into the "mysql" database.
5. Restart the server.
6. You should now be able to connect as root.