How To Set Up a Remote Database to Optimize Site Performance with MySQL

Set Up Remote Database

Now that we have MySQL configured listening on an external address, we need to create a database and establish a remote user. Even though MySQL itself is now listening on an IP address that other machines can connect to, there are not currently any databases that it can access. This is also an opportunity for us to establish different privileges based on where a user is connecting from. We can create two “users” that can actually just be the same username, but associated with different hosts. Continue reading “How To Set Up a Remote Database to Optimize Site Performance with MySQL”