MySQL安装详细步骤及解决1067与2003两个问题方法

1、Q Ifjjj F面的是MySQL安装的图解，用的可执行文件安装的，详细说明了一下! ，双击解压缩，运行 打开下载的mysql安装文件mysql-5.5.15-win32.zip “ setup. exe ，出现如下界面 MySQL Server 5,5 Setup Welcome to the MySQL Server 5.5 Setup Wizard The Setup Wizard will install MySQL Server 5*5 on your computer* Click Next to continue or Cancel to exit the Setup Wizar

2、d, Copyright (c) 2000, 2011, Oracle anct/or its affilietes. All rights reserved. 日 Next Cancel mysql安装向导启动，按“ Next继续 囹 MySQL Server 5.5 Setup End-User License Agreement Please read the following license agreement carefully GNU GENERAL PUBLIC LICENSE Version 2, June 1991 Copyiigtit (C) 19S9, 1991 Fre

3、e Software Foundation, Inc. t SI Franklin Street, Fifth FloorBoston, MA 02110-1301 USA Everyone ia permitted co copy and diatribut皀 verbatim copies of thrs license document, bun changing it is not allowed. PrealWle The licenses for moat software are designed to take away your freedom to share and ch

4、ange it. By contrast, the GNU General Public License is intended to guarantee your freedom to ahar皀 and change 21 accept the terms in the License Agreement Print Back Next1 Cancel 按“ Next”继续 囹 MySQL Server 55 Setup Choose Setup Type Choose the setup tyP昌 that best stirte your needs Typical Installs

5、the most common program features. Recomrnended for most users. Custom Allows users to choose which program features will be irstalledl and where they will be installed- Recommended for advanced users. Complete All program features will be insUlled, Requires the most disk space* eackCancel 选择安装类型，有 “

6、 Ty pical （默认）”、“Com plete （完全）”、“ Custom （用户自定 义）”三个选项，我们选择“Typical ”出现下图所示界面： 餌 MySQL Server 5*5 Setup Ready to install MySQL Server 5.5 El Click Install to begin ttie installation. Click Sack to review or change any of your installation settings- Click Cancel to exit the wizard* eack Install Canc

7、el 点击“ in stall ”以继续，出现下图界面: 囹 MySQL Server 5.5 Setup Installing MySQL Server 5.5 Please wait while the Setup Wizard installs MySQL Server 5.5. Status: Copying new files Cancel 按“ Next继续，出现下图: MySQL Enterprise Enterprise A MySQL Enterprise $ubscrlpck)n (s the most comprehenstve offering of MySQL dat

8、abase software, services, and sup port to ensure your business achieves the highest levels of reliabilhy, security, and uptime. An Enterpri玉e SubscrIptIon Includes： 1. The MySQL Enterprise Server-The most reliable, secure, and up-to-date version of the world古 most popular op总n source database. 2. My

9、SQL Enterprise Monitor Service - An automated virtual database assistant 3. MiySQL Preduction Support - Technical andconsultattve support when you need 也 along with service packs, hot-fixes, and more. liyir IK也I中g!lL聊*dbti （运行一次就行了，GBK可以替 换为其它值，视这里的设置而定），就可以正常的使用汉字（或其它文字）了，否则不能正 常显示汉字。按“ Next ”继续。 M

10、ySQIL Server Instance Configuration Wizard MySQL Server Instance Configuration Configure the MySQL Server 55 server instance, Please set theWimdows options* 7 Install As Windows Service * r F This is the recommended way to run the MySQL server on Windows. Service Name: 卩疋二 冋 Launch the MySQL Server

11、automatical Indude Bin Directory in Windows PATH Checkthis option to include the directory containing the server / client etecutables in the Windows PATH variable so they can be called from Back I Cancel 选择是否将mysql安装为windows 名称），是否将mysql的bin目录加入到 下的文件，而不用指出目录名，比如连接， 可以了，不用指出mysql.exe的完整地址, 不变。按“ Nex

12、t ”继续。 服务，还可以指定 Service Name （服务标识 Win dows P ATH（加入后，就可以直接使用bin “mysql.exe -uusername -ppassword; ” 就 很方便），我这里全部打上了勾，Service Name MySQL Server InstarKe Configuration Configure the MySQL Server5.5 server instance. 卩lease set the security options, Hodify Security Settings New root password: Enter the

13、 root p自站word. Confirm; Retype the password. 1 Enable root access from remote machines I Create Ar Anonymous Account I This option willl crwte in anonymous account on this server, iP鹿3ie note that this can I亡ad to an insecure lyrtem, k. pingf localliost 亠吐 TrnmTrmTn In a :-; 畀回可回回 k勺勺勺勺 9 n 1 1 1 1

14、i :-:; p -=1J具有32于T的数据二 lins linE lins lins 行 ping localhost, 此时需卸载IPv6功能，使用命令ipv6 unin stall，卸载元成后再进 此时会发现是有127.0.0.1返回数据，此时再继续执行安装程序，问题解 决。出师表 两汉：诸葛亮 先帝创业未半而中道崩殂，今天下三分，益州疲弊，此诚危急存亡之秋也。然侍卫之臣 不懈于内，忠志之士忘身于外者，盖追先帝之殊遇，欲报之于陛下也。诚宜开张圣听，以光 先帝遗德，恢弘志士之气，不宜妄自菲薄，引喻失义，以塞忠谏之路也。 宫中府中，俱为一体；陟罚臧否，不宜异同。若有作奸犯科及为忠善者，宜付有

15、司论其 刑赏，以昭陛下平明之理；不宜偏私，使内外异法也。 侍中、侍郎郭攸之、费祎、董允等，此皆良实，志虑忠纯，是以先帝简拔以遗陛下：愚 以为宫中之事，事无大小，悉以咨之，然后施行，必能裨补阙漏，有所广益。 将军向宠，性行淑均，晓畅军事，试用于昔日，先帝称之曰 能”是以众议举宠为督: 愚以为营中之事，悉以咨之，必能使行阵和睦，优劣得所。 亲贤臣，远小人，此先汉所以兴隆也； 亲小人，远贤臣，此后汉所以倾颓也。 先帝在时, 每与臣论此事，未尝不叹息痛恨于桓、 灵也。侍中、尚书、长史、参军，此悉贞良死节之臣, 愿陛下亲之、信之，则汉室之隆，可计日而待也 臣本布衣，躬耕于南阳，苟全性命于乱世，不求闻达于诸侯。先帝不以臣卑鄙，猥自枉 屈，三顾臣于草庐之中，咨臣以当世之事，由是感激，遂许先帝以驱驰。后值倾覆，受任于 败军之际，奉命于危难之间，尔来二十有一年矣。