First, you installed MariaDivi on the instance.
And I accessed it from a local tool. First of all, I succeeded.
I looked it up and it said that it is connected to the server through ssh and connects to the local Maria DB.
So the tool also sets the ssh and keyfile, and DB set it locally to check the connection.
But when I looked up other blogs, I found out in mysql/my.cnf
bind-address = 127.0.0.1
They say that you can annotate this part or change it to 0.0.0.0 and then access it remotely.
I proceeded with this part without modification.
I wonder which method is closer to the standard.
aws
There is no standard and it depends on the purpose
All query operations are possible with mysql cli, and security-focused makes it 127.0.0.1 local and
If you feel uncomfortable, you can open it with 0.0.0.0 and work with toad or heidisql.
If you use php, you can also use phpmyadmin by setting it to 127.0.0.1
There's no guarantee that you'll be hacked if you leave it open, but hackers stab you for nothing.
If you don't use it, it's better to close it, and if you think it's hard to open it with cli, it's a good idea to set a password or put an ssl instead.
Also, it's good to limit IP as an extra. I saw a comment that it would be dangerous to connect to Wi-Fi on a laptop at a cafe or something. You have to be careful about that, too
© 2024 OneMinuteCode. All rights reserved.