MySQL Forums
Forum List  »  MySQL Workbench

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


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

Written By
September 11, 2021 09:31AM
September 11, 2021 10:58AM
September 11, 2021 04:16PM
Re: Connecting to a database file
September 11, 2021 04:29PM
September 11, 2021 08:45PM
September 12, 2021 10:55AM
September 12, 2021 02:18PM
September 12, 2021 02:32PM
September 13, 2021 07:58AM
September 13, 2021 11:03AM

Sorry, you can't reply to this topic. It has been closed.

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.