mysql win7 64位 安装

　　1、 MySQL Community Server 5.6.10

　　官方网站下载mysql-5.6.10-winx64.zip

　　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

比如你的mysql在d:\mysql\bin
1、点我的电脑，右键，属性，高级系统设置，环境变量，将PATH增加;d:\mysql\bin才行
2、进入当前路径
d:
cd mysql\bin
mysql -u root -p