Database external access.

+------------------------------------------------- ---------------------------------------------------------------------+

|Grants for usr1@%                                                                                                                 |

I have the solution.

By default, the MariaDB server is listening on localhost only for security reasons. You can check it with the following command:

$ netstat -ant | grep 3306

In the following output, you should see that the MariaDB server is listening on localhost (127.0.0.1):

tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN



The first thing you need to do is to configure the MariaDB server to listen to all IP addresses on the system.

You can do it by editing the MariaDB default configuration file/etc/mysql/mariadb.conf.d/50-server.cnf. You can open this file using your favorite text editor:

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

Change the value of the bind-address from 127.0.0.1 to 0.0.0.0 so that MariaDB server accepts connections on all host IPv4 interfaces.

bind-address = 0.0.0.0

Ctrl+O to write file
Ctrl+X to close file

and reboot iot.


The solution is based in the next link.

Thanks for alot.

Best regards!​

​