在phpMyAdmin使用用户口令登陆
[作者]:菩提树下的杨过 [来源]:互联网 [收录时间]:2007-12-9 10:54:17
使用过phpMyAdmin的人知道,在phpMyAdmin中,使用文件config.inc.php保存用户名和密码,当需要更换用户或用户口令更改时,必须修改config.inc.php文件,然后再上传,非凡的不方便。更有时,为了修改MYSQL库或表而使用root账号,假如这时其它网站的自动搜擎系统搜索到index.php并继续执行其中的每一步的话,是相当危险的。为此需要用户登陆机制,在每次使用时,输入用户名和口令,这样会安全得多。 以下是我在治理过程中,根据实际需要,对phpMyAdmin做的一些更改,为了尽量不影响原来phpMyAdmin的结构,我在phpMyAdmin的基础上增加了一个文件index0.php,仅仅修改了一个文件config.inc.php,对phpMyAdmin没有一点影响,既可以使用原来的phpMyAdmin,也可以使用新的用户口令登陆机制。 以下为两个文件列表,将这两个文件拷贝到phpMyAdmin目录,执行index0.php即可,该程序在Apache + PHP + MYSQL 和 IIS5 + PHP + MYSQl 和 PWS + PHP + MYSQL下正常执行。 phpMyAdmin 下载: A set of PHP3-scripts to adminstrate MySQL over the WWW. Version 2.1.0 - 08/06/2000 http://www.phpwizard.net/projects/phpMyAdmin/ index0.php文件: PHP运行不正常,请检查 config.inc.php 文件 n"); fclose($handertmp); }else{ echo "

账号参数已经过期,请重新输入!

"; echo "登陆"; die("

程序终止"); } } } $cfgServers[2]['host'] = ''; $cfgServers[2]['port'] = ''; $cfgServers[2]['adv_auth'] = false; $cfgServers[2]['stduser'] = ''; $cfgServers[2]['stdpass'] = ''; $cfgServers[2]['user'] = ''; $cfgServers[2]['password'] = ''; $cfgServers[2]['only_db'] = ''; $cfgServers[2]['verbose'] = ''; $cfgServers[3]['host'] = ''; $cfgServers[3]['port'] = ''; $cfgServers[3]['adv_auth'] = false; $cfgServers[3]['stduser'] = ''; $cfgServers[3]['stdpass'] = ''; $cfgServers[3]['user'] = 'root'; $cfgServers[3]['password'] = ''; $cfgServers[3]['only_db'] = ''; $cfgServers[3]['verbose'] = ''; // If you have more than one server configured, you can set $cfgServerDefault // to any one of them to autoconnect to that server when phpMyAdmin is started, // or set it to 0 to be given a list of servers without logging in // If you have only one server configured, $cfgServerDefault *MUST* be // set to that server. $cfgServerDefault = 1; // Default server (0 = no default server) $cfgServer = ''; unset($cfgServers[0]); $cfgManualBase = "http://www.mysql.com/documentation/mysql/bychapter/"; $cfgConfirm = true; $cfgPersistentConnections = false; $cfgBorder = "0"; $cfgThBgcolor = "#D3DCE3"; $cfgBgcolorOne = "#CCCCCC"; $cfgBgcolorTwo = "#DDDDDD"; $cfgMaxRows = 30; $cfgMaxInputsize = "300px"; $cfgOrder = "ASC"; $cfgShowBlob = true; $cfgShowSQL = true; require("chinese_gb.inc.php"); $strWelcome="注销账户 重新登陆

$strWelcome"; $cfgColumnTypes = array( "TINYINT", "SMALLINT", "MEDIUMINT", "INT", "BIGINT", "FLOAT", "DOUBLE", "DECIMAL", "DATE", "DATETIME", "TIMESTAMP", "TIME", "YEAR", "CHAR", "VARCHAR", "TINYBLOB", "TINYTEXT", "TEXT", "BLOB", "MEDIUMBLOB", "MEDIUMTEXT", "LONGBLOB", "LONGTEXT", "ENUM", "SET"); $cfgFunctions = array( "ASCII", "CHAR", "SOUNDEX", "CURDATE", "CURTIME", "FROM_DAYS", "FROM_UNIXTIME", "NOW", "PASSWORD", "PERIOD_ADD", "PERIOD_DIFF", "TO_DAYS", "USER", "WEEKDAY", "RAND"); $cfgAttributeTypes = array( "", "BINARY", "UNSIGNED", "UNSIGNED ZEROFILL"); // Setting magic_quotes_runtime - do not change! set_magic_quotes_runtime(0); ?> 如有引用,请注明高山雪和alpsnow@china.com