1

I'm working on a Text-based RPG game using C++ in Visual Studio, where I want player account details and infomation to sit on a database, and I have previously been using Microsoft Azure to host a database. However there are a few pricing complications involved and since this is a small project and I'm learning on the way, I'm not sure about this.

I have 2 machines, my main PC and a Laptop, and I sometimes do some SQL practice on my laptop using MySQL Workbench, then I'll code on my main PC. Both of these machine use the same network, and so I want to ask:

If I set up a local database using MySQL Workbench on my laptop, will I be able to connect to it from my main PC? If so this will relieve a load of stress as I can then develop everything locally and then look to push it out to a larger scale in the future.

open surce
  • 55
  • 5

1 Answers1

0

You should be able to connect to the MySQL instance on your laptop from your PC, but you might have to open up the port to new connections.

There are other posts on SO that might be helpful with the specific steps needed: Connect to MySQL Database on Local Network

Might be easiest to just run the same version of MySQL Workbench on both machines.

mgrollins
  • 641
  • 3
  • 9
  • 1
    Thank you @mgrollins, this should be fine then, I can start working on a local connection for this! Yes I know it'll be more simple to run MySQL Workbench on both machines, I just want to get used to connecting to a DB on a different PC altogether if that makes sense. Thank you for this answer! – open surce Jul 23 '19 at 18:40
  • Sure thing! Good luck! – mgrollins Jul 23 '19 at 19:41