http://www.apachelounge.com * Mofified by kris http://www.xoofoo.org * * This program is free software; you can redistribute it and/or modify it. * note: not working with the php mysqli extension * * $Id: mysqlinfo.php,v 1.0.0 2006/08/27 steffen Exp $ * ***************************************************************************/ define('ADMIN_USERNAME','root'); // Admin Username define('ADMIN_PASSWORD','root'); // Admin Password ////////// END OF DEFAULT CONFIG AREA ///////////////////////////////////////////////////////////// ///////////////// Password protect //////////////////////////////////////////////////////////////// if (!isset($_SERVER['PHP_AUTH_USER']) || !isset($_SERVER['PHP_AUTH_PW']) || $_SERVER['PHP_AUTH_USER'] != ADMIN_USERNAME ||$_SERVER['PHP_AUTH_PW'] != ADMIN_PASSWORD) { Header("WWW-Authenticate: Basic realm=\"MySQL Infos Login\""); Header("HTTP/1.0 401 Unauthorized"); echo <<

Rejected!

Wrong Username or Password! EOB; exit; } /* Set your host and login parameters */ $user=ADMIN_USERNAME; $password=ADMIN_PASSWORD; $host="localhost"; ?> MySQLinfo and PHPinfo

php MySQL extension not loaded !!

Check in php.ini if extension=php_mysql.dll is enabled, and that the extension_dir = is pointing to your php/ext folder.

Copy libmySQL.dll from your Mysql/bin folder to c:/windows.


"); phpinfo(); die; } $link = mysql_connect($host, $user, $password); if (!$link) { echo ('
Could not connect to the Mysql server !!

' . mysql_error() . '

Did you set the correct host and login parameters in mysqlinfo.php ?


'); phpinfo(); die; } else { if( $user == 'root' ) { if( $password == '') { echo "Your user and password are the install default (user:root and password is blank), change it !!

"; } } ?> MySQL Server variables and settings     PHP info

User $user connected to the MySQL server at $host

Mysql version: %s\n", mysql_get_server_info()); ?>

MySQL Runtime Information





'; } echo '     ' . $row['Variable_name'] . ' = ' . $row['Value'] . "    
"; } ?>


Back to top


MySQL Server variables and settings





'; } echo '     ' . $row['Variable_name'] . ' = ' . $row['Value'] . "    
"; } } echo '


Back to top

Php info()
'; phpinfo(); ?> Back to top