MYSQL5.6 database ZIP installation and precautions for use in

First, mount the resource: http://download.softagency.net/mysql/downloads /.

Find MYSQL5.6. For the two versions, check the system and set them to 64-bit: http://download.softagency.net/mysql/downloads/mysql-5.6/mysql-5.6.16-winx64.zip. Decompress the package and store it in the desired place. The path is D: \ SDT \ mysql5.6.16 _ x64, as shown in:

After decompression, the files in the directory may be a little different from those in the image. There are no files my. ini and my_default_old.ini, and there is a my_default.ini file. This is what we will do next. copy and paste the my_default.ini file in the current folder, and change the other file name to my. ini. The other file can be replaced or replaced with me.

The configuration file of my. ini needs to be changed to the following two places:

Basedir = D :\\ SDT \\ mysql5.6.16 _ x64
Datadir = D :\\ SDT \\ mysql5.6.16 _ x64 \ data

Port = 3306
# Custom host ID Identifier for master-slave or multi-server identification. It is an int type.
Server_id = 1

Or

Basedir = D:/SDT/mysql5.6.16 _ x64
Datadir = D:/SDT/mysql5.6.16 _ x64/data

Port = 3306
# Custom host ID Identifier for master-slave or multi-server identification. It is an int type.
Server_id = 1

Note that, Any one of the rows, other can be modified or not, my complete configuration is as follows:

# For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html# * ** Do not edit this file. it's a template which will be copied to the # *** default location during install, and will 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 total RAM for dedicated server, else 10%. innodb_buffer_pool_size = 128 M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set, remove the # and set as required. basedir = D :\\ SDT \ mysql5.6.16 _ x64datadir = D :\\ SDT \ mysql5.6.16 _ x64 \ dataport = 3306 # custom host ID Identifier, it is used for identification between master and slave servers. It is an int type server_id = 1character_set_server = utf8 # maximum number of connections max_connections = 100 # Default TABLE Type of the create table statement. If you do not specify the type, use the downstream type default-storage-engine = InnoDB # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. join_buffer_size = 128Msort_buffer_size = 2Mread_rnd_buffer_size = 2 M SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

Next, add the database root directory path to the environment variable "path", for example, "D: \ SDT \ mysql5.6.16 _ x64 \ bin ".

Open the cmd console. The Windows 7 system must be opened as an administrator., Enter "D: \ SDT \ mysql5.6.16 _ x64 \ bin \ mysqld.exe -- install mysql5", must be in the full path

Mysql-u root-p ", because the database does not have a password by default, you can press ENTER twice and then enter"update user set password=PASSWORD(‘’) where User='root';"123456" indicates the password to be updated. You can change the password according to the actual situation.

 

Bytes.

Another online installation version for the web version: