queries

configure remote connections on mysql 5

$ mysql -u root -p
mysql> use mysql;
mysql> grant all privileges on *.* to USERNAME@'%' identified by 'MyPassword' with grant option;
mysql> insert into host values('HOSTNAME', '%', 'Y', 'Y', 'Y', 'Y', 'Y','Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
mysql> flush privileges;
mysql> exit