Topic: Remote Access to MariaDB

[isotropic]

Good evening, gentlemen.
I can access MariaDB. I created a user with a password. But I need to access it remotely. Can you teach me how to open port 3306?
And, if it's not too much to ask, can you show an example of a connection via JDBC?
I use SME 10.1.
Thank you in advance.
Best regards.

[ReetP]

I can access MariaDB. I created a user with a password. But I need to access it remotely. Can you teach me how to open port 3306?

So always check the docs - you'll learn more that way.

https://wiki.koozali.org/Mariadb105

And, if it's not too much to ask, can you show an example of a connection via JDBC?

I have no experience of that. See the notes in the wiki on urls.

Also, bearing in mind your questions (Tomcat too) be VERY careful with what you are doing.

Exposing services remotely when you're not really sure of what you are doing is a rapid route to getting yourself hacked.

Always ask yourself "do I absolutely have to do this or is there a better way?"

As you haven't described what you are actually trying to achieve in either of your posts, I can see you becoming a XY Problem if you aren't careful...... I'm not trying to be unkind, just saving you from yourself!!

https://xyproblem.info/

You may want to read this too.

https://forums.koozali.org/index.php/topic,54724.0.html

Take a deep breath and start from the beginning!!

[isotropic]

Hello, gentlemen, good morning!
I'm Isotropic, from Brazil.
I'm a JAVA programmer and I study at a Philosophy School.
This school needs support in the IT area.
That's why I decided to learn the basics of Linux so I could set up a network where teachers could share their work. The most basic thing possible. I tried TruNAS. Rokstar. Several options available. Until I discovered SME Server. Love at first sight! I'm studying to learn a lot and be able to participate in the version 11 testing.

[isotropic]

To answer your question:
I only want an internal network. 192.168.160.0. That's it. No external access.
On this network, with Tomcat and MySQL, I can install small applications to help with its operation. Things like student registration. Books in the library. Things like that. No external access. A completely internal network.

I'm very happy and gratified to have discovered SME Server. And I intend to participate more actively. Since I don't have enough knowledge to help with development, I intend to participate in testing. Or even through donations.
I want to thank you for the help I'm receiving. And I want to say that I would never try to jeopardize the work I'm trying to develop.
Thank you.

[isotropic]

When I say I want 'external access on port 3306,' I mean I intend to access MariaDB on a Windows computer, where I work best. With this access, I can create application tables using a front-end like MySQL-Front. But always on the internal network. Within the limits of 192.168.160.0.