mysql db user host

 Access denied for user 'root'@'xxxxxxxxxxxxx' (using password: YES)

even though I have an entry in mysql.user table that has host as % and user as root.

I did grant all privileges on .开发者_C百科 to 'root'@'%';

I would need to see how you are trying to connect to the server to give you additional information. It is possible that the call to the client (or whatever you are using) is munged in some way.