PHPMyadmin配置文件详解.docx
- 文档编号:9940725
- 上传时间:2023-05-22
- 格式:DOCX
- 页数:23
- 大小:25.97KB
PHPMyadmin配置文件详解.docx
《PHPMyadmin配置文件详解.docx》由会员分享,可在线阅读,更多相关《PHPMyadmin配置文件详解.docx(23页珍藏版)》请在冰点文库上搜索。
PHPMyadmin配置文件详解
03
转自老精灵的老房子:
PHPMyadmin配置文件config.inc.php内容如下,在需要设置的地方增加了相关注释。
php
/*$Id:
config.inc.php,v1.204.2.12003/10/1014:
24:
24nijelExp$*/
//vim:
expandtabsw=4ts=4sts=4:
/**
*phpMyAdminConfigurationFile
*
*AlldirectivesareexplainedinDocumentation.html
*/
/**
*Setsthephperrorreporting-Pleasedonotchangethisline!
*/
if(!
isset($old_error_reporting)){
error_reporting(E_ALL);
@ini_set('display_errors','1');
}
/**
*YourphpMyAdminurl
*
*Completethevariablebelowwiththefullurlie
* http:
//www.your_
*
*ItmustcontaincharactersthatarevalidforaURL,andthepathis
*casesensitiveonsomeWebservers,forexampleUnix-basedservers.
*
*Inmostcasesyoucanleavethisvariableempty,asthecorrectvalue
*willbedetectedautomatically.However,werecommendthatyoudo
*testtoseethattheauto-detectioncodeworksinyoursystem.Agood
*testistobrowseatable,theneditarowandsaveit.Therewillbe
*anerrormessageifphpMyAdmincannotauto-detectthecorrectvalue.
*
*Iftheauto-detectioncodedoesworkproperly,youcansettoTRUEthe
*$cfg['PmaAbsoluteUri_DisableWarning']variablebelow.
*/
$cfg['PmaAbsoluteUri']='';-----这里设置你的phpmyadmin的URL,如:
http:
//localhost/phpmyadmin/
/**
*Disablethedefaultwarningabout$cfg['PmaAbsoluteUri']notbeingset
*YoushouldusethisifandONLYifthePmaAbsoluteUriauto-detection
*worksperfectly.
*/
$cfg['PmaAbsoluteUri_DisableWarning']=FALSE;
/**
*DisablethedefaultwarningthatisdisplayedontheDBDetailsStructurepageif
*anyoftherequiredTablesfortherelationfeaturescouldnotbefound
*/
$cfg['PmaNoRelation_DisableWarning']=FALSE;
/**
*The'cookie'auth_typeusesblowfishalgorithmtoencryptthepassword.If
*atleastoneserverconfigurationuses'cookie'auth_type,enterherea
*passphrasethatwillbeusedbyblowfish.
$cfg['blowfish_secret']='';-----设定好root密码后这里也要填写
/**
*Server(s)configuration
*/
$i=0;
//The$cfg['Servers']arraystartswith$cfg['Servers'][1].Donotuse$cfg['Servers'][0].
//Youcandisableaserverconfigentrybysettinghostto''.
$i++;
$cfg['Servers'][$i]['host'] ='localhost';//MySQLhostnameorIPaddress----这里可以设定远程MySQL服务器IP地址
$cfg['Servers'][$i]['port'] =''; //MySQLport-leaveblankfordefaultport-----默认为3306
$cfg['Servers'][$i]['socket'] =''; //Pathtothesocket-leaveblankfordefaultsocket
$cfg['Servers'][$i]['connect_type']='tcp'; //HowtoconnecttoMySQLserver('tcp'or'socket')-----连接MySQL服务器的方式
$cfg['Servers'][$i]['compress'] =FALSE; //UsecompressedprotocolfortheMySQLconnection
//(requiresPHP>=4.3.0)-----是否使用压缩协议,PHP版本须>=4.3.0
$cfg['Servers'][$i]['controluser'] =''; //MySQLcontrolusersettings
//(thisusermusthaveread-only
$cfg['Servers'][$i]['controlpass'] =''; //accesstothe"mysql/user"
//and"mysql/db"tables)-----MySQL控制用户设定,该用户只对mysql数据库下的user和db表有完全权限
$cfg['Servers'][$i]['auth_type'] ='config';
//Authenticationmethod(config,httporcookiebased)?
-----如果PHP安装模式为Apache,可以使用http和cookie;如果PHP安装模式为CGI,可以使用cookie;默认为config,是不安全的,不推荐。
$cfg['Servers'][$i]['user'] ='root'; //MySQLuser-----MySQL连接用户
$cfg['Servers'][$i]['password'] ='';
//MySQLpassword(onlyneededwith'config'auth_type)-----MySQL连接密码,建议在安装好PHP和MySQL后,先用phpmyadmin设定root密码,然后在这里填写
$cfg['Servers'][$i]['only_db'] =''; //Ifsettoadb-name,only
//thisdbisdisplayed
//atleftframe
//Itmayalsobeanarray
//ofdb-names-----如果在这里设定一个数据库的名字,那么登陆后框架左边将只显示这个数据库
$cfg['Servers'][$i]['verbose'] =''; //Verbosenameforthishost-leaveblanktoshowthehostname
$cfg['Servers'][$i]['pmadb'] =''; //DatabaseusedforRelation,BookmarkandPDFFeatures
//(seescripts/create_tables.sql)
// -leaveblankfornosupport
// DEFAULT:
'phpmyadmin'
$cfg['Servers'][$i]['bookmarktable']=''; //Bookmarktable
// -leaveblankfornobookmarksupport
// DEFAULT:
'pma_bookmark'
$cfg['Servers'][$i]['relation'] =''; //tabletodescribetherelationbetweenlinks(seedoc)
// -leaveblankfornorelation-linkssupport
// DEFAULT:
'pma_relation'
$cfg['Servers'][$i]['table_info'] =''; //tabletodescribethedisplayfields
// -leaveblankfornodisplayfieldssupport
// DEFAULT:
'pma_table_info'
$cfg['Servers'][$i]['table_coords']=''; //tabletodescribethetablespositionforthePDFschema
// -leaveblankfornoPDFschemasupport
// DEFAULT:
'pma_table_coords'
$cfg['Servers'][$i]['pdf_pages'] =''; //tabletodescribepagesofrelationpdf
// -leaveblankifyoudon'twanttousethis
// DEFAULT:
'pma_pdf_pages'
$cfg['Servers'][$i]['column_info'] =''; //tabletostorecolumninformation
// -leaveblankfornocolumncomments/mimetypes
// DEFAULT:
'pma_column_info'
$cfg['Servers'][$i]['history'] =''; //tabletostoreSQLhistory
// -leaveblankfornoSQLqueryhistory
// DEFAULT:
'pma_history'
$cfg['Servers'][$i]['verbose_check']=TRUE; //settoFALSEifyouknowthatyourpma_*tables
//areuptodate.Thispreventscompatibility
//checksandtherebyincreasesperformance.
$cfg['Servers'][$i]['AllowDeny']['order'] //Hostauthenticationorder,leaveblanktonotuse
='';
$cfg['Servers'][$i]['AllowDeny']['rules'] //Hostauthenticationrules,leaveblankfordefaults
=array();
$i++;
$cfg['Servers'][$i]['host'] ='';
$cfg['Servers'][$i]['port'] ='';
$cfg['Servers'][$i]['socket'] ='';
$cfg['Servers'][$i]['connect_type'] ='tcp';
$cfg['Servers'][$i]['compress'] =FALSE;
$cfg['Servers'][$i]['controluser'] ='';
$cfg['Servers'][$i]['controlpass'] ='';
$cfg['Servers'][$i]['auth_type'] ='config';
$cfg['Servers'][$i]['user'] ='root';
$cfg['Servers'][$i]['password'] ='';
$cfg['Servers'][$i]['only_db'] ='';
$cfg['Servers'][$i]['verbose'] ='';
$cfg['Servers'][$i]['pmadb'] ='';//'phpmyadmin'-seescripts/create_tables.sql
$cfg['Servers'][$i]['bookmarktable'] ='';//'pma_bookmark'
$cfg['Servers'][$i]['relation'] ='';//'pma_relation'
$cfg['Servers'][$i]['table_info'] ='';//'pma_table_info'
$cfg['Servers'][$i]['table_coords'] ='';//'pma_table_coords'
$cfg['Servers'][$i]['pdf_pages'] ='';//'pma_pdf_pages'
$cfg['Servers'][$i]['column_info'] ='';//'pma_column_info'
$cfg['Servers'][$i]['history'] ='';//'pma_history'
$cfg['Servers'][$i]['verbose_check'] =TRUE;
$cfg['Servers'][$i]['AllowDeny']['order']
='';
$cfg['Servers'][$i]['AllowDeny']['rules']
=array();
$i++;
$cfg['Servers'][$i]['host'] ='';
$cfg['Servers'][$i]['port'] ='';
$cfg['Servers'][$i]['socket'] ='';
$cfg['Servers'][$i]['connect_type'] ='tcp';
$cfg['Servers'][$i]['compress'] =FALSE;
$cfg['Servers'][$i]['controluser'] ='';
$cfg['Servers'][$i]['controlpass'] ='';
$cfg['Servers'][$i]['auth_type'] ='config';
$cfg['Servers'][$i]['user'] ='root';
$cfg['Servers'][$i]['password'] ='';
$cfg['Servers'][$i]['only_db'] ='';
$cfg['Servers'][$i]['verbose'] ='';
$cfg['Servers'][$i]['pmadb'] ='';//'phpmyadmin'-seescripts/create_tables.sql
$cfg['Servers'][$i]['bookmarktable'] ='';//'pma_bookmark'
$cfg['Servers'][$i]['relation'] ='';//'pma_relation'
$cfg['Servers'][$i]['table_info'] ='';//'pma_table_info'
$cfg['Servers'][$i]['table_coords'] ='';//'pma_table_coords'
$cfg['Servers'][$i]['pdf_pages'] ='';//'pma_pdf_pages'
$cfg['Servers'][$i]['column_info'] ='';//'pma_column_info'
$cfg['Servers'][$i]['history'] ='';//'pma_history'
$cfg['Servers'][$i]['verbose_check'] =TRUE;
$cfg['Servers'][$i]['AllowDeny']['orde
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- PHPMyadmin 配置文件 详解