MySQL troubleshooting - Can’t login remotely

The problem:

Can’t login remotely, can login only from the server itself.

The reason: 

Permissions for remote login are missing.

Solution – Linux:

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

Check with:

SELECT host, user, authentication_string  FROM user ;

Solution – Windows:

From MySQL Workbench, on the instance connection, Users and Privilages, choose the user (root) and change “Limit to host matching” to “%”.