Collections:
Retrieving MySQL Server information in MySQL
How To Get Some Basic Information Back from MySQL Servers in MySQL?
✍: FYIcenter.com
Once you got a MySQL server connection object successfully, you can use mysql_get_server() and mysql_get_host_info() to get some basic information from your MySQL server. The tutorial exercise below is a good example:
<?php $con = mysql_connect('localhost:8888', 'dev', 'iyf'); if (!$con) { print("There is a problem with MySQL connection.\n"); } else { print("The MySQL connection object is ready.\n"); print(mysql_get_client_info()."\n"); print(mysql_get_server_info($con)."\n"); print(mysql_get_host_info($con)."\n"); mysql_close($con); } ?>
If you run this script, you will get something like this:
The MySQL connection object is ready. 4.1.7 5.0.24-community-log localhost via TCP/IP
⇒ Close MySQL Connection Objects in MySQL
⇐ Accessing MySQL Server through Firewalls in MySQL
2017-11-11, 1251👍, 0💬
Popular Posts:
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...