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 “%”.
No comments:
Post a Comment