0

what is the difference between * and 0.0.0.0 for bind-address in mysql server

Hello.

In my mysql server default values for bind-address is * and in another server there is 0.0.0.0 what is the difference. Will it restrict the access to my server...??

Linux Bind MySQL Add a comment
benjamin
asked May 06 2017

Answer

0

Here, * means the server supports all TCP connections for IPv4 and IPv6 interfaces.

Whereas 0.0.0.0 supports only the IPv4 interfaces.

Similar to * we can use :: to support both IPv4 and IPv6 interface.

It wont restrict any access to your Server if you use IPv4 interface.

Add a comment
jagannatharumugam
asked May 09 2017
edited Oct 05 2018
Post your Answer
0

I was hired as a new IT assistant in Dubai, but I thought that I would only be supporting office computers. And today the boss said I also need to take care of servers and backups. I am desperate.

Add a comment
lourdesperdon
asked Sep 13 2022
Post your Answer