With Beekeeper studio, create a new connection, select MySQL as the connection type and fill out the following details (Figure C): Host: The IP address or domain of your MySQL server. Port: 3306.

Now that we’ve set up our MySQL server to allow remote connections, we need to create a new user and give it the correct permissions. To do this: Log in to the MySQL console with: sudo mysql -u ...