MySql_5.5安装现用图解说明书(超详细)

合集下载

完美解决mysql5.5无法插入中文数据及插入后显示乱码(亲测成功)

完美解决mysql5.5无法插入中文数据及插入后显示乱码(亲测成功)

将对应的last1都改为utf8;并在 client 和mysqid的port下都添加一句
default-character-set=utf8
3.在数据库中
show Variables like'%set%';
敲如下命令;SET character_set_database=utf8;
在试试下面这句:
SET character_set_results=gbk;
现在你查询出来的可能就不是乱码了!
但是通常需要每次都得执行上面的语句才能将乱码变为正常!虽然有点麻烦,但起码也比插入不了数据库强是吧,并且这种方法,在用eclipse JDBC连接数据库的时候,是不会出现乱码的!
SET character_set_server=utf8;
SET character_set_client=gbk;
SET racter_set_connection=gbk;
之后完所有命令,现在就应该可以插入中文了,
但是先别高兴再早奥!!如果我没猜错的话,现在的确可以插入中文了,但是从数据库里读出的中文数据一定是乱码吧???怎么办??
1.安装数据5.5 D:\Program Files\安装包\mysql-5.5.20-win32.msi
根据提示点击下一步,需要特别注意,在选择编码格式的时候一定要 选utf8,切忌不可使用系统自带lasten1,否则后面会很麻烦。
2.打开安装目录C:\Program Files\MySQL\MySQL Server 5.5\my.ini

MySQL 5.5安装和配置指南(为Windows) 产品名称和型号说明书

MySQL 5.5安装和配置指南(为Windows) 产品名称和型号说明书

