[DiscordArchive] guys I have opened 3306 port on my server computer to access SQL from my personal pc, but still not
[DiscordArchive] guys I have opened 3306 port on my server computer to access SQL from my personal pc, but still not
Archived author: Rymercyble • Posted: 2025-05-08T20:15:44.371000+00:00
Original source
not exactly practical
Archived author: Revision • Posted: 2025-05-08T20:16:02.015000+00:00
Original source
5+ years and no incidents, but I'm not running a public server so it could be different if you do.
Archived author: Rymercyble • Posted: 2025-05-08T20:17:18.373000+00:00
Original source
not for security
Archived author: Rymercyble • Posted: 2025-05-08T20:17:32.191000+00:00
Original source
but ur ip can change or connect from different place or whatever and u have to constantly change it
Archived author: Shako • Posted: 2025-05-08T20:18:31.280000+00:00
Original source
I did it but still not allowed to connect. idk why. its trying toconnect so it seems port is open but not allowed
Archived author: Revision • Posted: 2025-05-08T20:20:32.869000+00:00
Original source
It could, it depends on your setup. All my servers have static IPs and they never change, my home IP is dynamic but hasn't changed in many years. It all depends on your setup. You could of course also use `%` instead of an IP but password security is very important if you really want to do that.
Archived author: Revision • Posted: 2025-05-08T20:20:45.826000+00:00
Original source
If MySQL is running on a Linux box it doesn't allow connections outside of localhost by default.
Archived author: Shako • Posted: 2025-05-08T20:23:34.925000+00:00
Original source
its on windows server now
Archived author: Shako • Posted: 2025-05-08T20:24:16.469000+00:00
Original source
its just for me testing it, so I dont care about password and security yet :d just want to connect sql from my personal pc instead of hosting