Windows7 64-bit under configuration Mysql64-bit free installation version

Windows 7 64-bit under configure MYSQL64-bit free install version
Article Category: Database
1. Download Http://pan.baidu.com/s/1jGf5nUI
2, extract to D:\MySQL (path of their own designation) folder do not take Chinese, it is best to change to MySQL
3. Change the My-default.ini into My.ini configuration file under D:\MySQL and change the contents to the following:

Configuration file starts *********************# MySQLServerInstance Configuration file#----------------------------------------------------------------------# Generated by The MySQLServerInstance Configuration wizard### Installation instructions#------------------------------------------------------- ---------------# # # CLIENT section#----------------------------------------------------------------------# # The Following options would be read by MySQL client applications.# Note This only client applications shipped by MySQL is Guar anteed# toRead this section.IfWant your own MySQL client program to# Honor These values, you need toSpecify it as anoptionDuring the# MySQL client library initialization.#[client]port=3306[MySQL]default-character-Set=gbk#SERVERsection#----------------------------------------------------------------------# # The following options would be read By the MySQLServer. Make sure that# you have installed theServerCorrectly (see above) so it reads this# file.#[mysqld]# the TCP/IP Port the MySQLServerWould listen onport=3306#Path toinstallation directory. All paths is usually resolved relative toThis.basedir="D:\MySQL"#Path toThe database rootdatadir="D:\MySQL\Data"[Winmysqladmin]Server="D:\MySQL\bin\mysqld.exe"# thedefaultCharacterSetThat'll be used when aNewSchemaorTable is# Created andNo characterSet  isDefineddefault-character-Set=gbk# thedefaultStorage engine that'll be used when createNewTables whendefault-storage-engine=innodb#SetThe SQL mode toStrictsql-mode="Strict_trans_tables,no_auto_create_user,no_engine_substitution"# The maximum amount of concurrent sessions the MySQLServerwill# Allow. One of these connections'll be reserved forA user with# SUPER Privileges toAllow the administrator toLogin evenifthe# connection limit has been reached.max_connections= -# Query Cache isUsed toCacheSELECTResults andLater return them# without actual executing the same query once again. Have the query# cache enabled may resultinchSignificant speed improvements,ifYour# has a lot of identical queries andRarely changing tables. See the#"Qcache_lowmem_prunes"Status variable toCheckifThe current value# isHigh Enough forYour load.# Note:inch  CaseYour tables change very oftenor ifYour queries are# textually different every TimeThe query cache may resultincha# slowdown instead of a performance improvement.query_cache_size=0# The number of open tables forAll threads. Increasing this value# increases the number of the file descriptors which mysqld requires.# Therefore you have toMake sure to SetThe amount of open files# allowed toAt least4096 inchThe variable"Open-files-limit" inch# section [mysqld_safe]table_cache= the# Maximum Size forInternal (inch-memory) temporary tables.IfA table# grows larger than this value, it isAutomatically converted todisk# based table This limitation is  forA single table. There can many# of them.tmp_table_size= -m# How many threads we should keepinchA cache forReuse. When a client# disconnects, the client' s threads is put in the cache if there aren ' t# More than Thread_cache_size threads from before. This greatly reduces# the amount of thread creations neededifYou had a lot ofNew# connections. (Normally this doesn' t give a notable performance# improvementifYou have a good thread implementation.) Thread_cache_size=8#*** MyISAM specific options# The maximum size of the temporary file MySQL isAllowed toUse while# recreating the index (during REPAIR, ALTER TABLEorLOAD DATA infile.#IfThe file-size would is bigger than this, the index would be created# through the key cache (which isSlower). myisam_max_sort_file_size= -g#IfThe temporary file used forFast index creation would is bigger# than using the key cache by the amount specified here, ThenPrefer the# key cache method. This isMainly used toForce long character Keysinch# Large Tables toUse the slower key cache method toCreate the Index.myisam_sort_buffer_size= them# Size of the Key Buffer, used toCache Index Blocks forMyISAM tables.# Do  not SetIt larger than -% of your available memory, as some memory# isAlso required by the OS toCache rows. EvenifYou' re not using# MyISAM tables, you should stillSetIt to 8- -M as it would also be# used forInternal temporary disk tables.key_buffer_size= +m# Size of the buffer used forDoing full table scans of MyISAM tables.# allocated per thread,ifA full scan isNeeded.read_buffer_size= -Kread_rnd_buffer_size= thek# this buffer isAllocated when MySQL needs toRebuild the Indexinch# REPAIR, Optimze, ALTER table statements as well asinchLOAD DATA infile# to anEmptyTable. It isAllocated per thread so is careful with# large Settings.sort_buffer_size= thek#*** INNODB Specific Options ***innodb_data_home_dir="E:\Program files\mysql\data\innodb\"# Use thisoption ifYou have a MySQLServer  withInnoDB Support enabled# Do  notPlan toUse it. This would save memory andDiskSpace# andSpeed up some things. #skip-innodb# Additional Memory Pool isUsed by InnoDB toStore metadata# information.IfInnoDB requires more memory forThis purpose it will# start toAllocate it from the OS. As this isFast enough onmost# recent operating systems, you normally Do  notNeed toChange this# value. SHOW INNODB STATUS would display the current amount used.innodb_additional_mem_pool_size=2m#If Set  to 1, InnoDB'll flush (fsync) The transaction logs tothe# disk at eachCommit, which offers full ACID behavior.IfYou are# willing toCompromise this safety, andYou is running small# transactions, maySetThis to 0 or 2  toReduce disk I/O tothe# logs. Value0means that theLog  isOnly written toTheLogFile and# theLogFile flushed toDisk approximately once perSecond. Value2# means theLog  isWritten toTheLogFile at eachCommit, but theLog# file isOnly flushed toDisk approximately once perSecond. innodb_flush_log_at_trx_commit=1# The size of the buffer InnoDB uses forBufferingLogData. As soon as# it isFull, InnoDB would have toFlush it toDisk. As it isflushed# once perSecondAnyway, it does notMake sense toHas it very large# (even withLong transactions). innodb_log_buffer_size=1m# InnoDB, unlike MyISAM, uses a buffer pool toCache both indexes and# row data. The bigger YouSetThis is the less disk I/O isNeeded to# Access DatainchTables. onA dedicated databaseServerMaySetthis# parameter up to  the% of the machine physical memory size. Do  not Setit# too large, though, because competition of the physical memory may# cause paginginchThe operating system. Note that on  +Bit systems you# might be limited to 2-3.5G of User level memory per process, so Do  not#SetIt too high.innodb_buffer_pool_size= them# Size of each LogFileinchALogGroup. You shouldSetThe combined size# ofLogFiles toAbout -%- -% of your buffer pool size toavoid# unneeded buffer pool flush activity on LogFile overwrite. however,# Note that a larger logfile size would increase the TimeNeeded forthe# Recovery process.innodb_log_file_size= them# number of threads allowed inside the InnoDB kernel. The optimal value# depends highly onThe application, hardware as well as the os# Scheduler properties. A too high value could lead toThread thrashing.innodb_thread_concurrency=8Configuration file End *********************

The focus is on the following configuration, where the directory name of DataDir must be data and must be data in the MySQL directory. 1067 errors have been made in the previous directory.

#Pathto installation directory.Allto this.basedir="d:\MySQL"#Pathto the database rootdatadir="d:\MySQL\Data"

4. Add the following to the Windows environment variable (easy to execute command line command)
New Mysql_home= "D:\MySQL",
Add%mysql_home%\bin to Path
5. Register MySQL as a Windows system service. The specific action is to execute the following command on the command line:
after switching to the bin directory, the execution Mysqld–install must switch to the bin directory

C:\WINDOWS\SYSTEM32>CD/

C:>d:

D:\CD Mysql\bin

D:\CD Mysql\bin>mysqld–install
Service successfully installed.

D:\CD mysql\bin>net Start Mysql
The MySQL service is starting.
The MySQL service has started successfully.
"'

6. After the 5th step succeeds, start MySQL at the command line
C:>net start MySQL
7. Change the root password to 111111
With Mysqladmin

mysqladmin-u root Password "111111"

If Root has already set a password, use the following method

mysqladmin-u root password Oldpass "Newpass"

Windows7 64-bit under configuration Mysql64-bit free installation version