How can I connect Workbench to a MySQL database inside an Ubuntu VMWare VM?
Posted on 2011-03-04
Apologies for the novice question, but I'm new to MySQL and Ubuntu, so still feeling my way around!
We've set up an Ubuntu Virtual Machine on a Windows XP PC, and have installed OpenEMR on it, which is an open-source LAMP medical records application. (The idea is to use this VM as an appliance, containing the back-end.) I can successfully use a browser to access the application, and thus create/edit/delete records in the MySQL database, but when I try using Workbench to 'remotely' administer MySQL from the Windows XP side, I can't seem to connect...
I really need to be able to remotely administer the database inside this VM, and am also keen to set up an ODBC link to it (yes, please don't hit me, but I want to map some of these tables into SQL Server!).
Very grateful for any help anyone can give me - note that I *don't* have workbench installed *within* the VM, so if there's a solution that avoids me having to do that, even better.
Many thanks, Sam.