MySQL 5.5Installation and Configuration Guide(for Windows)Part number: 5998-1361Software version: iMC PLAT 5.1 (E0202)Document version: 5P103-20111222Legal and notice information© Copyright 2010-2011 Hewlett-Packard Development Company, L.P.No part of this documentation may be reproduced or transmitted in any form or by any means without prior written consent of Hewlett-Packard Development Company, L.P.The information contained herein is subject to change without notice.HEWLETT-PACKARD COMPANY MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. Hewlett-Packard shall not be liable for errors contained herein or for incidental or consequential damages in connection with the furnishing, performance, or use of this material.The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. HP shall not be liable for technical or editorial errors or omissions contained herein.Support and other resourcesContacting HPFor worldwide technical support information, see the HP support website:/supportBefore contacting HP, collect the following information:•Product model names and numbers•Technical support registration number (if applicable)•Product serial numbers•Error messages•Operating system type and revision level•Detailed questionsSubscription serviceHP recommends that you register your product at the Subscriber's Choice for Business website:/go/wwalertsAfter registering, you will receive email notification of product enhancements, new driver versions, firmware updates, and other product resources.Related informationDocumentsTo find related documents, browse to the Manuals page of the HP Business Support Center website:/support/manuals•For related documentation, navigate to the Networking section, and select a networking category.•For a complete list of acronyms and their definitions, see HP A-Series Acronyms. Websites• •HP Networking /go/networking•HP manuals /support/manuals•HP download drivers and software /support/downloads•HP software depot ConventionsThis section describes the conventions used in this documentation set. GUI conventionsConvention DescriptionBoldface Window names, button names, field names, and menu items are in bold text. For example, the New User window appears; click OK.> Multi-level menus are separated by angle brackets. For example, File > Create > Folder./ Multi-level menus are separated by forward slashes. For example, [File/Create/Folder]. SymbolsConvention DescriptionNOTE An alert that contains additional or supplementary information.ContentsOverview (1)MySQL server installation (2)MySQL client installation (2)Configuration (7)Configuring the MySQL server instance (7)Creating a database user (15)Startup and Stop (16)Uninstallation (17)Removing the MySQL server instance (17)Uninstalling the MySQL server (19)FAQ (21)OverviewThis document describes how to install and configure the MySQL server when it is used with iMC, and the installation and configuration guidelines. This document is applicable to the MySQL 5.1 and MySQL5.5 editions. The installation is slightly different from that for other editions. This document takes theMySQL 5.5 edition for example.NOTE:Install the MySQL server and start the MySQL service before installing the iMC.MySQL server installationBefore installing the MySQL server, obtain the MySQL installation program that is applicable to the Windows operating system. This document takes mysql-5.5.5-win32.msi installation program for example. Double click the program to start the setup wizard.Figure 1MySQL server setup wizardClick Next.Figure 2 License agreement pageSelect I accept the terms in the License Agreement and click Next.Figure 3 Select a setup typeTo use the default installation path, select Typical or Complete.To customize the installed components and installation path, select Custom. In this example, select Typical and click Next.Figure 4Ready to install the MySQL serverClick Install to install the MySQL server to the host.Figure 5 Installation progressAfter the installation is complete, click Next.Figure 6 Installation is completeSelect Launch the MySQL Instance Configuration Wizard and click Finish.MySQL client installationIf an iMC server uses a separate database, you must install the MySQL client program on the iMC server.When you configure the database for iMC on the iMC deployment wizard, select Other server for Database location and enter the database server IP address.Before installing the MySQL client, obtain the MySQL installation program that is applicable to the Windows operating system. This document takes mysql-5.5.5-win32.msi installation program for example. Double click the program to start the setup wizard.Figure 7MySQL server setup wizardClick Next.Figure 8 License agreement pageSelect I accept the terms in the License Agreement and click Next. Figure 9 Select setup typeClick Customto customize installed components and installation path.Figure 10 Customize the installationSelect MySQL Server > Client Programs . To change the installation path, click Browse . Click Next.Figure 11 Ready to install the MySQL clientClick Install to install the MySQL client to the host. Figure 12 Installation progressAfter the installation is complete, click Next. Figure 13 Installation is completeDo not select Launch the MySQL Instance Configuration Wizard and click Finish.ConfigurationConfiguring the MySQL server instanceYou must configure the instance for the MySQL server but not for the MySQL client. You can continue to configure the MySQL server upon finishing the installation, or you can open the MySQL server configuration wizard by selecting Start > All Programs > MySQL 5.5 > MySQL Server Instance Configuration Wizard.Open the MySQL Server Instance Configuration Wizard page.Figure 14MySQL server instance configuration wizardClick Next.Figure 15 Select a configuration typeSelect Detailed Configuration and click Next. Figure 16 Select a server typeSelect Server Machine and click Next.Figure 17 Select the database usageSelect Transactional Database Only and click Next. Figure 18 Choose the directory for the databaseSet the directory for installing the database and click Next.Figure 19 Set the number of concurrent connections to the MySQL serverSelect Manual Setting and type 200 (recommended) for Concurrent connections . Click Next. Figure 20 Set the networking optionsSet the port number to 3306 and select Add firewall exception for this port . Click Next.Figure 21 Select the default character setSelect Manual Selected Default Character Set/Collation and set the character set according to the language of your operating system, for example, latin1 for English. Click Next. Figure 22 Set the Windows optionsSelect Install As Windows Service, and type a name for the service name, MySQL in this example. Select Include Bin Directory in Windows PATH, and click Next.Figure 23Set the security optionsSelect Modify Security Settings, set the root password, and select Enable root access from remote machines. Click Next.IMPORTANT:For iMC to correctly identify the root user password during installation, make sure that the password does not contain any of the following characters:` ' \ " ! ( ) & | \\ $ ; @ < > / ^ \t.If you do not want to change the password of the root user, create a user with root user privileges and make sure that the password does not contain any of the previous characters. For more information about creating a database user, see “Creating a database user.”Figure 24Ready to execute the settingsClick Execute to execute the MySQL server instance settings. Figure 25Configuration is completeClick Finish to complete the MySQL server instance configuration.Configure the privilege settings for the remote root user with the following commands:mysql –uroot –pmysqlgrant all privileges on *.* to root@’%’ identified by ‘mysql’ with grant option; mysql is the password for user root.Figure 26Configure the privilege settings for the remote root userThen configure the max_allowed_packet size.1.Open file my.ini in the MySQL installation path.Figure 27Configuration file path2.Add the max_allowed_packet parameter under [mysqld]. If the parameter already exists, youcan change its value.[mysqld]max_allowed_packet = 200M3.Save the changes and restart MySQL.Creating a database userYou can create new users rather than use the default user (root user) and grant them privileges to manage and operate the database.CAUTION:You can create a user on the MySQL server but not on the MySQL client.Creat a database user and grant privileges to the user with the following commands:mysql -uroot -pmysqlgrant all privileges on *.* to roottest@’%’ identified by ‘passwordtest’ with grant option;mysql is the password of the root user and passwordtest is the password of the new user roottest.Figure 28Add a database userStartup and StopOpen the Windows service management page on the MySQL server to start or stop the MySQL service.Figure 29Start or stop MySQL serviceUninstallationTo uninstall the MySQL server from the Windows operating system, remove the MySQL server instance first. You can uninstall the MySQL client from the Windows operating system directly. Removing the MySQL server instanceSelect Start > All Programs > MySQL 5.5 > MySQL Server Instance Configuration Wizard to enter the MySQL server instance configuration wizard page.Figure 30MySQL server instance configuration wizardClick Next.Figure 31 Select a maintenance optionSelect Remove Instance and click Next. Figure 32 Remove the instanceClick Execute to remove the instance.Figure 33Instance is removedUninstalling the MySQL serverSelect Control Panel > Add or Remove Programs to enter the Add or Remove Programs page where you can uninstall the MySQL server.Figure 34Uninstall the MySQL server from WindowsFAQGarbled Characters Appear in the Database TableCorrectly set the character set when you install the MySQL server. If not, garbled characters appear inthe database table. Table 1 describes the character sets for different languages. For instruction on howto set the character set, see Figure 21.Table 1Character sets for different languagesset Language CharacterEnglish latin1Japanese sjisHow can I update database passwords for iMC?The usernames and passwords used by the iMC modules are stored in cipher text in file\common\conf\ server-addr.xml in the installation path. You can use the pwdmgr.bat command toobtain passwords in clear text or update the latest passwords to the file.Usually, a user can use the database management tool to change the database password of a certainiMC module. To ensure communication between iMC and the database, use the pwdmgr.bat commandto update the corresponding password in file server-addr.xml. If iMC is deployed in distributed mode,you must update the password for every iMC server, as shown in Figure 35.Figure 35Update database passwords for iMCIn the preceding commands, dbpasswd represents the latest database password of the user imc_config,config_db represents the database name, and 192.168.20.107 represents the IP address of the database.To obtain the IP address and name of a MySQL database, view the settings of the corresponding user infile $IMCROOT/common/conf/server-addr.xml.21。

MySQL-5.5安装文档

MySQL-5.5安装文档

MySQL 5.5安装文档本文所述的安装参数,是完全适用于生产环境的。

使用统一的标准安装可明显降低管理成本,减少因MySQL安装配置参数造成的潜在各种问题。

加粗字体是需要手工在shell命令行下输入的内容或需要特别注意的内容。

若RHEL没有可用更新源,请参照yum client setup, 地址为/docs/yum目录结构约定:1.MySQL安装目录为/usr/local/mysql2. 数据及日志(mysql错误日志、慢日志、二进制日志等等)位于/data/mysqlN/目录下(N是一个数字,表示在同一机器上运行多个mysql实例)安装步骤如下:1.检查必要的库是否已经安装(ncurses, ncurses-devel, bison, bison-devel, libaio, libaio-devel, libtool* )yum -y install ncurses ncurses-devel bison bison-devel libaio libaio-devel libtool*mysql从5.5开始,使用cmake进行安装,不再使用autoconf方式,故安装前需要安装cmake软件包,但这个软件包并不包含在RHEL的yum目录中,需要手工以源代码方式安装。

cd /usr/local/srcwget /docs/mysql-5.5/cmake-2.8.5.tar.gztar zxvf cmake-2.8.5.tar.gzcd cmake-2.8.5./configuremakemake install2. 创建MySQ进程使用的帐号以及数据目录(如果不需要在此服务器上运行mysql,则此步是不必要的)useradd -M -s /sbin/nologin mysql-M : 不创建mysql账号号的主目录-s : 指定mysql账号无登录shellmkdir /data/mysql1chown -R mysql:mysql /data/mysql1mkdir /data/mysql2chown -R mysql:mysql /data/mysql23. 安装cd /usr/local/srcwget /docs/mysql-5.5/mysql-5.5.15.tar.gztar zxvf mysql-5.5.15.tar.gzcd mysql-5.5.15设置gcc的相关变量,这样编译出来的mysql性能会比较好,详情请见(/doc/refman/5.1/zh/installing.html#installing-source) CC=gcc CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti"Cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \-DWITH_MYSQLD_LDFLAGS=-all-static \-DWITH_DEBUG=OFF \-DENABLED_PROFILING=ON \-DWITH_EXTRA_CHARSETS=all \-DWITH_INNOBASE_STORAGE_ENGINE=ON \-DWITH_FEDERATED_STORAGE_ENGINE=ON \-DWITH_ARCHIVE_STORAGE_ENGINE=ON \-DWITH_EMBEDDED_SERVER=OFF \-DWITH_BLACKHOLE_STORAGE_ENGINE=ON \-DWITH_UNIT_TESTS=OFF \-DENABLE_DTRACE=OFF \-DMYSQL_DATADIR=/data/mysqlmakemake install提示:使用cmake . -LAH即可查阅所的有安装参数, 如果需要重新运行预安装程序,则需要运行make cleanrm -f CMakeCache.txtMysql安装参数,可使用cmake . -LA , 查看指定的安装参数,使用cmake . [安装参数] -L4. 建立mysql初始系统数据库(如果不需要在此服务器上运行mysql, 此步是不必要的)/usr/local/mysql/scripts/mysql_install_db \--user=mysql \--basedir=/usr/local/mysql/ \--datadir=/data/mysql1/ \--no-defaults/usr/local/mysql/scripts/mysql_install_db \--user=mysql \--basedir=/usr/local/mysql/ \--datadir=/data/mysql2/ \--no-defaults5. 建立启动配置文件及服务控制脚本(如果不需要在此服务器上运行mysql, 此步是不必要的)wget -O /etc/f /docs/mysql-5.5/f为了便于启动及通过本机mysql命令行客户端连接到本地mysql, 将mysql的执行路径加入到操作系统的PATH环境变量中:在/etc/profile文件中最末尾加入以下行:export PATH="$PATH:/usr/local/mysql/bin"导入环境变量至当前shell环境:source /etc/profile使用相应脚本测试mysql是否可启动:mysqld_multi start再使用以下命令,检查33063307两个端口是否已经被mysql监听: netstat -npl如果发现启动失败,请从以下日志文件中找线索:/usr/local/mysql/share/mysqld_multi.log/data/mysql1/mysql.err/data/mysql2/mysql.err6. 设置开机启动(如果不需要在此服务器上运行mysql, 此步是不必要的)/etc/rc.local末尾加入以下行:mysqld_multi start为确保开机启动有效,请务必重启机器予以验证。

Mysql5.5,Mysql Workbench卸载与安装

Mysql5.5,Mysql Workbench卸载与安装

Mysql 5.5 卸载卸载1、打开开始-运行,输入cmd进入控制台,输入net stop mysql,停止mysql服务;2、打开控制面板-添加或删除程序,找到mysql server,删除;3、打开开始-运行,输入regedit进入注册表编辑器,删除HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Application/MySQLHKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Application/MySQLHKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Application/MySQL4、将盘符下的原安装目录删掉;5、将X:\Documents and Settings\All Users\Application Data\MySQL文件夹删掉,X是系统盘符;6、卸载完成。

7、Mysql workbench6.1卸载1、打开控制面板-添加或删除程序,找到mysql workbench 6.1,删除;Mysql 5.5安装1、双击mysql-5.5.28-win32.msi2、点击Next继续;3、选择I accept the terms in the License Agreement,点Next继续;4、点Custom;5、点击所有部分,选择Entire feature will be installed on local hard driver,选择安装所有功能,点击Browse更改安装目录,更改完成后选择Next继续;6、点击Install安装;7、安装过程中跳出的窗口一路点击Next即可;8、安装完成,选中Launch the MySQL Instance Configuration Wizard 进行配置,点击Finish;9、点击Next;10、选中Detailed Configuration,点击Next;11、选择服务类型,测试时选择第一个,点Next;12、选择数据库用途,测试时选第一个,点Next;13、选中数据库中的数据存放地址,建议不要放在安装路径下,选择完毕后点Next;14、选择一般情况下会连接到数据库的人数;15、选择数据库连接的端口,一般使用默认值即可;16、(重要)选择数据库编码方式,选择第三个,编码选择utf-8;17、勾选Include Bin Directory in Windows PATH使mysql命令可以从命令行启动;18、设置密码,用户名默认是root,勾选Enable root access from remote machines;19、点Execute开启服务;20、服务开启成功,安装完成;Client;22、输入刚刚设置的密码,显示该界面说明服务启动成功,安装完成。

Mysql5.5.25安装图解

Mysql5.5.25安装图解

MySQL 安装配置图文全解
运行上面程序。

选择如下图→next
选中→next
next
选择默认的类型Developer default ,自己可以更改安装路径
→next
→next
选择Excute
next
next
有如下三种服务器类型可供选择:
Developer Machine(开发机器):此选项表示典型的桌面工作站,它使用最少的系统资源。

Server Machine(开发机器):此选项表示MySQL服务器可以与其他的应用程序(如,Web服务器、FTP和电子邮件等)一起运行,它将使用一定比例的系统资源。

Dedicated MySQL Server Machine(专用MySQL服务器机器):此选项表示它只运行在MySQL服务的服务器上。

若没有运行其他的应用程序,它将使用全部可用的系统资源。

Next
设置密码后Next→
Next→
下面出现的警告:adding firewall rule failed 不影响
Next
Next
Finished 这里就全部完成了。

接下来会弹出操作界面,非常简单!。

mysql5.5安装配置方法图文教程

mysql5.5安装配置方法图文教程

mysql5.5安装配置⽅法图⽂教程回忆⼀下mysql 5.5 安装配置⽅法,整理mysql 5.5 安装配置教程笔记,分享给⼤家。

1、⾸先进⼊的是安装引导界⾯2、然后进⼊的是类型选择界⾯,这⾥有3个类型:Typical(典型)、Complete(完全)、Custom(⾃定义)。

这⾥建议选择“⾃定义”(Custom)安装,这样可以⾃定义选择MySQL的安装⽬录,然后点“Next”下⼀步,出现⾃定义安装界⾯,为了数据安全起见,不建议将MySQL安装系统盘C⽬录。

3、准备安装4、安装完成之后会出现MySQL配置的引导界⾯5、这⾥有个引导配置MySQL的选项(Luanch the MySQL Instance Configuration Wizard),建议勾选⽴即配置你的MySQL6、这⾥是配置MySQL的 MySQL配置的类型,可以选择两种配置类型:Detailed Configuration(详细配置)和Standard Configuration(标准配置)。

Standard Configuration(标准配置)选项适合想要快速启动MySQL⽽不必考虑服务器配置的新⽤户。

详细配置选项适合想要更加细粒度控制服务器配置的⾼级⽤户。

如果你是MySQL的新⼿,需要配置为单⽤户开发机的服务器,Standard Configuration(标准配置)应当适合你的需求。

选择Standard Configuration(标准配置)选项,则 MySQL Configuration Wizard(配置向导)⾃动设置所有配置选项,但不包括服务选项和安全选项。

Standard Configuration(标准配置)设置选项可能与安装MySQL的系统不兼容。

如果系统上已经安装了MySQL和你想要配置的安装,建议选择详细配置。

这⾥本⼈选择的是Detailed Configuration ,想更好的完成个性化定制。

7、这⾥是配置MySQL的 MySQL服务器类型,可以选择3种服务器类型,选择哪种服务器将影响到MySQL Configuration Wizard(配置向导)对内存、硬盘和过程或使⽤的决策。

mysql5.5安装步骤

mysql5.5安装步骤

MySQL数据库的安装一共分为两个部分:数据库的安装和数据库的配置。

一MySQL数据库的安装:1、双击下载的MySQL安装文件,如图所示:2、弹出MySQL5.5安装向导对话框,单击Next按钮,如图所示:3、打开End-User License Agreement对话框,选中I accept the terms in the License Agreement复选框,单击Next按钮,如图所示:4、打开Choose Setup Type对话框,在其中列出了3中安装类型,分别是Typical、Custom 和Complete。

如果选择Typical或Complete这两种安装方式,将进入确认对话框,确认选择并开始安装。

如果选择Custom,将进入Custom(自定义)对话框。

在这里选择Custom,单击Custom按钮,如图所示:其中3种安装类型的含义如下:Typical:安装MySQL服务器,MySQL命令行客户端和命令行使用程序,命令行客户端和实用程序包括mysqldump、myisamchk和其他几个工具来帮助管理MySQL服务器。

Complete:安装软件包内包含的所有组件。

完全安装软件包包括的组件有嵌入式服务器库、基准套件、支持脚本和文档。

Custom:安装允许完全控制想要安装的软件包和安装路径。

5、打开Custom Setup对话框,所有可用组件列入Custom Setup对话框左侧的树状视图内,未安装的组件用红色图标表示,已经安装的组件有灰色图标,如图所示:6、默认情况下,选择全部安装,要想更改组件,单击该组件的图标并从下拉列表中选择新的选项,并设置安装路径,单击Next按钮,如图所示:其中四个选项的意思分别是:Will be installed on local had drive:表示安装这个附加组件到本地硬盘。

Entire feature will be installed on local hard driver:表示将这个组件特性及其子组件到本地硬盘。

linux mysql5

linux mysql5

linux mysql5.5 安装教程Linux MySQL 5.5安装教程MySQL是一款常用的关系型数据库管理系统,它的安装对于Linux系统来说非常重要。

本教程将指导您在Linux系统上安装MySQL 5.5,下面是具体的步骤:第一步:更新系统在安装任何软件之前,我们首先要确保系统是最新的。

使用以下命令更新系统软件包:sudo apt-get update这将获取并安装最新的软件包信息。

第二步:安装MySQL服务器接下来,我们将安装MySQL服务器。

使用以下命令执行安装:sudo apt-get install mysql-server-5.5这将安装MySQL 5.5版本的服务器。

在安装过程中,系统会要求您创建root用户的密码,请确保您设置一个强密码并记住它,因为这是您日后访问MySQL服务器的凭证。

第三步:检查MySQL服务器的状态安装完成后,我们可以使用下面的命令检查MySQL服务的状态:sudo service mysql status该命令将显示MySQL服务器是否正在运行。

第四步:登录MySQL安装完成后,我们可以使用以下命令登录到MySQL服务器:mysql -u root -p命令将提示您输入root用户的密码,输入密码后按下回车键即可登录到MySQL服务器。

第五步:测试MySQL接下来,我们可以使用以下命令测试MySQL服务器是否正常工作:SHOW DATABASES;该命令将显示MySQL服务器中的所有数据库。

第六步:配置MySQL如果您需要更改MySQL的一些基本设置,如端口号或数据目录等,您可以编辑MySQL的配置文件。

配置文件的位置可能因操作系统的不同而有所不同。

使用以下命令打开MySQL配置文件:sudo nano /etc/mysql/f您可以在此文件中更改各种MySQL服务器的设置。

第七步:常用MySQL命令以下是一些常用的MySQL命令:- 创建新的数据库:CREATE DATABASE database_name;- 显示数据库列表:SHOW DATABASES;- 选择数据库:USE database_name;- 显示表格列表:SHOW TABLES;- 显示表格结构:DESCRIBE table_name;- 导入SQL文件:source /path/to/sql/file.sql;这些命令将帮助您在MySQL服务器上进行常见的数据库操作。

  1. 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
  2. 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
  3. 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。

MySql5.5安装详细说明打开MySql5.5安装文件开始:
点击Next
打上勾,再点击Next
点击Custom,说明如下:Typical(典型安装)
Installs the most common program features.Recommended for most users.
意思是:安装最常用的程序功能。

建议大多数用户使用。

Custom(自定义安装)
Allows uers to choose which program features will be installed and where they will be installed.Recommended for advanced users.
意思是:允许用户选择安装的程序功能和安装的位置,建议高级用户使用。

Complete(完全安装)
All program features will be installed.Requires the most disk space.
意思是:将安装所有的程序功能,需要最多的磁盘空间。

这里就要详细说明一下:
点一下Developer Components左边的+按钮,会看到带的图标,这代表这里的内容不会被安装到本地硬盘上。

带有图标的都是默认安装到本地硬盘上的。

Developer Components(开发者部分):
用左键单击向下的小箭头选择Entire feature will be installed on local hard
drive。

意思是:即此部分,以及下属子部分内容全部安装在本地硬盘上。

MySQL Server(mysql服务器):照上面的做。

Client Programs(mysql客户端程序) :照上面的做。

Documentation(文档) :照上面的做。

Server data files(服务器数据文件):照上面的做。

Debug Symbols(调试符号):照上面的做。

这样操作,以保证安装所有文件,如果是图标的就不用去管它,操作完再点击Next。

点击Install
会弹出这个窗口,在这个窗口上点击Next
点击Next
打上勾,意思是启动MySQL实例配置向导
再点击Finish
点击Next
点第一个“详细配置”,再点击Next
选择第一个“开发人员计算机,或者说是开发商机”
再点击Next
点击第一个“多功能数据库”
再点击Next
这是关于InnoDB表空间设置的,不用管它,直接点Next
选择第三个,意思是:同时联机或者是并发连接数,我这里选20.
再点击Next
不要管3306后面的小框框,这个是添加这个职位的防火墙异常。

直接点击Next
选择第三个,编码看你的情况选择。

我选择的是UTF-8。

如果你不知道怎么选择的话也和我一样选择UTF-8
打上dos的勾,意思是Windows的路径中包括Bin目录。

再点击Next
打上勾,意思是“启用从远程计算机的根访问权限”
输入用户名和密码,再点击Next
点击Execute
点击Finish
到了这里MySql5.5就安装就完成了。

相关文档
最新文档