MySQL Administration - Remote Access

1. Create an account

CREATE USER [username]@'IP' IDENTIFIED BY '[password]';

2. Grant Permissions - IP can be replaced with % to allow this user to logon from any host or IP.

GRANT ALL PRIVILEGES ON *.* TO [username]@'IP' IDENTIFIED BY '[password]';

3. Apply any changes on settings related to privileges without restarting MySQL

mysql -u username -p password -e "flush privileges";