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, 1686🔥, 0💬
Popular Posts:
How To Disable a Login Name in SQL Server? If you want temporarily disable a login name, you can use...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Disable a Login Name in SQL Server? If you want temporarily disable a login name, you can use...