Private network IP range, how the addresses are assigned
I have a database server and several app servers. The connection between database and app is over local network only. The number of app servers will be dynamic i.e. I will spin up and destroy servers based on demand. All droplets will run in the same datacenter.
I would like to create a mySQL user that has access only from certain pool if IP addresses.
But when I tried to find how local ip is assigned I did not find any guidance.
I would not like to define mysql user as broad as ‘user’@'10.%.%.%’
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.