I have a project where I will need to use MySQL server. I have a shared drive and I do not have permission to make the MySQL server public by domain, meaning that only localhost works.

I can place the datadir on the shared drive and I can connect the first MySQL client/server/instance to the datadir with my portable MySQL.

The problem comes when I run another portable MySQL client/server/instance on another PC to the same datadir that was on the shared drive. It gives an error saying that the datadir is already in use.

Can anyone tell me how can I make more than one MySQL connect to that datadir at the same time?

This is to make an app with Visual Basic to manage the database so I need to have the server connection and only works with localhost.