Setting up MySQL Workbench - domflannery/mysql-sandbox GitHub Wiki

Setting up a connection on your host machine to the different MySQL VM's is easy. You set it up just like any other connection. In the below screenshot you can see we're giving the connection a name (db1). Then we add the IP to the hostname box, in this case it's 10.11.1.103. You can also consult the Vagrantfile to see what the static IP's are for the other db's. As a part of the ansible setup, we allow the root user to connect from both @localhost on the local machine as well as from @10.11.1.1 which is the host machine. So for username, you can add root. As a security note, I wouldn't normally allow root to connect outside of localhost, this is just for learning and POC purposes. To store the password, you can click on "store in vault" and enter the default password we set up with ansible MyNewPass6^.