I want to know what 's in a database, only issue it 's on a RPi I have tucked away and I only h...

[G+_Jason Perry]

I want to know what's in a database, only issue it's on a RPi I have tucked away and I only have SSH access to it, and I was to keep it that way. Is there an easier way than installing g sqlite and writing a python script?

[G+_Akira Yamanita]

You could query the database directly via the CLI or copy it to another system that has the software that you need to read the SQLite database. You would just need an SFTP client or use scp to copy it.

[G+_Brandon M]

yeah I would just use the appropriate CLI program to use your DB. If you have a particular query you can run something like

 

ssh user@server -t 'mysql -u root -pPassword dbname -e "SELECT * FROM table"' but you would use something more appropriate for your database type. This is assuming the database runs on a service and isn't just a random database file floating on the RPi

[G+_Travis Hershberger]

You could always allow network access to the database. If it's running Raspbian, you might already have access to it on port 3389.

[G+_Ben Reese]

Could maybe use SFTP to copy the sqlite DB to your phone and open it with something like aSQLiteManager. I don't know of any way to open a remote SQLite DB.

[G+_Travis Hershberger]

What OS is the RPi running? I could have you connecting to it with a remote MySql Workbench quick with an OS I know.

[G+_Jason Perry]

Raspbian Jessie

[G+_Jason Perry]

Honestly it is for my MQTT broker so I don't know if it is password protected

[G+_Travis Hershberger]

Jason Perry Ok, so far so good. Do you have any db users created besides root? (root is always limited to the local terminal only.)

 

If you already do, you could plug that user information and the RPi IP into MySQL Workbench and it'll just work.

 

If not, you can follow this guide: https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql

[G+_David Wiggins]

Yeah, depending on the type of DB, most management clients allow network access (is the DB has been configured to allow-note, most can be set to allow only specific IPs).

MySQL workbench, postgres client, and so on. Travis Hershberger?hit the nail on the head. Workbench has a great GUI, there are others as well, one that runs in Java that my DBA recommend that I can't remember the name of.