在Windows 2008 R2 SP1里安装mysql 8 - zip包|云服务器 ECS - 开发者论坛

陈丽濠

<div class="f14 mb10" id="read_tpc">
<span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=环境',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_6">环境</span>：Windows 2008 R2 SP1，mysql-8.0.12-winx64<span style="display:none"> 'b1k0        9' </span>&nbsp;<br /> <span style="display:none"> H%y!lR{c^D </span>&nbsp;<br />过程：<span style="display:none">  CNP!v\D </span>&nbsp;<br /> <span style="display:none"> Lmh4ezrdH </span>&nbsp;<br />1.安装好mysql8要求的Visual C++ 2015 运行时组件，如果没有<span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=安装',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_4">安装</span>，会报错<span style="display:none"> %QYW0lE </span>&nbsp;<br /><span id="att_144040" class="f12"><span id="td_att144040" onmouSEOver="read.open('menu_att144040','td_att144040');" style="display:inline-block;"><img src="http://bbs.aliyun.com/attachment/Fid_207/207_1477160476054779_72aec6411976620.png?8" border="0" style="max-width:995px;" onload="if(this.offsetWidth>'995')this.width='995';"></span><div id="menu_att144040" class="pw_menu" style="display:none;"><div style="border:1px solid #ffffff;background:#f3f9fb;padding:5px 10px;"><p><span class="mr10">图片:mysql8-win-1.png</span></p></div></div></span><span style="display:none"> &lt;Cv6wC= </span>&nbsp;<br /> <span style="display:none"> Ix~_.& </span>&nbsp;<br />2.在<span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=mysql',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_5">mysql</span>官方下载mysql-8.0.12-winx64.zip，本例解压到 D:\mysql8<span style="display:none"> nSR7$yS_ </span>&nbsp;<br /> <span style="display:none"> 55LW[Pc </span>&nbsp;<br />3.创建好mysql的<span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=配置',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_1">配置</span>文件my.ini，内容如下，指定mysql的目录及data目录路径<span style="display:none"> %        \N52 </span>&nbsp;<br /><div class="f12">复制代码</div><div class="blockquote2" id="code1"><ol><li>[mysqld]</li><li># set basedir to your installation path</li><li>basedir=D:\\mysql8</li><li># set datadir to the location of your data directory</li><li>datadir=D:\\mysql8\\data</li></ol></div><span style="display:none"> iwM$U(
9 </span>&nbsp;<br />4.在命令提示符里，转到 `D:\mysql8\bin` 目录，执行 mysqld&nbsp;&nbsp;--initialize --console ，初始化<span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=数据',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_2">数据</span>库，完成后会显示初始的root密码<span style="display:none"> E^'f'\m </span>&nbsp;<br /><span id="att_144041" class="f12"><span id="td_att144041" onmouseover="read.open('menu_att144041','td_att144041');" style="display:inline-block;"><img src="http://bbs.aliyun.com/attachment/Fid_207/207_1477160476054779_0d9106f279a4735.png?9" border="0" style="max-width:995px;" onload="if(this.offsetWidth>'995')this.width='995';"></span><div id="menu_att144041" class="pw_menu" style="display:none;"><div style="border:1px solid #ffffff;background:#f3f9fb;padding:5px 10px;"><p><span class="mr10">图片:mysql8-win-2.png</span></p></div></div></span><span style="display:none"> b~oQhU??" </span>&nbsp;<br /> <span style="display:none"> Uphme8SX </span>&nbsp;<br />5.执行 mysqld --install MySQL --defaults-file=D:\mysql8\my.ini，安装mysql的Windows服务<span style="display:none"> 'tyblj C </span>&nbsp;<br /><span id="att_144042" class="f12"><span id="td_att144042" onmouseover="read.open('menu_att144042','td_att144042');" style="display:inline-block;"><img src="http://bbs.aliyun.com/attachment/Fid_207/207_1477160476054779_dd4381971525949.png?2" border="0" style="max-width:995px;" onload="if(this.offsetWidth>'995')this.width='995';"></span><div id="menu_att144042" class="pw_menu" style="display:none;"><div style="border:1px solid #ffffff;background:#f3f9fb;padding:5px 10px;"><p><span class="mr10">图片:mysql8-win-3.png</span></p></div></div></span><span style="display:none"> '        5tk0A </span>&nbsp;<br /> <span style="display:none"> Vd%%lv{v </span>&nbsp;<br />6.转到Windows服务列表，启动mysql<span style="display:none"> qK=uSLo\+ </span>&nbsp;<br /><span id="att_144043" class="f12"><span id="td_att144043" onmouseover="read.open('menu_att144043','td_att144043');" style="display:inline-block;"><img src="http://bbs.aliyun.com/attachment/Fid_207/207_1477160476054779_31953a459ba94b2.png?20" border="0" style="max-width:995px;" onload="if(this.offsetWidth>'995')this.width='995';"></span><div id="menu_att144043" class="pw_menu" style="display:none;"><div style="border:1px solid #ffffff;background:#f3f9fb;padding:5px 10px;"><p><span class="mr10">图片:mysql8-win-4.png</span></p></div></div></span><span style="display:none"> dC,a~`%O </span>&nbsp;<br /> <span style="display:none"> bn*SLWWQ.3 </span>&nbsp;<br />7.连接mysql，执行 mysql -u root -p，输入初始<span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=密码',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_3">密码</span>。在mysql里执行 ALTER USER &#39;root&#39;@&#39;localhost&#39; IDENTIFIED BY &#39;e0gfwztSt&#39;; 来更改数据库root用户的密码<span style="display:none"> #LU&lt;v </span>&nbsp;<br /><span id="att_144044" class="f12"><span id="td_att144044" onmouseover="read.open('menu_att144044','td_att144044');" style="display:inline-block;"><img src="http://bbs.aliyun.com/attachment/Fid_207/207_1477160476054779_eb9a705a58c9aa2.png?11" border="0" style="max-width:995px;" onload="if(this.offsetWidth>'995')this.width='995';"></span><div id="menu_att144044" class="pw_menu" style="display:none;"><div style="border:1px solid #ffffff;background:#f3f9fb;padding:5px 10px;"><p><span class="mr10">图片:mysql8-win-5.png</span></p></div></div></span><span style="display:none"> NAg9EaWja{ </span>&nbsp;<br /> <span style="display:none"> Sao4MkSz[] </span>&nbsp;<br />参考：<span style="display:none"> yq7gBkS </span>&nbsp;<br /><ul style="margin:0 0 0 25px"><li><span onclick="sendmsg('pw_ajax.php','action=relatetag&tagname=https',this.id)" style="cursor:pointer;border-bottom: 1px solid #FA891B;" id="rlt_7">https</span>://dev.mysql.com/doc/refman/8.0/en/windows-install-archive.html</li><li>https://stackoverflow.com/questions/33467337/reset-mysql-root-password-using-alter-user-statement-after-install-on-mac</li></ul><span style="display:none"> mc
FSWmq </span>&nbsp;<br /><div id="alert_tpc" style="color:gray;margin-top:30px">[ 此帖被dongshan8在2018-08-14 17:42重新编辑 ]</div>
</div>
</div>
<!--content_read-->
</td>
</tr>
<tr>