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...??

benjamin
asked May 6, 2017
2 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.

View More
jagannatharumugam
answered May 9, 2017
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.

View More
lourdesperdon
answered Sep 13, 2022
Your Answer
||||
​x
 
​
100:0

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

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

How to install and configure Bind DNS on Webmin
How to install and configure Bind DNS on Webmin
Jan 5, 2018
How to remove MySQL package completely on Ubuntu 16.04
How to remove MySQL package completely on Ubuntu 16.04
Apr 17, 2017
How to install Xrdp Server (Remote Desktop) on Oracle Linux 8.5
How to install Xrdp Server (Remote Desktop) on Oracle Linux 8.5
Oct 17, 2022
How to install and update OpenSSL on Debian 11.3
How to install and update OpenSSL on Debian 11.3
Oct 21, 2022
How To Install Mysql-Workbench On Linux Mint 20.2
How To Install Mysql-Workbench On Linux Mint 20.2
Apr 27, 2022
How to Block a Domain in Bind DNS Server on CentOS
How to Block a Domain in Bind DNS Server on CentOS
Sep 26, 2017
How to Install and Configure Mega in Linux
How to Install and Configure Mega in Linux
Jul 19, 2016
How to use Aureport command on Linux
How to use Aureport command on Linux
Nov 28, 2017

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

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

Linux
jayce class=
shasum command not found
May 5, 2017
Linux
stephan class=
How to list all samba users
Jan 12, 2018
MySQL
rolando class=
Mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'gtid\_mode'': Table 'performance_schema.session_variables' doesn't exist (1146)
May 9, 2019
MySQL
isaiah class=
ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
Feb 8, 2017
pv command
muhammad class=
pvcreate command not found error
May 9, 2017
Linux
henry class=
Starting NFS daemon: rpc.nfsd: writing fd to kernel failed: errno 111 (Connection refused)
Apr 25, 2017
ifconfig command
jackbrookes class=
what is the location of the ifconfig program on your machine?
Jan 4, 2018
Linux
baseer class=
single command to apply setfacl for multiple user at a time
Jan 23, 2018

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

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

Anbox, the Android-to-Linux tool the developers have been waiting for
Anbox, the Android-to-Linux tool the developers have been waiting for
Apr 17, 2017
Linus Torvalds stops signing Linux kernel RC tarballs
Linus Torvalds stops signing Linux kernel RC tarballs
May 17, 2017
Capsule8 Launches Linux-Based Container Security Platform
Capsule8 Launches Linux-Based Container Security Platform
Feb 14, 2017
Symantec updates Management console product
Symantec updates Management console product
Nov 22, 2017
Latest Linux driver release feature seven AMD Vega
Latest Linux driver release feature seven AMD Vega
Mar 23, 2017
A Newer and a Faster Window Manager for Tina (Linux Mint 19.2)
A Newer and a Faster Window Manager for Tina (Linux Mint 19.2)
Apr 9, 2019
Microsoft makes its Azure App service now available on Linux Systems
Microsoft makes its Azure App service now available on Linux Systems
Sep 7, 2017
Docker friendly Alpine Linux gets hardened Node.js
Docker friendly Alpine Linux gets hardened Node.js
Apr 19, 2017