Access denied for user 'root'@'%' (using password yes)

If you specify a host name when trying to connect, but get an error message where the host name is not shown or is an IP address, it means that the MySQL server got an error when trying to resolve the IP address of the client host to a name:

If you try to connect as root and get the following error, it means that you do not have a row in the user table with a User column value of 'root' and that mysql database cannot resolve the host name for your client:

If you do not know the IP address or host name of the machine from which you are connecting, you should '%' as the Host
So you should have to grant all privilege to root for all host by running the following code:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';