SQL

MySQL: Allow Incoming Access

Edit the user record in the mysql.user table, giving it access to connect to the mysql server from an external host by running the following command at the MySQL interface

grant all privileges on *.* to ‘user’@’IPADDRESS’ identified by ‘password’ with GRANT OPTION;

specify the user, IPADDRESS and password you’d like to use in that command and you’re good to go.