Current Location: Home> Latest Articles> How to Use mysql_get_host_info Function to Get Detailed MySQL Host Connection Information?

How to Use mysql_get_host_info Function to Get Detailed MySQL Host Connection Information?

gitbox 2025-07-26 
<span><span><span class="hljs-meta"><?php</span></span><span>
</span><span><span class="hljs-comment">// This part of the code is unrelated to the article content, just for demonstration</span></span><span>
</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"Welcome to this article!"</span></span><span>;
</span><span><span class="hljs-meta">?></span></span><span>
<p><hr></p>
<p><h1>How to use <code>mysql_get_host_info

- $link_identifier: Optional parameter, MySQL connection resource. If omitted, the most recent opened connection is used.

Return Value

Returns a string, usually in the format:

  • hostname:port
  • hostname:socket

For example:

  • localhost via TCP/IP
  • 127.0.0.1 via UNIX socket

Example Code

&lt;?php
</span><span><span class="hljs-comment">// Connect to the database</span></span><span>
</span><span><span class="hljs-variable">$link</span></span><span> = </span><span><span class="hljs-title function_ invoke__">mysql_connect</span></span><span>(</span><span><span class="hljs-string">&#039;localhost&#039;</span></span><span>, </span><span><span class="hljs-string">&#039;root&#039;</span></span><span>, </span><span><span class="hljs-string">&#039;password&#039;</span></span><span>);
</span><span><span class="hljs-keyword">if</span></span><span> (!</span><span><span class="hljs-variable">$link</span></span><span>) {
    </span><span><span class="hljs-keyword">die</span></span><span>(</span><span><span class="hljs-string">&#039;Connection failed: &#039;</span></span><span> . </span><span><span class="hljs-title function_ invoke__">mysql_error</span></span><span>());
}

</span><span><span class="hljs-comment">// Get and print the host connection info</span></span><span>
</span><span><span class="hljs-variable">$hostInfo</span></span><span> = </span><span><span class="hljs-title function_ invoke__">mysql_get_host_info</span></span><span>(</span><span><span class="hljs-variable">$link</span></span><span>);
</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"Current MySQL connection host info: "</span></span><span> . </span><span><span class="hljs-variable">$hostInfo</span></span><span>;

</span><span><span class="hljs-comment">// Close the connection</span></span><span>
</span><span><span class="hljs-title function_ invoke__">mysql_close</span></span><span>(</span><span><span class="hljs-variable">$link</span></span><span>);
?&gt;

Output Result

If the connection is successful, this example will output something like:

<span class="fun">Current MySQL connection host info: localhost via TCP/IP</span>

Notes

  • Deprecation Warning: Since PHP 7.0, the mysql_ series functions have been deprecated. It is recommended to use the mysqli or PDO extensions instead.
  • Compatibility: For new projects, it is recommended to use mysqli_get_host_info(), which works similarly.

Example of Getting Host Info Using mysqli

&lt;?php
</span><span><span class="hljs-variable">$mysqli</span></span><span> = </span><span><span class="hljs-keyword">new</span></span><span> </span><span><span class="hljs-title function_ invoke__">mysqli</span></span><span>(</span><span><span class="hljs-string">&#039;localhost&#039;</span></span><span>, </span><span><span class="hljs-string">&#039;root&#039;</span></span><span>, </span><span><span class="hljs-string">&#039;password&#039;</span></span><span>);

</span><span><span class="hljs-keyword">if</span></span><span> (</span><span><span class="hljs-variable">$mysqli</span></span><span>->connect_error) {
    </span><span><span class="hljs-keyword">die</span></span><span>(</span><span><span class="hljs-string">&#039;Connection failed: &#039;</span></span><span> . </span><span><span class="hljs-variable">$mysqli</span></span><span>->connect_error);
}

</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"Current MySQL connection host info: "</span></span><span> . </span><span><span class="hljs-variable">$mysqli</span></span><span>->host_info;

</span><span><span class="hljs-variable">$mysqli</span></span><span>-</span><span><span class="hljs-title function_ invoke__">close</span></span><span>();
?&gt;

Summary

Using the mysql_get_host_info function, we can easily retrieve the host information of the current MySQL connection, which helps developers debug and monitor the database connection environment. However, since the mysql_ functions are deprecated, it is recommended to switch to mysqli or PDO, both of which also support fetching connection host details and offer more powerful features.

Related