MySQL Zip installation

The mysql_5.6.24 version is stored in the computer. There was some trouble during the installation and a record.

At the beginning of the official website downloaded the latest 5.7. Version 12, has not been able to start the MySQL service. The reason is that the computer was originally installed in 5.6.24 version, there was a conflict should. 5.7.12 version of the decompression after no data directory, very egg pain, also did not find a solution, online said to start executing a command. Later, go to the official website to read the instructions. This is not looking at for the moment.

Then just install the 5.6.24 version, but also the installation is not successful, here should pay attention to the configuration file writing format.

MySQL reads the My.ini file from the installation directory by default.

Take a look at this blog post: http://www.cnblogs.com/freeton/p/4264829.html

The simplest way to configure this is to change the root directory and the data file directory.

# for advice The change settings see# http://dev.mysql.com/doc/refman/5.6/en/ server-configuration-defaults.html# * * * does not EDIT the this FILE.  It's a template which'll be copied to the# * * * default location during install, and would be replaced if you# * * * Upgrade To a newer version of MySQL. [mysqld]# Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of all RAM for dedicated server, else 10%. Innodb_buffer_pool_size = 128m# Remove Leading # to turn in a very important data integrity option:logging# changes to th e binary log between backups.# log_bin# These is commonly set, remove the # and set as required. #mysql根目录 Basedir = "C:\Pr   Ogram Files\mysql-5.6.22-win32 "#数据文件存放目录 datadir =" C:\Program files\mysql-5.6.22-win32\data "# port = .....  Port, default 3306# server_id = ..... Unique identifier of the service instance # Remove leading # To set options mainly useful for reporting servers.# the server defaults is faster for Transa Ctions and Fast selects.# Adjust Sizes as needed, experiment to find the optimal values.# join_buffer_size = 128m# sort_buffer_size = 2m# read_rnd_buffer_ Size = 2M sql_mode=no_engine_substitution,strict_trans_tables #服务端的编码方式character-set-server=utf8[client] #客户端编码方式, It is best to save the server with the same loose-default-character-set = utf8[winmysqladmin] Servers = "C:\Program files\mysql-5.6.22-win32\bin\ Mysqld.exe "

　　

MySQL Zip installation