Bug #31941 cannot query bind-address from inside server

• Submitted: 30 Oct 2007 11:09
• Modified: 10 Jan 2014 12:16
• Reporter: Kristian Koehntopp
• Status: Verified
• Category: MySQL Server: Options
• Severity: S4 (Feature request)
• Version: 5.0.46, 5.0 BK
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[30 Oct 2007 11:09] Kristian Koehntopp

Description:
If a server is being configured with bind-address, the address bound to is not visible in 'show global status'. This is inconsistent - port and socket are shown.

How to repeat:
Set

[mylsqld]
bind-address = 127.0.0.1
port = 3306
socket = /tmp/mysql.sock

Then

mysql> tee log
mysql> show global variables;

and grep the log. No 127.0.0.1 anywhere, socket and port are shown.

Suggested fix:
ALL config variables MUST be visible in SHOW GLOBAL STATUS, please.

[30 Oct 2007 11:44] Sveta Smirnova

Thank you for the report.

Verified as described.

[18 Jun 2008 11:02] Konstantin Osipov

Thank you for a feature request.

[10 Jan 2014 12:16] Erlend Dahl

This has not yet been implemented.

Moving to 'verified' as we are discontinuing the use of 'to be fixed later'.

[16 Jul 2015 20:38] Daniël van Eeden

Looks fixed in 5.7.8

mysql [localhost] {msandbox} ((none)) > show global variables like '%add%';
+---------------+------------+
| Variable_name | Value      |
+---------------+------------+
| bind_address  | localhost6 |
+---------------+------------+
1 row in set (0.00 sec)

mysql [localhost] {msandbox} ((none)) > SELECT @@bind_address;
+----------------+
| @@bind_address |
+----------------+
| localhost6     |
+----------------+
1 row in set (0.00 sec)