How to whitelist all connections in MySQL It would be convenient for me to whitelist a server so that anyone with the username and password can connect to it remotely? Is this possible? I do understand this is horrible for security purposes if it's even possible (I haven't found anything that mentions a way to do such.)
This should be easily achieved by issuing the command:

GRANT ALL ON *.* to user@'%'; -- you can also use dbname.* to restrict their 
                              -- access to a given database.


as explained here and here.

You can do some restricting (normally a good idea) by making use of the wildcard (% is the MySQL wildcard) - you can also do '%.domain.com' or '%.123.123.123' or similar if necessary.

You don't have to GRANT ALL PRIVILEGES - you could just give them SELECT and/or UPDATE for example and not INSERT... This is all explained here.