win764位系统怎么安装mysql

1、找到安装包，点击安装包 安装

2、选择Install MySql Product进入安装

3、同意协议，点击Next 进入下一步

4、跳过更新，继续安装，选择next，需要更新的可以更新

5、设置安装路径和数据库存储路径，以及安装的选择，这里选择FUll ，看个人意愿选择安装不同的安装类型

6、查看安装要求，满足所有要求，点击下一步，不满足的需要先安装，否则安装不成功！

7、下面进入正式的安装过程，每个过程等待几十秒钟，然后根据图片上的教程下一步就行了

8、设置端口号和服务器的类型，个人用户建议选择默认的

9、下一步，进入设置默认的密码和新建用户页面，密码不得少于4个字符

10、安装到最好的过程了，按照图片中指示来，直到安装完成

11、安装完成后，在开始菜单中找到MYSQL打开运行即可

步骤

1

打开MYSQL安装程序：‘Setup.exe’：

2

点击'Next'：

安装类型有三种：

1. Typiccal(默认)

2. Complete(完全)

3. Custom(用户自定义)

选择第三种 Custom(用户自定义)

3

点击'Next':

1. 选择开发者部分如图所示

2. 修改MYSQL安装目录到D盘下

4

单击‘Next’

5

点击‘Install’ 安装：

6

询问是否注册一个MySQL.com的账号，这个我们不要注册：

选择Skip Sign-Up

点击'next' 跳过

7

软件安装完成，并启动MySQL配置向导

点击‘Finish’

8

向导页面，单击'Next'

9

我们选择手动配置：

单击'Next'

10

选择 开发测试点击'Next'

11

选择第二种 服务器类型

单击'Next'

12

对InnoDB Tablespace 进行配置：

默认单击‘Next’

13

选择连接数：

选择手动设置：15个左右

单击‘Next’

14

设置MySQL端口号：

默认选择

单击'Next'

15

设置编码格式：

这个特性重要，我们要在数据库存储中文，就一定选择中文字符集

必须要选择‘utf8’

16

选择是否将MYSQL安装为windows服务

默认选择

单击'Next'

17

为默认用户root(超级管理员权限)设置一个密码：

设置密码为：root

点击'Next'

18

确认配置：

单击'Execute'

19

设置完毕，安装完成

1、 MySQL Community Server 5.6.10

2、解压到d:\MySQL.（路径自己指定）

3、在d:\MySQL下新建my.ini配置文件，内容如下：

*****************配置文件开始*********************

# MySQL Server Instance Configuration File

#----------------------------------------------------------------------

# Generated by the MySQL Server Instance ConfigurationWizard

#

#

# Installation Instructions

#----------------------------------------------------------------------

#

#

# CLIENT SECTION

#----------------------------------------------------------------------

#

# The following options will be read by MySQL clientapplications.

# Note that only client applications shipped by MySQLare guaranteed

# to read this section. If you want your own MySQLclient program to

# honor these values, you need to specify it as anoption during the

# MySQL client library initialization.

#

[client]

port=3306

[mysql]

default-character-set=gbk

# SERVER SECTION

#----------------------------------------------------------------------

#

# The following options will be read by the MySQL Server.Make sure that

# you have installed the server correctly (see above)so it reads this

# file.

#

[mysqld]

# The TCP/IP Port the MySQL Server will listen on

port=3306

#Path to installation directory. All paths are usuallyresolved relative to this.

basedir="d:\MySQL\"

#Path to the database root

datadir="d:\MySQL\Data"

[WinMySQLadmin]

Server="d:\MySQL\bin\mysqld.exe"

# The default character set that will be used when anew schema or table is

# created and no character set is defined

default-character-set=gbk

# The default storage engine that will be used whencreate new tables when

default-storage-engine=INNODB

# Set the SQL mode to strict

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

# The maximum amount of concurrent sessions the MySQLserver will

# allow. One of these connections will be reserved fora user with

# SUPER privileges to allow the administrator to logineven if the

# connection limit has been reached.

max_connections=100

# Query cache is used to cache SELECT results andlater return them

# without actual executing the same query once again.Having the query

# cache enabled may result in significant speedimprovements, if your

# have a lot of identical queries and rarely changingtables. See the

# "Qcache_lowmem_prunes" status variable tocheck if the current value

# is high enough for your load.

# Note: In case your tables change very often or ifyour queries are

# textually different every time, the query cache mayresult in a

# slowdown instead of a performance improvement.

query_cache_size=0

# The number of open tables for all threads.Increasing this value

# increases the number of file descriptors that mysqldrequires.

# Therefore you have to make sure to set the amount ofopen files

# allowed to at least 4096 in the variable"open-files-limit" in

# section [mysqld_safe]

table_cache=256

# Maximum size for internal (in-memory) temporarytables. If a table

# grows larger than this value, it is automaticallyconverted to disk

# based table This limitation is for a single table.There can be many

# of them.

tmp_table_size=26M

# How many threads we should keep in a cache forreuse. When a client

# disconnects, the client's threads are put in thecache if there aren't

