MySQL Error:host isn't allowed to connect to this MySQL server

The following error occurred while accessing MySQL in the virtual machine:

Cause: The MySQL user does not allow remote logins

Resolution: Authorization

1> allows users to connect to MySQL server from any host

GRANT  All Privileges  on *. *  to ' username '@ '%' by'password'  WithGRANTOPTIONprivileges;

2> allows users to access MySQL server from a specified IP

Where host is a specific IP address

GRANT  All Privileges  on *. *  to ' username '@'host'by'password'  with GRANT OPTION  Privileges;

3> allows users to access MySQL server specified database from a specific IP

Where host is a specific IP address

GRANT  All Privileges  on dbname. *  to ' username '@ 'host'by'password' with GRANT OPTION  Privileges;

MySQL Error:host is not allowed to connect to this MySQL server