Problem:
Couldn’t connect to MySQL on TGIIS from TGSQL
Solution:
Try this command (after logging into mysql with root)
GRANT ALL PRIVILEGES ON *.* TO ‘myaccount’@’%’ IDENTIFIED BY ‘some_pass’ WITH GRANT OPTION;
where myaccount is any new account you want to create.
Note the hostname is ‘%’ which gives blanket permission to allow logging in FROM anywhere.