Mysql芦廾廣吭並?、芦廾払移議励倖圻咀
<貧匯准
和匯准>
危列1?wizard芦廾恷朔匯匈?竃孖cannot create Windows service for mysql.error:0 危列
盾畳圭隈?嬉蝕凋綜佩 補秘 sc delete mysql 凋綜軸
C:>sc delete mysql
[SC] DeleteService SUCCESS
嶷軟窮辻?賜宀亢墮朔嶷尼壅芦廾?宸劔祥挫阻。厘頁亢墮朔嶷尼議。
亢墮嶷仟芦廾勣廣吭匯倖諒籾?壓陣崙中医嶄亢墮朔?勣肇c:\Documents and Settings\All Users\Application Data朕村和委Mysql猟周斜評渠。戦中辛嬬芝墮阻低亢墮議塘崔佚連?和肝芦廾扮氏嗤唹峒。
危列2?壓斑補秘砿尖埀補秘畜鷹扮茅阻password才confirm password岻翌珊嗤匯佩current password。
宸傍苧低芦廾岻念短嗤委厘及1訳嶄傍議朕村和委Mysql猟周斜評茅。音岑祇頁倦唹峒朔偬聞喘?辛嬬芝誼畜鷹議三短購狼。総現揮匯鞘?砿尖埀畜鷹頁徭失譜議?喘薩兆夸葎潮範root。
芦廾撹孔朔辛霞編泌和?嬉蝕mysql command line client,補秘畜鷹?竃孖
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.33-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
夸芦廾撹孔?
危列3?mysql server configuration払移。
壓塘崔?擬嶄臥心危列戻幣嗤泌和囂鞘?
mysql-server-5.5-win32:60 - Adding firewall rule for MySQL55 on port 3306.
mysql-server-5.5-win32:66 - Adding firewall rule failed.
燕幣契諮能芦廾払移。
臥心芦廾晩崗嬬孀欺參和囂鞘?
mysql-installer Information: 10 : Attempting to create firewall rule with command: netsh.exe firewall add portopening protocol=TCP port=3306 profile=ALL name=MySQL55 mode=ENABLE scope=ALL
mysql-installer Information: 10 : Unexpected response from netsh: 鳩協。
mysql-installer Information: 10 : Attempting to create firewall rule with command: netsh.exe advfirewall firewall add rule name=”Port 3306” protocol=TCP localport=3306 dir=in action=allow
mysql-installer Information: 10 : Unexpected response from netsh: 和双凋綜短嗤孀欺: advfirewall firewall add rule name=”Port 3306” protocol=TCP localport=3306 dir=in action=allow。
宸嶽秤趨傍苧mysql議芦廾斤嶄猟狼由屶隔誼音挫?音嬬紛艶 netsh.exe卦指議“鳩協”佚連?写遇塰佩嬬壓凪麿windows峠岬貧塰佩議netsh.exe advfirewall凋綜?乎凋綜xp音屶隔?侭參烏孀音欺乎凋綜議危列。
盾畳一隈嗤曾倖?
?繍徭失議荷恬狼由議囂冱譜崔葎哂猟?隼朔嶷仟芦廾mysql 。醤悶議辛參序秘陣崙中医->曝囃才囂冱 嶄肇厚個?総翌?殊臥輝念喘薩頁倦嗤尼強契諮能議幡尫?壓柴麻字捲暦嶄臥心Application Layer Gateway Service議奉來?臥心鞠村僉?触嶄議喘薩頁倦頁輝念喘薩。
?殊臥契諮能極笥?泌惚厮将耶紗撹孔阻?夸音恬侃尖?泌惚短嗤撹孔耶紗?夸徭失返強壓契諮能嶄耶紗極笥。
危列4?芦廾撹孔岻朔?峪嬬宥狛mysql 5.5 command line client 銭俊localhost議mysql server?遇音嬬宥狛workbench賜凪麿人薩極垢醤序佩垓殻銭俊mysql server。
購囚忖?音嬬垓殻銭俊mysql server。
辛嬬圻咀?
?短嗤蝕極笥?歌需念匯訳盾畳。
?喘薩短嗤娩幡垓殻銭俊。
?mysql server音塋俯垓殻銭俊。
斤噐?喘薩短嗤娩幡垓殻銭俊?辛參公喘薩娩幡?箭泌潮範議root喘薩?辛參壓mysql 5.5 command line client 嶄補秘泌和凋綜?
//僉夲方象垂
mysql>use mysql;
//公喘薩娩幡?yourpassword忖粁喘低議畜鷹旗紋
mysql>grant all priileges on *.* to identified by 'yourpassword';
//泡仟狼由幡尫燕
mysql>flush privileges;
//臥心頁倦娩幡撹孔
mysql> show grants for roots;
泌惚竃孖胡胡議娩幡?夸燕幣撹孔。音撹孔議三?徭失壅耶紗匯倖仟喘薩編編?耶紗喘薩議凋綜?
insert into mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) values("%","newuser",password("newpassword"),'','','')
斤噐?mysql server音塋俯垓殻銭俊議盾畳一隈頁?孀欺徭失議my.ini?壓[mysqld]和奐紗匯佩囂鞘?
bind-address=0.0.0.0
燕幣音鰯協IP?嶷尼低議Mysql捲暦。
危列5?塘崔猟周my.ini議了崔
MySQL塘崔?擬繍my.ini猟周慧崔壓MySQL捲暦匂議芦廾朕村嶄。宸繍嗤廁噐繍塘崔猟周才醤悶議捲暦匂糞箭屢 購選。葎阻隠屬MySQL捲暦匂岑祇欺陳戦臥孀my.ini猟周?才和中坪否窃貌議歌方繍氏瓜恬葎捲暦芦廾議匯何蛍 勧弓公MySQL捲暦匂?--defaults-file="C:\Program Files\MySQL\MySQL Server 5.5\my.ini C:\Program Files\MySQL\MySQL Server 5.5辛參瓜峺?MySQL捲暦匂議芦廾揃抄侭旗紋。
園辞my.ini猟?辛參聞喘猟云園辞匂嬉蝕乎猟周揖扮恂竃駅勣議園辞才俐個。低匆辛參參MySQL Administrator議哘喘殻會栖俐 個捲暦匂塘崔。 MySQL人薩極才哘喘殻會?箭泌mysql凋綜佩人薩極才mysqldump旺音嬬鳩協了噐捲暦匂芦廾朕村嶄議my.ini猟周 議了崔。葎阻塘崔人薩極才哘喘殻會?功象低議Windows井云議音揖?壓C:\Windows和賜宀壓C:\WINNT朕村和伏 撹仟議猟周my.ini 猟周
泌惚低議MySQL塘崔?擬窟孖阻匯倖厮将贋壓議my.ini猟周?低辛參嶷仟塘崔厮将贋壓議捲暦匂?賜宀宥狛評茅 my.ini猟周、唯峭旺卞茅MySQL捲暦議圭隈卞茅捲暦匂糞箭。嶷仟塘崔厮将贋壓議捲暦匂?僉夲“嶷仟塘崔糞箭”僉?旺拝僉夲“和匯化”梓泥。厮将贋壓議my.ini猟周瓜 嶷仟凋兆葎mytimestamp.ini.bak?扮寂漢頁厮将贋壓議my.ini幹秀扮議晩豚才扮寂。卞茅厮将贋壓議方象垂糞 箭?僉夲“卞茅糞箭”僉?旺僉夲“和匯化”梓泥。泌惚僉夲阻“卞茅糞箭”僉??序秘欺鳩範順中。汽似“塰佩”梓泥?MySQL塘崔?擬唯峭旺蝕兵卞茅MySQL捲 暦?旺評茅my.ini猟周。徽捲暦匂芦廾朕村旺短嗤卞茅。泌惚僉夲阻“嶷仟塘崔糞箭”僉??序秘欺“塘崔窃侏”順中?辛參僉夲芦廾?勣塘崔議芦廾窃侏。
盾畳圭隈?嬉蝕凋綜佩 補秘 sc delete mysql 凋綜軸
C:>sc delete mysql
[SC] DeleteService SUCCESS
嶷軟窮辻?賜宀亢墮朔嶷尼壅芦廾?宸劔祥挫阻。厘頁亢墮朔嶷尼議。
亢墮嶷仟芦廾勣廣吭匯倖諒籾?壓陣崙中医嶄亢墮朔?勣肇c:\Documents and Settings\All Users\Application Data朕村和委Mysql猟周斜評渠。戦中辛嬬芝墮阻低亢墮議塘崔佚連?和肝芦廾扮氏嗤唹峒。
危列2?壓斑補秘砿尖埀補秘畜鷹扮茅阻password才confirm password岻翌珊嗤匯佩current password。
宸傍苧低芦廾岻念短嗤委厘及1訳嶄傍議朕村和委Mysql猟周斜評茅。音岑祇頁倦唹峒朔偬聞喘?辛嬬芝誼畜鷹議三短購狼。総現揮匯鞘?砿尖埀畜鷹頁徭失譜議?喘薩兆夸葎潮範root。
芦廾撹孔朔辛霞編泌和?嬉蝕mysql command line client,補秘畜鷹?竃孖
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.33-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
夸芦廾撹孔?
危列3?mysql server configuration払移。
壓塘崔?擬嶄臥心危列戻幣嗤泌和囂鞘?
mysql-server-5.5-win32:60 - Adding firewall rule for MySQL55 on port 3306.
mysql-server-5.5-win32:66 - Adding firewall rule failed.
燕幣契諮能芦廾払移。
臥心芦廾晩崗嬬孀欺參和囂鞘?
mysql-installer Information: 10 : Attempting to create firewall rule with command: netsh.exe firewall add portopening protocol=TCP port=3306 profile=ALL name=MySQL55 mode=ENABLE scope=ALL
mysql-installer Information: 10 : Unexpected response from netsh: 鳩協。
mysql-installer Information: 10 : Attempting to create firewall rule with command: netsh.exe advfirewall firewall add rule name=”Port 3306” protocol=TCP localport=3306 dir=in action=allow
mysql-installer Information: 10 : Unexpected response from netsh: 和双凋綜短嗤孀欺: advfirewall firewall add rule name=”Port 3306” protocol=TCP localport=3306 dir=in action=allow。
宸嶽秤趨傍苧mysql議芦廾斤嶄猟狼由屶隔誼音挫?音嬬紛艶 netsh.exe卦指議“鳩協”佚連?写遇塰佩嬬壓凪麿windows峠岬貧塰佩議netsh.exe advfirewall凋綜?乎凋綜xp音屶隔?侭參烏孀音欺乎凋綜議危列。
盾畳一隈嗤曾倖?
?繍徭失議荷恬狼由議囂冱譜崔葎哂猟?隼朔嶷仟芦廾mysql 。醤悶議辛參序秘陣崙中医->曝囃才囂冱 嶄肇厚個?総翌?殊臥輝念喘薩頁倦嗤尼強契諮能議幡尫?壓柴麻字捲暦嶄臥心Application Layer Gateway Service議奉來?臥心鞠村僉?触嶄議喘薩頁倦頁輝念喘薩。
?殊臥契諮能極笥?泌惚厮将耶紗撹孔阻?夸音恬侃尖?泌惚短嗤撹孔耶紗?夸徭失返強壓契諮能嶄耶紗極笥。
危列4?芦廾撹孔岻朔?峪嬬宥狛mysql 5.5 command line client 銭俊localhost議mysql server?遇音嬬宥狛workbench賜凪麿人薩極垢醤序佩垓殻銭俊mysql server。
購囚忖?音嬬垓殻銭俊mysql server。
辛嬬圻咀?
?短嗤蝕極笥?歌需念匯訳盾畳。
?喘薩短嗤娩幡垓殻銭俊。
?mysql server音塋俯垓殻銭俊。
斤噐?喘薩短嗤娩幡垓殻銭俊?辛參公喘薩娩幡?箭泌潮範議root喘薩?辛參壓mysql 5.5 command line client 嶄補秘泌和凋綜?
//僉夲方象垂
mysql>use mysql;
//公喘薩娩幡?yourpassword忖粁喘低議畜鷹旗紋
mysql>grant all priileges on *.* to identified by 'yourpassword';
//泡仟狼由幡尫燕
mysql>flush privileges;
//臥心頁倦娩幡撹孔
mysql> show grants for roots;
泌惚竃孖胡胡議娩幡?夸燕幣撹孔。音撹孔議三?徭失壅耶紗匯倖仟喘薩編編?耶紗喘薩議凋綜?
insert into mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) values("%","newuser",password("newpassword"),'','','')
斤噐?mysql server音塋俯垓殻銭俊議盾畳一隈頁?孀欺徭失議my.ini?壓[mysqld]和奐紗匯佩囂鞘?
bind-address=0.0.0.0
燕幣音鰯協IP?嶷尼低議Mysql捲暦。
危列5?塘崔猟周my.ini議了崔
MySQL塘崔?擬繍my.ini猟周慧崔壓MySQL捲暦匂議芦廾朕村嶄。宸繍嗤廁噐繍塘崔猟周才醤悶議捲暦匂糞箭屢 購選。葎阻隠屬MySQL捲暦匂岑祇欺陳戦臥孀my.ini猟周?才和中坪否窃貌議歌方繍氏瓜恬葎捲暦芦廾議匯何蛍 勧弓公MySQL捲暦匂?--defaults-file="C:\Program Files\MySQL\MySQL Server 5.5\my.ini C:\Program Files\MySQL\MySQL Server 5.5辛參瓜峺?MySQL捲暦匂議芦廾揃抄侭旗紋。
園辞my.ini猟?辛參聞喘猟云園辞匂嬉蝕乎猟周揖扮恂竃駅勣議園辞才俐個。低匆辛參參MySQL Administrator議哘喘殻會栖俐 個捲暦匂塘崔。 MySQL人薩極才哘喘殻會?箭泌mysql凋綜佩人薩極才mysqldump旺音嬬鳩協了噐捲暦匂芦廾朕村嶄議my.ini猟周 議了崔。葎阻塘崔人薩極才哘喘殻會?功象低議Windows井云議音揖?壓C:\Windows和賜宀壓C:\WINNT朕村和伏 撹仟議猟周my.ini 猟周
泌惚低議MySQL塘崔?擬窟孖阻匯倖厮将贋壓議my.ini猟周?低辛參嶷仟塘崔厮将贋壓議捲暦匂?賜宀宥狛評茅 my.ini猟周、唯峭旺卞茅MySQL捲暦議圭隈卞茅捲暦匂糞箭。嶷仟塘崔厮将贋壓議捲暦匂?僉夲“嶷仟塘崔糞箭”僉?旺拝僉夲“和匯化”梓泥。厮将贋壓議my.ini猟周瓜 嶷仟凋兆葎mytimestamp.ini.bak?扮寂漢頁厮将贋壓議my.ini幹秀扮議晩豚才扮寂。卞茅厮将贋壓議方象垂糞 箭?僉夲“卞茅糞箭”僉?旺僉夲“和匯化”梓泥。泌惚僉夲阻“卞茅糞箭”僉??序秘欺鳩範順中。汽似“塰佩”梓泥?MySQL塘崔?擬唯峭旺蝕兵卞茅MySQL捲 暦?旺評茅my.ini猟周。徽捲暦匂芦廾朕村旺短嗤卞茅。泌惚僉夲阻“嶷仟塘崔糞箭”僉??序秘欺“塘崔窃侏”順中?辛參僉夲芦廾?勣塘崔議芦廾窃侏。
<貧匯准
和匯准>