MySQL Forums
Forum List  »  MySQL Workbench

Re: Connecting to a database file
Posted by: Peter Brawley
Date: September 11, 2021 04:29PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
127
September 11, 2021 09:31AM
47
September 11, 2021 10:58AM
22
September 11, 2021 04:16PM
Re: Connecting to a database file
26
September 11, 2021 04:29PM
26
September 11, 2021 08:45PM
32
September 12, 2021 10:55AM
26
September 12, 2021 02:18PM
27
September 12, 2021 02:32PM
21
September 13, 2021 07:58AM
24
September 13, 2021 11:03AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.