Bind address and MySQL server [closed]

by

The address you specify in bind tells MySQL where to listen. 0.0.0.0 is a special address, which means “bind to every available network”.

Only client software which is able to open a connection to the server using the same address that is specified in the ‘bind’ option will be allowed to connect.

Some examples:

  • If MySQL binds to 127.0.0.1, then
    only software on the same computer
    will be able to connect (because
    127.0.0.1 is always the local computer).
  • If MySQL binds to
    192.168.0.2 (and the server computer’s IP address is
    192.168.0.2 and it’s on a /24 subnet), then any computers on the same
    subnet (anything that starts with 192.168.0) will be able to connect.
  • If MySQL binds to
    0.0.0.0, then any computer which is able to reach the server computer
    over the network will be able to connect.

These are all transport-level connections. Remote computers still need to qualify for application-level, which is to say they will still require the correct login credentials and host parameters from mysql.user.

More Related Contents:

  1. MySQL: SELECT from another server
  2. SQL Print the name of all Employees together with the name of their supervisor
  3. Syntax error due to using a reserved word as a table or column name in MySQL
  4. Change MySQL default character set to UTF-8 in my.cnf?
  5. MySQL: Large VARCHAR vs. TEXT?
  6. MySQL offset infinite rows
  7. What is the question mark’s significance in MySQL at “WHERE column = ?”?
  8. How do write IF ELSE statement in a MySQL query
  9. mysql – making a mechanism similar to Oracle’s seqences
  10. How do you uninstall MySQL from Mac OS X?
  11. Difference between VARCHAR and TEXT in MySQL [duplicate]
  12. How to program a MySQL trigger to insert row into another table?
  13. UUID performance in MySQL?
  14. MySQL: NULL vs “”
  15. MySQL Error 1264: out of range value for column
  16. Like Case Sensitive in MySQL
  17. What is the best way to delete old rows from MySQL on a rolling basis?
  18. What are the known ways to store a tree structure in a relational DB? [closed]
  19. Illegal mix of collations error in MySql
  20. mysql equivalent data types
  21. Get difference in years between two dates in MySQL as an integer
  22. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  23. Check if a column exists in a table with MySQL
  24. Connect to Docker MySQL container from localhost?
  25. Empty IN clause parameter list in MySQL
  26. Where can I download mysql jdbc jar from? [closed]
  27. MySQL listen notify equivalent
  28. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  29. MySQL and PDO: Could PDO::lastInsertId theoretically fail?
  30. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)

Leave a Comment