SQL Remote Access

So, if you need to allow another host to connect to a mysql DB here’s how you can accomplish this:

GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ ¬†identified by ‘password’;

the % allows all host with the user root.