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, 1467🔥, 0💬
Popular Posts:
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...