I have a VM in VirtualBox running a Ubuntu 64-bit server that I want to use as a test/local server. I have mysql installed in the VM and am managing it using MySQL Workbench installed on my host laptop (Windows 7 64-bit).
I have it setup currently where anyone who knows the root password can login to mysql as root from any machine (added an entry to the permissions table with root at location
%, commented out all bind-address lines in my-cnf), but what I'd really like to have is a situation where root access is only allowed from my host machine and from the VM. I want to maintain the ability to communicate with my VM from any computer in my local network (which I have right now), and the host machine must be able to have a dynamic IP.
The VM server is currently setup to use a Bridged Adapter network (hooked to my host wifi driver) and has a dynamic IP as well, though I don't see this being a requirement as long as my VM server can still access the internet for software updates and the VM and host machine can communicate back and forth with each other (for putty access, mysql maintenance, local webpage server, etc.).
How would I go about doing this, and is it even possible? Let me know if there's any other info I should post.