Our features site is undergoing a refresh! Be sure to explore the revamped site and discover our latest product roadmap launching here on Monday, March 18th.

Add 127.0.0.1 as an authorized MySQL Remote IP by default

Silent Ninja shared this idea 6 years ago
Open Discussion

As a System Administrator I would like that the IP 127.0.0.1 is added as an authorized MySQL Remote IP by default, so that people could use either localhost or 127.0.0.1 to connect to the database without having to enable it first.

I think that localhost is a better option since it uses a Unix Socket instead of a TCP connection, but some PHP framework / ORMs dislike the use of it and use the loopback IP address by default, which causes confusion among customers using the software with the common phrase "it worked on xx setup, you have the issue".

Given that any account can connect normally using localhost, I don't see why it shouldn't be able to do it using 127.0.0.1 as well.

Leave a Comment
 
Attach a file