2015年计算机四级指导：MYSQL每my.cnf饜离笢恅砆賤
发布时间：2010/3/10 18:11:56 来源：城市学习网 编辑：MOON
basedir = path 妏蚚跤隅醴翹釬峈跦醴翹﹝
character-sets-dir = path 跤堤湔溫覂趼睫摩腔醴翹﹝
datadir = path 植跤隅醴翹黍?杅擂踱恅璃﹝
pid-file = filename 峈mysqld最唗硌隅珨跺湔溫輛最ID腔恅璃; Init-V褐掛剒猁妏蚚涴跺恅璃爵腔輛最ID賦旰mysqld輛最﹝
socket = filename 峈MySQL諦誧最唗迵督昢?眳潔腔掛華籵陓硌隅珨跺杶諉趼恅璃﹝婓Windows遠噫狟ㄛ?彆MySQL諦誧迵督昢?岆籵徹韜靡奪耋輛俴籵陓 腔ㄛsock恁砐跤堤腔蔚岆蜆韜靡奪耋腔靡趼﹝
lower_case_table_name = 1/0 陔醴翹睿杅擂桶腔靡趼岆瘁硐埰勍妏蚚苤迡趼譫; 涴跺恁砐婓Windows遠噫狟腔蘇?扢离岆1﹝
mysqld最唗逄晟扢离
character-sets-server = name 陔杅擂踱麼杅擂桶腔蘇?趼睫摩﹝峈賸迵MySQL腔婌?唳掛悵厥潭?ㄛ涴跺趼睫摩珩褫眕蚚default-character-set恁砐跤堤; 筍涴跺恁砐眒冪珆腕衄萸徹奀賸﹝
collation-server = name 陔杅擂踱麼杅擂桶腔蘇?齬唗源宒﹝
lanuage = name 蚚硌隅腔逄晟珆尨堤渣陓洘﹝
mysqld最唗籵陓﹜厙釐﹜陓洘假?
enable-named-pipes 埰勍Windows 2000/XP遠噫狟腔諦誧睿督昢?妏蚚韜靡奪耋輛俴籵陓﹝涴跺韜靡奪耋腔蘇?靡趼岆MySQLㄛ筍褫眕蚚socket恁砐懂蜊曹﹝
local-infile [=0] 埰勍/輦砦妏蚚LOAD DATA LOCAL逄曆懂揭燴掛華恅璃﹝
myisam-recover [=opt1， opt2， ...] 婓?雄奀赻雄党葩垀衄忳囷腔MyISAM杅擂桶﹝涴跺恁砐腔褫?硉衄4笱:DEFAULT﹜BACKUP﹜QUICK睿FORCE; 坳蠅迵myisamchk最唗腔肮靡恁砐釬蚚眈肮﹝
old-passwords 妏蚚MySQL 3.23睿4.0唳掛笢腔橾呾楊懂樓躇mysql杅擂踱爵腔躇鎢﹝
port = n 峈MySQL最唗硌隅珨跺TCP/IP籵陓傷諳﹝
safe-user-create 硐衄婓mysql.user杅擂踱桶奻茧衄INSERT?癹腔蚚誧符夔妏蚚GRANT韜鍔; 涴岆珨笱邧悵玸儂秶﹝
shared-memory 埰勍妏蚚囀湔輛俴籵陓﹝
shared-memory-base-name [...]
