Decompression version of MySQL installation instructions

One, copy My.ini to MySQL extracted directory

Example: E:\MySQL

Second, modify the My.ini line 39th to 40th

Basedir = "E:\\mysql"

DataDir = "E:\\mysql\\data"

Third, check whether the MySQL service is installed on the computer

My computer-with services and apps-service, check for MySQL

Four, Start menu--Attach---command prompt--right-click, run as Administrator

Wu, cd/d E:\MySQL\bin

Mysqld-install MySQL--defaults-file= "E:\MySQL\my.ini"

Prompt to install MySQL service successfully

Six, My computer---services and apps--services, right-click MySQL, tap Start.

If the boot fails, delete the corresponding file in the E:\MySQL\data directory

Ib_logfile0

Ib_logfile1

. err

. pid

32-bit MySQL:my.ini

1 # Example MySQL config file for small systems.2 #3# This was for a system with little memory (<= 64M) where MySQL is only used4 # from time to time and it's important that the mysqld daemon5 # doesn ' t use much resources.6 #7 # MySQL programs look for option files in a set of8 # Locations which depend on the deployment platform.9 # can copy this option file to one of thoseTen # locations. For information on these locations, see: One # http://dev.mysql.com/doc/mysql/en/option-files.html A # - # In the This file, you can use the all long options, which a program supports. - # If you want to know which options a program supports, run the program the # with the "--help" option. -  - # The following options would be passed to all MySQL clients - [Client] + #password= Your_password - Port= 3306 + Socket=/tmp/mysql.sock A Default-character-set= UTF8 at  - # Here follows entries for some specific programs -  - # the MySQL server - [Mysqld] - Port= 3306 in Socket=/tmp/mysql.sock - skip-external-locking to key_buffer_size= 16K + Max_allowed_packet= 1M - Table_open_cache= 4 the sort_buffer_size= 64K * read_buffer_size= 256K $ read_rnd_buffer_size= 256KPanax Notoginseng Net_buffer_length= 2K - Thread_stack= 128K the Basedir= "E:\\mysql" + DataDir= "E:\\mysql\\data" A Character-set-server= UTF8 the  + # Don ' t listen on a TCP/IP port at all. This can is a security enhancement, - # If all processes this need to connect to mysqld run on the same host. $ # All interaction with Mysqld must is made via Unix sockets or named pipes. $ # Note that the using this option without enabling named Pipes on Windows - # (using the "enable-named-pipe" option) would render mysqld useless! - #  the #skip-networking - Server-id= 1Wuyi  the # Uncomment the following if you want to log updates - #log-bin=mysql-bin Wu  - # Binary Logging format-mixed recommended About #binlog_format=mixed $  - # causes updates to Non-transactional engines using statement format to be - # Written directly to binary log. Before using this option make sure that - # There is no dependencies between transactional and non-transactional A # Tables such as in the statement INSERT to T_myisam SELECT * from + # T_innodb, otherwise, slaves may diverge from the master. the #binlog_direct_non_transactional_updates=true -  $ # Uncomment the following if you is using InnoDB tables the #innodb_data_home_dir= C:\\mysql\\data\ the #innodb_data_file_path= Ibdata1:10m:autoextend the #innodb_log_group_home_dir= C:\\mysql\\data\ the # you can set: _buffer_pool_size up to 50-80% - # of RAM but beware of setting memory usage too high in #innodb_buffer_pool_size= 16M the #innodb_additional_mem_pool_size= 2M the # Set: _log_file_size to% of buffer pool size About #innodb_log_file_size= 5M the #innodb_log_buffer_size= 8M the #innodb_flush_log_at_trx_commit= 1 the #innodb_lock_wait_timeout= +  - [mysqldump] the QuickBayi Max_allowed_packet= 16M the  the [MySQL] - No-auto-rehash - # Remove The next comment character if you is not a familiar with SQL the #safe-updates the  the [Myisamchk] the key_buffer_size= 8M - sort_buffer_size= 8M the  the [Mysqlhotcopy] the Interactive-timeout

64-bit MySQL:my.ini

1 # for advice the change settings2 # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html3 # * * * Don't EDIT this FILE. It ' s a template which 'll be copied to the4 # * * * default location during install, and would be replaced if you5 # * * * * Upgrade to a newer version of MySQL.6 7 [Mysqld]8 9 # Remove Leading # and set to the amount of RAM for the most important dataTen # Cache in MySQL. Start at 70% of all RAM for dedicated server, else 10%. One # innodb_buffer_pool_size = 128M A  - # Remove Leading # to turn on a very important data integrity Option:logging - # Changes to the binary log between backups. the # Log_bin -  - # These is commonly set, remove the # and set as required. - # basedir = ... + # DataDir = ... - # port = ... .. + # server_id = ... A Basedir = d:/mysql-5.6.20-x64 at DataDir = D:/mysql-5.6.20-x64/data - Port = 3306 - #server_id = ... .. -  - character-set-server = UTF8 - default-storage-engine = INNODB in  - # Remove Leading # To set options mainly useful for reporting servers. to # The server defaults is faster for transactions and fast selects. + # Adjust sizes as needed, experiment to find the optimal values. - # join_buffer_size = 128M the # sort_buffer_size = 2M * # read_rnd_buffer_size = 2M $ Panax Notoginseng Sql_mode=no_engine_substitution,strict_trans_tables -  the [Client] +Default-character-set=utf8

Decompression version of MySQL installation instructions