How to bind MySQL server to more than one IP address?

No, there isn’t (I just checked 1 hour ago). You can comment the bind-address in my.cnf:

Note: « 1 hour ago » is now more than 10 years ago.

#skip-networking
#bind-address                   = 127.0.0.1

If you want only 2 IPs, you will then have to use a firewall.

For MySql version 8.0.13 and above, you can specify a list of comma-separated IP addresses.

bind-address = 10.0.0.1,10.0.1.1,10.0.2.1

Relevant MySql documentation.

Remember to restart your MySQL instance after changing the config file.

Related Posts:

  1. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  2. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  3. How do I find the MySQL my.cnf location
  4. Hosting multiple WordPress sites on single server – best practices?
  5. WordPress cloning issue
  6. Difference in sites-available vs sites-enabled vs conf.d directories (Nginx)?
  7. What is this IP address: 169.254.169.254?
  8. How can I export the privileges from MySQL and then import to a new server?
  9. How to determine the hostname from an IP address in a Windows network?
  10. What is the debian-sys-maint MySQL user (and more)?
  11. How do I deal with a filename that starts with the hyphen (-) character?
  12. Bash: No such file or directory?
  13. What’s a .sh file?
  14. How to get the url of the current svn repo?
  15. How to unmount a busy device
  16. How to unmount a busy device
  17. performing HTTP requests with cURL (using PROXY)
  18. No space left on device
  19. Pass a password to ssh in pure bash
  20. How can I exclude directories from grep -R?
  21. gcc: error: unrecognized command line option
  22. How to set proxy for wget?
  23. Pseudo-terminal will not be allocated because stdin is not a terminal
  24. Directory Inode vs Regular File Inode
  25. How to cat <> a file containing code?
  26. Diff command along with Grep gives “Binary file (standard input) matches”
  27. can’t remove python pip
  28. How would I get a cron job to run every 30 minutes?
  29. How to automatically redirect HTTP to HTTPS on Apache servers?
  30. Trying to use bash on Windows and got no installed distributions message
  31. “Unable to find remote helper for ‘https'” during git clone
  32. What is the difference between “#!/usr/bin/env bash” and “#!/usr/bin/bash”?
  33. tar: Cowardly refusing to create an empty archive
  34. How can I delete a user in linux when the system says its currently used in a process
  35. Command to change the default home directory of a user
  36. Post request with Wget?
  37. Read and write to binary files in C?
  38. Telnet [Unable to connect to remote host: Connection refused]
  39. Terminal Multiplexer for Microsoft Windows – Installers for GNU Screen or tmux
  40. Can’t remove a directory in Unix
  41. Is there an alternative sleep function in C to milliseconds?
  42. Gedit command not working in kali linux terminal
  43. Syntax error near unexpected token ‘then’
  44. Curl : connection refused
  45. How to install Android SDK on Ubuntu?
  46. C fopen vs open
  47. How can I use grep to show just filenames on Linux?
  48. Bash script prints “Command Not Found” on empty lines
  49. Bash export command
  50. How to edit gitignore file
  51. Adding a new entry to the PATH variable in ZSH
  52. CronJob not running
  53. How to configure WP filesystem access in Linux (Ubuntu Server)?
  54. Dynamically update Site/WordPress Address
  55. My WordPress is giving me an 403 error when saving post/draft with specific words
  56. Can scp copy directories recursively?
  57. Copying a large directory tree locally? cp or rsync?
  58. What are the functional differences between .profile .bash_profile and .bashrc
  59. Why does my hostname appear with the address 127.0.1.1 rather than 127.0.0.1 in /etc/hosts?
  60. Linux command to inspect TXT records of a domain [closed]
  61. df in linux not showing correct free space after file removal
  62. Setting the hostname: FQDN or short name?
  63. When does /tmp get cleared?
  64. What does a + mean at the end of the permissions from ls -l?
  65. How do I sleep for a millisecond in bash or ksh
  66. What does ‘set -e’ do, and why might it be considered dangerous?
  67. What version of RHEL am I using?
  68. What useful things can one add to one’s .bashrc? [closed]
  69. How do you make it obvious you are on a production system?
  70. How to add a timestamp to bash script log?
  71. How can I verify if TLS 1.2 is supported on a remote web server from the RHEL/CentOS shell?
  72. How to remove empty/blank lines from a file in Unix (including spaces)?
  73. Mount CIFS Host is down
  74. List of files installed from apt package
  75. How can I kill all stopped jobs?
  76. How to copy a large number of files quickly between two servers
  77. How to copy file preserving directory path in Linux?
  78. Postfix – how to retry delivery of mail in queue?
  79. Allow SFTP but disallow SSH?
  80. Is it possible to alias a hostname in Linux?
  81. How do I list loaded Linux module parameter values?
  82. Does getting disconnected from an SSH session kill your programs?
  83. Tips for Securing a LAMP Server
  84. What Linux distribution is the Amazon Linux AMI based on?
  85. Is there a directory equivalent of /dev/null in Linux?
  86. Can I send some text to the STDIN of an active process running in a screen session?
  87. How can I get processor/RAM/disk specs from the Linux command Line? [duplicate]
  88. Should I install Linux applications in /var or /opt?
  89. Is there a way to see the execution tree of systemd?
  90. Heartbleed: how to reliably and portably check the OpenSSL version?
  91. create home directories after create users
  92. How can I fully log all bash scripts actions?
  93. How do I redirect subdomains to a different port on the same server?
  94. Running Cron every 2 hours [duplicate]
  95. How to check the physical status of an ethernet port in Linux?
  96. What does “debconf: delaying package configuration, since apt-utils is not installed” mean?
  97. Testing UDP port connectivity
  98. In Linux, what is the difference between “buffers” and “cache” reported by the free command?
  99. memcache vs memcached?
  100. zcat/gzcat works in linux, not on osx. general linux/osx compatibility

Leave a Comment