Re: partioning question

[Rick James]

GRANT ... TO 'user'@'host.name.com' IDENTIFIED BY 'password';

Then connect to 'host.name.com' instead of 'localhost'.

You will need multiple connections because of the multiple servers.