Mysql-5.1.37-NOINSTALL version configuration installation on Windows systems

Mysql-5.1.37-NOINSTALL version configuration installation on Windows:

1. Download The mysql-noinstall-5.1.37-win32.zip package, decompress the package, and move the extracted file directory to the location where you want to install MySQL. I chose to place it on disk D: \ mysql-5.1.37-win32.

2. For convenience, set the bin folder path (such as: D: \ mysql-5.1.37-win32 \ bin) of MySQL in the path of the system variable of the Windows environment variable so that we can run the tool in MySQLProgramCan be very convenient, do not need to run in the D: \ mysql-5.1.37-win32 \ bin directory.

3. Open the mysql-5.1.37-win32, we can find that there are 5. ini suffix configuration files in the directory
My-small.ini: for small system configuration files, MySQL running memory less than or equal to 64 m;
My-middle.ini: For medium system configuration files, MySQL runs between 32 m-64 m;
My-large.ini: used for large system configuration file, MySQL runs 512 m, the system mainly runs MySQL database;
My-huge.ini: for giant system configuration file, MySQL runs between 1 GB and 2 GB, The system mainly runs MySQL database;
My-innodb-heavy-4G.ini: 4g RAM, only supports transactions, few connections, a large number of queries.
We only need to select one of them to change it to the my. ini file, which is the default configuration file of the MySQL database.

4. Open the my. ini file and we need to configure it:
Add and save the following content:
[Mysqld]
# Setting the MySQL installation directory
Basedir = D: \ mysql-5.1.37-win32
# Set the data storage directory of the MySQL database
Datadir = D: \ mysql-5.1.37-win32 \ data

Note: Data in the database storage directory can be moved according to your preferences, but you must move the data and all the content in it and reset it in the datadir of the my. ini file.

5. After preparing, select the MySQL database service type and take MySQL 5.1.20 as the forks.
MySQL 5.1.20 and earlier versions provide the following services:
Mysqld-NT: supports named pipelines;
Mysqld: The named MPs queue is not supported;
Mysql-Debug: it is the same as mysqld-nt, but runs in the debugging status and automatically detects memory allocation.

In MySQL 5.1.21 and the latest version, the service is as follows:
Mysqld: supports named pipelines;
Mysql-Debug: Same as mysqld, but runs in the debugging status, and automatically detects memory allocation.
You can see that mysqld-NT does not exist in the new version.
Here I choose to start the mysqld service.

6. Next, let's start to start the service. In command line mode of CMD, enter mysqld -- console, and add the parameter -- console to display the service startup information on the Character interface, if this parameter is not added, all error messages will be written to already. the file ending with err is in the data directory.
If the startup is successful, the following information is displayed:
Mysqld: Ready for connections version: '5. 1.37 'socket: ''port: 3306

7. After the service is started successfully, the MySQL installation is successful, and the installation of MySQL can come to an end.

8. After MySQL is installed, decide whether to enable MySQL automatically as a Windows system service, start it manually as a Windows system service, or start it manually using the command line.
As a Windows system service, automatic start: mysqld -- install
As a Windows system service, manual start: mysqld -- install-manual
You can also specify the default configuration file, and MySQL service name, such as:
mysqld -- install MySQL -- defaults-file = c: \ my-opts.ini
uninstall MySQL System Service: mysqld -- remove
use the command line to manually start: mysqld