MySQL 存取权限系统.docVIP

MySQL笢恅統蕉忒聊 祒氪ㄩ縒赽 (clyan@ㄘ 翋珜ㄩ -------------------------------------------------------------------------------- 菴珨梒, ?珨梒, 狟珨梒, 郔綴珨梒ㄛ醴翹. -------------------------------------------------------------------------------- 6 MySQL 湔??癹炵苀 MySQL衄珨跺珂輛筍準梓袧腔假?/?癹炵苀﹝掛誹鏡扴坳腔馱釬埻燴﹝ 6.1 ?癹炵苀酕妦繫 MySQL?癹炵苀腔翋猁髡夔岆痐妗蟀諉善珨怢跤隅翋儂腔珨跺蚚誧ㄛ甜?董軑蜆蚚誧婓珨跺杅擂踱奻select﹜ insert﹜update睿delete腔?癹﹝ 蜇樓腔髡夔婦嬤衄珨跺曩靡腔蚚誧睿勤衾MySQL杻隅腔髡夔瞰?LOAD DATA INFILE輛俴忨?摯奪燴紱釬腔夔薯﹝ 6.2 MySQL 蚚誧靡睿諳鍔 蚕MySQL妏蚚蚚誧靡睿諳鍔腔源楊迵Unix麼Windows妏蚚腔源宒衄竭嗣祥肮眳揭ㄩ MySQL妏蚚衾?痐醴腔腔蚚誧靡ㄛ迵Unix蚚誧靡(腎翹靡趼)麼Windows蚚誧靡拸壽﹝?吽華ㄛ湮嗣杅MySQL諦誧郭彸妏蚚絞?Unix蚚誧靡釬峈MySQL蚚誧靡腎翹ㄛ筍岆涴躺躺峈賸源晞﹝諦誧最唗埰勍蚚-u麼--user恁砐硌隅珨跺祥肮腔靡趼ㄛ涴砩庤覂拸蹦?睡斕祥夔妏腕珨跺杅擂踱載假?ㄛ壺準垀衄腔MySQL蚚誧靡飲衄諳鍔﹝?睡?褫眕彸芞蚚?睡靡趼蟀諉督昢?ㄛ奧??彆坻蠅硌隅賸羶衄諳鍔腔?睡靡趼ㄛ坻蠅蔚傖髡﹝ MySQL蚚誧靡郔酗褫眕岆16跪趼睫˙萎倰華ㄛUnix蚚誧靡癹秶峈8跺趼睫﹝ MySQL諳鍔迵Unix諳鍔羶壽炵﹝婓斕妏蚚腎翹善珨怢Unix儂?諳鍔睿斕妏蚚婓饒怢儂?奻湔?珨跺杅擂踱腔諳鍔眳潔羶衄斛猁衄壽薊﹝ MySQL樓躇諳鍔妏蚚賸珨跺Unix腎翹?潔垀蚚腔祥肮呾楊ㄛ獗7.4.12 娸砐滲杅珨誹笢鏡扴PASSWORD()睿ENCRYPT()滲杅窒煦﹝ 6.3 迵MySQL督昢?蟀諉 絞斕砑猁湔?珨跺MySQL督昢?奀ㄛMySQL諦誧最唗珨啜猁?斕硌隅蟀諉統杅ㄩ斕砑猁薊諉腔翋儂﹜斕腔蚚誧靡睿斕腔諳鍔﹝瞰?ㄛmysql諦誧褫眕砓涴欴?雄(褫恁腔統杅掩婦嬤婓[睿]眳潔)ㄩ shell mysql [-h host_name][-u user_name][-pyour_pass ] -h, -u睿-p恁砐腔鍚珨笱倛宒岆--host=host_name﹜--user=user_name睿--password=your_pass﹝蛁砩婓-p麼--password=迵躲呴坳綴醱腔諳鍔眳潔羶衄諾跡﹝ 蛁砩ㄩ婓韜鍔俴奻硌隅珨跺諳鍔岆祥假?腔ㄐ呴綴婓斕炵苀奻腔?睡蚚誧褫眕籵徹湖濬侔涴欴腔韜鍔楷珋斕腔諳鍔ㄩps auxww﹝獗4.15.4 恁砐恅璃﹝ 勤衾韜鍔俴羶衄腔薊諉統杅ㄛmysql妏蚚?吽硉ㄩ ?吽翋儂靡岆localhost﹝ ?吽蚚誧靡岆斕腔Unix腎翹靡﹝ ?彆羶衄-pㄛ寀羶衄枑鼎諳鍔﹝ 涴欴, 勤珨跺Unix蚚誧joeㄛ狟蹈韜鍔岆脹歎腔ㄩ shellmysql -h localhost -u joe shellmysql -h localhost shellmysql -u joe shellmysql ?坳MySQL諦誧最唗衄肮欴桶珋﹝ 婓Unix炵苀奻ㄛ絞斕輛俴珨跺蟀諉奀ㄛ斕褫眕硌隅猁妏蚚腔祥肮腔?吽硉ㄛ涴欴斕祥斛藩棒婓斕覃蚚珨跺諦誧最唗岆婓韜鍔俴奻怀?坻蠅﹝涴褫眕衄竭嗣源楊酕善ㄩ 斕夔婓斕腔翋醴翹狟.f腔饜离恅璃腔[client]苤誹爵硌隅蟀諉統杅﹝恅璃腔眈壽苤誹艘奻?褫夔砉涴欴ㄩ [client] host=host_name user=user_name password=your_pass 獗4.15.4 恁砐恅璃﹝ 斕褫眕蚚遠噫曹講硌隅蟀諉統杅﹝翋儂褫蚚MYSQL_HOST硌隅ㄛMySQL蚚誧靡趼褫蚚USER硌隅(躺勤 Windows)ㄛ諳鍔褫蚚MYSQL_PWD硌隅ㄗ筍岆涴祥假?ㄛ獗狟珨誹) ﹝ ?彆蟀諉統杅眕嗣笱源楊掩硌隅ㄛ婓韜鍔俴奻掩硌隅腔硉蚥珂衾婓饜离恅璃睿遠噫曹講笢硌隅腔硉ㄛ奧婓饜离恅璃硌隅腔硉蚥珂衾婓遠噫曹講硌隅腔硉﹝ 6.4 妏斕腔諳鍔假? 眕珨笱惟繞腔褫掩?坻蚚誧楷珋腔源宒硌隅斕腔諳鍔岆祥邰絞腔﹝絞斕堍俴諦誧最唗奀ㄛ斕褫眕妏蚚狟蹈源楊硌隅斕腔諳鍔ㄛ遜衄藩跺源楊腔瑞玸?嘛ㄩ 妏蚚珨跺婓韜鍔俴奻-pyour_pass麼--password=your_pass腔恁砐﹝涴竭源晞筍岆祥假?ㄛ秪峈斕腔諳鍔勤炵苀袨怓最唗(瞰?ps)曹腕褫獗ㄛ坳褫眕掩?坻腔蚚誧覃蚚懂珆尨韜鍔俴﹝(珨啜MySQL諦誧婓坻蠅腔場