Connecting to MySQL :: MySQL Query Browser :: MySQL error number 1130

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.