Quote
I have MySQL server running on my desktop computer. I am trying to figure out how to make the db file, which is also on my desktop computer, accessible via the server so that I can peruse its contents. The only reason I mentioned the Raspberry Pi is that that is the source of the file.
For an RDBMS like MySQL, a database is not a file, "peruse the file" is meaningless.
If MySQL server is running on your PC, what is its datadir setting in my.ini? If you've set the datadir to a folder on the pi, then please explain what problem does that solve for you because you've designed a serious vulnerability into your database configuration---datadir should be on a fixed disk of the PC.
And I'm pretty sure there are, unfortunately, limitations on MySQL Workbench's capacities to work with MariaDB servers. I think there is a non-Oracle workbench app that does work with MariaDB.
Edited 2 time(s). Last edit at 09/11/2021 04:36PM by Peter Brawley.