Install MySQL on Windows on a non-installation package basis

The following information is derived from: http://dev.mysql.com/doc/refman/5.6/en/windows-create-option-file.html The whole process is divided into the following steps:  one, Extract The archive to the desired install directory, this is nothing to say, such as decompression to:e:\soft\mysql-5.6.26-win32  II, Create an option File for some long-used startup parameters (such as the storage engine options, such as memory consumption settings, etc.), you can consider putting him in a configuration file, this document. MySQL will search for this option configuration file in the following order: a) c:\b) MySQL installation directory, such as the above: E:\soft\mysql-5.6.26-win32c) and Windows directory; c:\windows  configuration file name can be My.ini and my.cnf, first find My.ini and then find MY.CNF, although you can use two simultaneously, but generally recommended only one. It is recommended to put a My.ini file in the MySQL directory, the contents of the file is as follows, if you want to put data in other paths, you need to put the contents of the data directory in the installation directory over the entire copy, and modify the following path: [mysqld]# set Basedir to Your installation pathbasedir=e:/soft/mysql-5.6.26-win32# set DataDir to the location of your data directorydatadir=e:/so ft/mysql-5.6.26-win32/data  three, Choose a MySQL server type in two ways, the general use of mysqld can be. binarydescriptionmysqldoptimized binary with Named-pipe supportmysqld-debuglike mysqld, but compiled with full debugging And a  Four, start the MySQL server run the following command at the command line: E:\soft\mysql-5.6.26-win32\bin\mysqld.exe--console The following prompt appears, indicating that the boot was successful, --co is added here.Nsole startup parameters, in order to be able to see the various debugging information on the console, if you do not want to see, then remove the option, the program will be written to the log file. If you find that mysqld is not started, you can use the Mysqld.exe--standalone--debug option, and then you can find the error message in C:\mysqld.trace.   If you want to stop the service, you can execute the following command;

E:\soft\mysql-5.6.26-win32\bin\mysqladmin -u root shutdown

V. Start the MySQL server as Windows service stop the MYSQLD server and run to the bin directory of MySQL before running the following command: Mysqld.exe--install If you find that you have insufficient permissions, Run cmd as an administrator, execute the command again, and the result is as follows: Then go to the Windows service interface to manually start the MySQL service. Customizing the PATH for MySQL Tools in order to make it easier to use MySQL commands in the console, you can add the MySQL bin directory to the environment variable path.

Install MySQL on Windows with a non-installation package