[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
Original source
guys I have opened 3306 port on my server computer to access SQL from my personal pc, but still not allowed to connect, what else can be problem there?
rektbyfaith
05-08-2025, 07:56 PM #1Archived author: Shako • Posted: 2025-05-08T19:56:19.455000+00:00
Original source
guys I have opened 3306 port on my server computer to access SQL from my personal pc, but still not allowed to connect, what else can be problem there?
Original source
It's not recommend to open the SQL port. You should only be accessing it via the machine it's being hosted on, safety wise.
rektbyfaith
05-08-2025, 08:00 PM #2Archived author: Ryan Turner • Posted: 2025-05-08T20:00:19.408000+00:00
Original source
It's not recommend to open the SQL port. You should only be accessing it via the machine it's being hosted on, safety wise.
Original source
But taking the risk, you have to allow other IPs from X user to be allowed
rektbyfaith
05-08-2025, 08:00 PM #3Archived author: Ryan Turner • Posted: 2025-05-08T20:00:43.125000+00:00
Original source
But taking the risk, you have to allow other IPs from X user to be allowed
Original source
Yea it's better to SSH into the server computer. But if you must open 3306, look into ip tables/network firewalls
rektbyfaith
05-08-2025, 08:00 PM #4Archived author: metallinos • Posted: 2025-05-08T20:00:51.231000+00:00
Original source
Yea it's better to SSH into the server computer. But if you must open 3306, look into ip tables/network firewalls
Original source
Hard to give more specific advice without knowing what your setup is like
rektbyfaith
05-08-2025, 08:01 PM #5Archived author: metallinos • Posted: 2025-05-08T20:01:22.090000+00:00
Original source
Hard to give more specific advice without knowing what your setup is like
Original source
With your `root` or equivalent user you can run in your mysql tool
```sql
SELECT User, Host FROM mysql.user;
```
And you will get something like this:
![[Image: image.png?ex=690c5674&is=690b04f4&hm=696...b1cf2c095&]](https://cdn.discordapp.com/attachments/1255602330431127753/1370129145350066276/image.png?ex=690c5674&is=690b04f4&hm=696490a56aef1540de588ac7540b4e01b02e9f59c0d04ea9fa4ce65b1cf2c095&)
rektbyfaith
05-08-2025, 08:04 PM #6Archived author: Ryan Turner • Posted: 2025-05-08T20:04:04.094000+00:00
Original source
With your `root` or equivalent user you can run in your mysql tool
```sql
SELECT User, Host FROM mysql.user;
```
And you will get something like this:
Original source
then how should I allow web to connect sql server from outside of hosting? if I have them seperate hosts
rektbyfaith
05-08-2025, 08:12 PM #7Archived author: Shako • Posted: 2025-05-08T20:12:52.786000+00:00
Original source
then how should I allow web to connect sql server from outside of hosting? if I have them seperate hosts
Original source
Create the user and only allow it to be accessed from a specific IP and use a very secure password
rektbyfaith
05-08-2025, 08:15 PM #8Archived author: Revision • Posted: 2025-05-08T20:15:03.224000+00:00
Original source
Create the user and only allow it to be accessed from a specific IP and use a very secure password
Original source
That's what I do
rektbyfaith
05-08-2025, 08:15 PM #9Archived author: Revision • Posted: 2025-05-08T20:15:16.558000+00:00
Original source
That's what I do
Original source
i wouldnt do that
rektbyfaith
05-08-2025, 08:15 PM #10Archived author: Rymercyble • Posted: 2025-05-08T20:15:28.918000+00:00
Original source
i wouldnt do that
1 Guest(s)
1 Guest(s)