1

Topic: MySQL Server as it for exterior connections?

All kind day!
Prompt if who tried to do the such.
It is installed MySQL Server on Windows 10 with exterior white static IP the address as it  for exterior connection that it was possible will be connected far off and through PHP.
1) If it is possible to open what ports more in detail.
2) whether It is necessary to open ports on the side of the provider.
3) Porjado of setting
4) How to check up if that that it is wrong .
Well and the more information the better!
In advance I thank!!

2

Re: MySQL Server as it for exterior connections?

And tried to google?
https://help.sprinthost.ru/support/howt … otedb.html

3

Re: MySQL Server as it for exterior connections?

. Not that link
https://server-gu.ru/remote-mysql/

4

Re: MySQL Server as it for exterior connections?

I thank but it for  and m goes about windows = (

5

Re: MySQL Server as it for exterior connections?

And what, in Windows a config at  any not such or ports any especial? ;-)

6

Re: MySQL Server as it for exterior connections?

Yes it is simple in the instruction there not and ways not I cannot  = (

7

Re: MySQL Server as it for exterior connections?

Can help?

8

Re: MySQL Server as it for exterior connections?

I can, but to ten I in eyes did not see. I think, anything .
Ways to a config - yes, others, in the same place both disks are also slashes not in that side. And what, in ten search in file name at all does not work now? ;-)
Likely, ten not on it is poor so much and find a file  can. To correct on behalf of the manager. Editings do not differ from , by and large. But with the official documentation on specific version MySQL I recommend to be checked. Just in case.
Well, we suppose, the config is not present at all. Basically, the regular situation to work  with  adjustments forbade nobody. Then it is necessary to suppose its pens where it is necessary (it is possible and in data_dir, but, besides, particulars in the documentation). We will consider it as a special case.
Restarting  - yes, it as a variant, to search in "for control -> services" and there to restart service.
To open port 3306 (or on what port at you the server is launched) in a firewall for entering connections. ... Well so this question of any relation to  has no that, except port number. Any other port opens in the same way, as well as. Of instructions in a network (and in Windows) it is full, beginning from the official documentation on Windows and finishing thousand cribs of a different level of reliability and correctness.
Do not thank.

9

Re: MySQL Server as it for exterior connections?

The router costs?
ports on it it is adjusted?

10

Re: MySQL Server as it for exterior connections?

vkle wrote:

And what, in Windows a config at  any not such or ports any especial? ;-)

In Windows a maximum of 20 entering TCP-connections
There at them special >: - <

11

Re: MySQL Server as it for exterior connections?

wrote:

in Windows a maximum of 20 entering TCP-connections

it, to put it mildly, a lie.

12

Re: MySQL Server as it for exterior connections?

miksoft wrote:

it is passed...
It, to put it mildly, a lie.

? Well I precisely remember that there were problems with the most elementary connections when I still kneaded it to g th (about 10 years ago)
And here write:

wrote:

It's still like previous versions, it is a limit of 20, and it is a limit (both technical and legal) on incoming TCP connections. So anything, network shares, web, email... whatever you decide to host on the desktop is limited to only twenty open connections at a time.

13

Re: MySQL Server as it for exterior connections?

wrote:

and here write:
it is passed...

And in the same place further:

wrote:

The EULA clearly states the limit is 20 *devices* NOT TCP connections, and it's only a limit on devices connected to "file services, print services, Internet information services, and Internet connection sharing and telephony services"

14

Re: MySQL Server as it for exterior connections?

Well and further away:

wrote:

My network consists of gigabit cat6 ethernet with 6 actual users all win10 and around 40 network attached devices that are in use around the building.
We are not a large company.
My data transfer instigated from win10 is slow.
If I instigate it from either NAS, it is blindingly fast.
When I look at the bottleneck, it comes back to TCP connections.

So, how do I get around this limit?

15

Re: MySQL Server as it for exterior connections?

vkle;
I thank a problem was on the server with authentification. It was necessary to make simply simple authentification in ini a file.

16

Re: MySQL Server as it for exterior connections?

wrote:

it is passed...
In Windows a maximum of 20 entering TCP-connections
There at them special >: - <

I do not understand this phrase you mean that that a maximum of 20 persons can will be connected to me? Unless it not is set by adjustments of a network card?

17

Re: MySQL Server as it for exterior connections?

Network card in the power of Windows

18

Re: MySQL Server as it for exterior connections?

wrote:

it is passed...
Not 20 persons, and 20 connections, are a little different things

That is you want to tell that if at me on windows the site is installed open server and on it then a maximum of 20 persons can see a content on a site?

19

Re: MySQL Server as it for exterior connections?

The HTTP-server does not hold connection by the active
It gave a content and disconnected
There is keep-alive, but it like does not influence
The active tcp-connections of 20 pieces

20

Re: MySQL Server as it for exterior connections?

mysql_ru wrote:

it is passed...
I do not understand this phrase you mean that that a maximum of 20 persons can will be connected to me? Unless it not is set by adjustments of a network card?

  it is set by the software license agreement. In enough rare occurences (connection to   or a folder, for example) takes place as also technical .

mysql_ru wrote:

if at me on windows the site is installed open server and on it then a maximum of 20 persons can see a content on a site?

Years a little studied this question back. Depending on licensing type, formally, to the server have access N of devices or N users. For web servers then there was an edition "web server" where such restriction missed. As it now - I do not know.

21

Re: MySQL Server as it for exterior connections?

22

Re: MySQL Server as it for exterior connections?

Dimitry Sibiryakov wrote:

it is passed...
Learn to distinguish already TCP connections from SMB connections...

That I distinguish, matter is not in it, and in that that I simply do not remember, in what there  in Windows was
Most likely inside-vindovo-net, yes

23

Re: MySQL Server as it for exterior connections?

Prompt if who tried to do the such.
It is installed MySQL Server on Windows 10 with exterior white static IP the address as it  for exterior connection that it was possible will be connected far off and through PHP.
Well it is an antipattern of network safety but if you very much want give...
1) If it is possible to open what ports more in detail.
One on which works MySQL. 33 there something on a default.
2) whether It is necessary to open ports on the side of the provider.
No.

24

Re: MySQL Server as it for exterior connections?

mysql_ru wrote:

I Thank but it for  and m goes about windows = (

There is no difference

25

Re: MySQL Server as it for exterior connections?

mysql_ru wrote:

I Thank but it for  and m goes about windows = (

Pancake you   the stupid?
The Port should ON  be opened yours!
At what here configs and win/Lin?