How to use MySQL free installation version

1. Download and unzip the MySQL free install version to the custom directory

2. Add Environment variables

Variable name: mysql_home

Variable Value: D:\Program files\mysql-5.6.11-winx64

This is the custom unzip directory for MySQL.

Add%mysql_home%\bin in Path again

****************************************************

Or:

Variable name: Path

Variable Value: D:\Program files\mysql-5.6.11-winx64\bin

3. Registering Windows System Services

1) from the console into the bin directory under the MySQL decompression directory:

2) Enter the Service installation command:

Mysqld Install MySQL--defaults-file= "D:\Program Files\mysql-5.6.11-winx64\my.ini"

If Install/remove of the Service denied! appear

Because window 7 is more restrictive than vista.
Go to C:\Window\System32 Find CMD.EXE right-click to select as Administrator, and then go to the corresponding directory to execute the command, everything is OK.

Another: The Remove service command is: mysqld remove

Note: The My.ini file is customized and is created by itself (can be placed in a sibling directory based on the extracted My-default.ini file definition)

Attached: My.ini configuration

# 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. [Client] #password = Your_passwordport = 3306socket =/tmp/mysql.sockdefault-character-set=utf8[mysqld]port = 3306basedir= "D:/mysql-5.6.32-winx64" # Set the installation directory for MySQL datadir= "D:/mysql-5.6.32-winx64/data" # Set the data storage directory for the MySQL database, Must be data, or//xxx/datadefault-storage-engine=innodb# will be used when creating a new table the default storage engine socket =/tmp/mysql.socksql-mode= "Strict_trans _tables,no_auto_create_user,no_engine_substitution "# SQL mode for strict mode #default-character-set=utf-8# set MySQL server's character set # Character-set-server=utf-8 # The character set used by the service side defaults to the 8-bit encoded latin1 character Set max_connections=100 # The maximum number of concurrent connections supported by the MySQL server (number of users). However, one of the connections is always reserved for administrators to log on with super privileges, even if the number of connections reaches the maximum limit. If the settings are too small and the user is more, the "Too many connections" error will often occur. Query_cache_size=0 # Query cache size, used to cache select query results. If there are many select queries that return the same query results, and rarely changes the table, can be set query_cache_size greater than 0, can greatly improve query efficiency. If the table data changes frequently, do not use this, it will backfire #table_cache=256 # This parameter is called Table_open_cache in the version after 5.1.3, to set the number of table cache. Because each client connection accesses at least one table, the value of this parameter is related to Max_connections. When a connection accesses a table, MySQL checks the number of tables that are currently cached. If the table is already open in the cache, direct access to the tables in the cache speeds up the query, and if the table is not cached, the current table is added to the cache and queried. Before performing a cache operation, Table_cache is used to limit the maximum number of cache tables: If the currently cached table does not reach Table_cache, the new table will be added, and if this value is reached, MySQL will release the previous cache based on rules such as the last query time of the cache table, query rate, and so on. tmp_table_size=34m # The maximum size allowed for each temporary table in memory. If the temporary table size exceeds this value, the temporary table is automatically converted to a disk Based table. Thread_cache_size=8 # The maximum number of threads cached. When the client connection is broken, the thread that handles the client task is put back into the cache if the total number of client connections is less than that value. In high concurrency situations, if the value is set too small, many threads are created frequently, the overhead of thread creation becomes larger, and the query efficiency decreases. In general, if there is good multithreading on the application side, this parameter will not improve the performance much. #------------------------------MyISAM related parameters begin------------------------------------------------Myisam_max_sort_ file_size=100g# MySQL rebuild index allows the use of a maximum size of temporary files myisam_sort_buffer_size=68mkey_buffer_size=54m # Key buffer size, The index block used to cache the MyISAM table. Determines the speed of database index processing (especially index reads) read_buffer_size=64k # is used for MyISAM table full table scan when using the buffer size. Allocated for each thread (provided a full table scan is performed). When you sort a query, MySQL will first scan through the buffer to avoid disk searches, improve query speed, and if you need to sort large amounts of data, you can adjust the value appropriately. However, MySQL will issue this buffer space for each client connection, so you should set this value as appropriately as possible to avoid excessive memory overhead. read_rnd_buffer_size=256ksort_buffer_size=256k # Connection-level parameters (configured for each thread), 500 threads will consume 500*256k sort_buffer_size. #------------------------------MyISAM Related parameters End------------------------------------------------#----------------- --------------# InnoDB related parameters begin---------------------------------------innodb_additional_mem_pool_size=3m# InnoDB the size of the memory pool used to store metadata information, typically without modifying Innodb_flush_log_at_trx_commit =1# transaction-related parameters, if the value is 1, The InnoDB writes the transaction log to disk (disk IO consumption is large) at each commit, which guarantees full acid performance. If set to 0, the transaction log writes to the memory log and the memory log writes to the disk at a frequency of 1 times per second. If set to 2, the transaction log is written to memory log at each commit, but the memory log is written to disk 1 times per second. innodb_log_buffer_size=2m# InnoDB log data buffer size, if the buffer is full, the log data in the buffer will be written to disk (flush). Since the disk is usually written at least 1 seconds, there is no need to set it too large, even for a long transaction. innodb_buffer_pool_size=105m# InnoDB uses a buffer pool to cache indexes and row data. The larger the value is set, the less disk IO. This value is typically set to 80% of physical memory. innodb_log_file_size=53m# the size of each INNODB transaction log. 25% to 100%innodb_thread_concurrency=9 # InnoDB core Maximum number of concurrent threads, typically set to Innodb_buffer_pool_size

4. Start the MySQL service

Method One:

The Start service command is: net start MySQL

Another: Stop service command for: net stop MySQL

Method Two:

Open the Administration Tools service and locate the MySQL service.

Start the service by right-clicking to start or by tapping on the left-hand boot directly.

How to use MySQL free installation version