How to connect to remote mysql server. Grant privileges
GRANT ALL PRIVILEGES ON *.* TO 'root'@'web.webhost.net' IDENTIFIED BY 'root-password-here';
Blog
GRANT ALL PRIVILEGES ON *.* TO 'root'@'web.webhost.net' IDENTIFIED BY 'root-password-here';