CODEWITHSUNDEEP
mysqlsshmysql-workbenchraspberry-pi3
JClive
JClive

Reputation: 25

Raspberry Pi 3 connection from MySQL Workbench

My raspberry Pi is currently running as a web-server and is connected to a DNS. I can connect to the raspberry pi via a SSH key through a program called Tera Term and edit information on the raspberry pie. I can open MySQL and edit databases. However, i am unable to connect to the SQL database through MySQL workbench and am unable to connect via a module in android studio.

There seems to be multiple ways to connect to the server:

First is;

Second is;

Is there a definitive way to connect to the raspberry Pi's database via MySQL workbench? Screenshots would be ideal.

Upvotes: 0

Views: 5477

Answers (1)

JClive
JClive

Reputation: 25

So
Edit the bind address in the conf file to "0.0.0.0", Create a user and give all privileges via SQL,
Edit the host.allow file to include "All : 127.0.0.1" for local hosts, Edit the host.allow file to include "All : (External IP)" for connection from (External IP), Edit the Key used to be an open SSH key, only the private key needs converting. This can be done through the putty keygen.

This is how you connect MYSQL to a Raspberry Pi 3B SQL server.

Upvotes: 1

Related Questions