# more than thread_cache_size threads frombefore. This greatly reduces

# the amount of thread creations needed if you have alot of new

# connections. (Normally this doesn't give a notableperformance

# improvement if you have a good threadimplementation.)

thread_cache_size=8

#*** MyISAM Specific options

# The maximum size of the temporary file MySQL isallowed to use while

# recreating the index (during REPAIR, ALTER TABLE orLOAD DATA INFILE.

# If the file-size would be bigger than this, theindex will be created

# through the key cache (which is slower).

myisam_max_sort_file_size=100G

# If the temporary file used for fast index creationwould be bigger

# than using the key cache by the amount specifiedhere, then prefer the

# key cache method. This is mainly used to force long character keys in

# large tables to use the slower key cache method tocreate the index.

myisam_sort_buffer_size=52M

# Size of the Key Buffer, used to cache index blocksfor MyISAM tables.

# Do not set it larger than 30% of your available memory,as some memory

# is also required by the OS to cache rows. Even ifyou're not using

# MyISAM tables, you should still set it to 8-64M asit will also be

# used for internal temporary disk tables.

key_buffer_size=40M

# Size of the buffer used for doing full table scansof MyISAM tables.

# Allocated per thread, if a full scan is needed.

read_buffer_size=64K

read_rnd_buffer_size=256K

# This buffer is allocated when MySQL needs to rebuildthe index in

# REPAIR, OPTIMZE, ALTER table statements as well asin LOAD DATA INFILE

# into an empty table. It is allocated per thread sobe careful with

# large settings.

sort_buffer_size=256K

#*** INNODB Specific options ***

innodb_data_home_dir="d:\MySQL\Data\INNODB\"

# Use this option if you have a MySQL server withInnoDB support enabled

# but you do not plan to use it. This will save memoryand disk space

# and speed up some things.

#skip-innodb

# Additional memory pool that is used by InnoDB tostore metadata

# information. If InnoDB requires more memory for this purpose it will

# start to allocate it from the OS. As this is fast enough on most

# recent operating systems, you normally do not needto change this

# value. SHOW INNODB STATUS will display the currentamount used.

innodb_additional_mem_pool_size=2M

# If set to 1, InnoDB will flush (fsync) thetransaction logs to the

# disk at each commit, which offers full ACIDbehavior. If you are

# willing to compromise this safety, and you arerunning small

# transactions, you may set this to 0 or 2 to reduce diskI/O to the

# logs. Value 0 means that the log is only written tothe log file and

# the log file flushed to disk approximately once persecond. Value 2

# means the log is written to the log file at eachcommit, but the log

# file is only flushed to disk approximately once persecond.

innodb_flush_log_at_trx_commit=1

# The size of the buffer InnoDB uses for buffering logdata. As soon as

# it is full, InnoDB will have to flush it to disk. Asit is flushed

# once per second anyway, it does not make sense tohave it very large

# (even with long transactions).

innodb_log_buffer_size=1M

# InnoDB, unlike MyISAM, uses a buffer pool to cacheboth indexes and

# row data. The bigger you set this the less disk I/Ois needed to

# access data in tables. On a dedicated databaseserver you may set this

# parameter up to 80% of the machine physical memorysize. Do not set it

# too large, though, because competition of thephysical memory may

# cause paging in the operating system. Note that on 32bit systems you

# might be limited to 2-3.5G of user level memory perprocess, so do not

# set it too high.

innodb_buffer_pool_size=77M

# Size of each log file in a log group. You should setthe combined size

# of log files to about 25%-100% of your buffer poolsize to avoid

# unneeded buffer pool flush activity on log fileoverwrite. However,

# note that a larger logfile size will increase thetime needed for the

# recovery process.

innodb_log_file_size=39M

# Number of threads allowed inside the InnoDB kernel.The optimal value

# depends highly on the application, hardware as wellas the OS

# scheduler properties. A too high value may lead tothread thrashing.

innodb_thread_concurrency=8

*****************配置文件结束*********************

配置文件也放在了附件里，大家可以根据需要修改。

重点是以下配置，其中datadir的目录名称必须是data，并且好像必须是MySQL目录下的data.之前自己制定了其他目录，一直出现1067的错误。

#Path to installation directory. All paths are usuallyresolved relative to this.

basedir="d:\MySQL\"

#Path to the database root

datadir="d:\MySQL\Data"

4、在windows环境变量里加入以下内容（方便执行命令行命令）

新建MYSQL_HOME="d:\MySQL\"

在Path里加入%MYSQL_HOME%\bin

5、将mysql注册为windows系统服务。具体 *** 作是在命令行中执行以下命令：

mysqld install MySQL --defaults-file="d:\MySQL\my.ini"

移除服务为 mysqld remove

6、第5步成功后，在命令行启动mysql

c:>net start mysql

7、修改root的密码为62386997

方法一：

c:>mysql –uroot

mysql>showdatabases

mysql>use mysql

mysql>UPDATE user SET password=PASSWORD("62386997") WHEREuser='root'

mysql>FLUSH PRIVILEGES

mysql>QUIT

..

---