MySQL MariaDB Server Raspberry Pi remote access [closed]

Question

Closed. This question is not about programming or software development. It is not currently accepting answers.

This question does not appear to be about a specific programming problem, a software algorithm, or software tools primarily used by programmers. If you believe the question would be on-topic on another Stack Exchange site, you can leave a comment to explain where the question may be able to be answered.

Closed 21 days ago.

Improve this question

I have a working MySQL (MariaDB) Server running on my raspberry pi. It works fine when I want to connect to it from my local network.
My specs are as followed:

MariaDB [mysql]> SHOW VARIABLES LIKE "%version%";
+-----------------------------------+------------------------------------------+
| Variable_name                     | Value                                    |
+-----------------------------------+------------------------------------------+
| in_predicate_conversion_threshold | 1000                                     |
| innodb_version                    | 10.3.22                                  |
| protocol_version                  | 10                                       |
| slave_type_conversions            |                                          |
| system_versioning_alter_history   | ERROR                                    |
| system_versioning_asof            | DEFAULT                                  |
| version                           | 10.3.22-MariaDB-0+deb10u1                |
| version_comment                   | Raspbian 10                              |
| version_compile_machine           | armv8l                                   |
| version_compile_os                | debian-linux-gnueabihf                   |
| version_malloc_library            | system                                   |
| version_source_revision           | 0152704ae3f857668dbc05803950adcf131b8685 |
| version_ssl_library               | YaSSL 2.4.4                              |
| wsrep_patch_version               | wsrep_25.24                              |
+-----------------------------------+------------------------------------------+
14 rows in set (0.013 sec)

But I want to be able to access it not only from my local network I want to be able to access it from everywhere in the world. How do I do that ?

Linh Dao · Accepted Answer · 2022-09-10 17:14:17Z

7

For Raspberry Pi 4 and MariaDB version:

10.5.15-MariaDB-0+deb11u1 Debian 11

you will need to edit the right configuration file as below:

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

and set the bind address:

bind-address = 0.0.0.0

then restart the MariaDB service:

sudo service mariadb restart

answered Sep 10, 2022 at 17:14

Linh Dao

1,7331 gold badge29 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

The Impaler · Accepted Answer · 2020-06-24 22:27:30Z

6

I wouldn't recommend you to expose a database to the world. Usually a database will seat behind of an app server that will serve web pages, web services (or rest calls). This app server will read or write to the database as needed.

Having said that, it's technically possible to expose the database. Again, don't do it. ...but if you must:

Configure the engine to serve remote hosts, and not just the local apps:
```
 sudo vi /etc/mysql/my.cnf
```
and set the bind address to:
```
 bind-address            = 0.0.0.0
```
then, restart the engine:
```
 sudo service mysql restart
```
Create a MariaDB user with access from everywhere (using @'%'), as in:
```
 create user 'myuser'@'%' identified by 'mypass';
```
Grant this user access to a database (assuming you already created a database):
```
 grant all on my_database.* to 'myuser'@'%';
```
Finally, open your home firewall. Enter the admin page of your router and find the "Port Forwarding" section. There, add a rule to listen to the world to port 3306 (TCP) and redirect it to your local raspberry pi IP address. Save the rule. You may need to restart the router.

That's it. Your raspberri pi database is now listening to the world. I would suggest configuring SSL on the connection at least, so passwords (and data) are not sent in plain text over the wire.

Extra, for the same price: Listening on which address, you may ask? Your home address as seen by your ISP. Now, can I use a fake domain name in case the IP changes, you may ask? You can use a free DNS service such as duckdns.org. It's free and works like a charm in a raspoberry pi (I use it since 2015).

answered Jun 24, 2020 at 22:27

The Impaler

49.3k10 gold badges50 silver badges90 bronze badges

2 Comments

SebNik Over a year ago

I still have a question. I have a big data table and I want to be able to work with it with many persons from around the world. How can I build a save server which host this data? Is the raspberry pi with a mariadb there the right choice ?

The Impaler Over a year ago

@SebNik For testing purposes a MariaDB will work just fine as any other hosting service, with lower performance (of course). If you are serving a myriad of clients around the world, then a hosting service is the way to go. In terms of performance, and in terms of security. You don't want to expose your home network to the entire world.

Collectives™ on Stack Overflow

MySQL MariaDB Server Raspberry Pi remote access [closed]

2 Answers 2

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Linked

Related