MySQL Zip version installation configuration

Download the zip version of MySQL from the official website of Windows edition

Unzip to a directory

Open the MySQL folder and create a new My.ini file

Enter the following content:

#绑定IPv4和3306端口
Bind-address = 0.0.0.0
Port = 3306

# set up the MySQL installation directory
basedir=d:/mysql-5.6.13

# Set up a storage directory for MySQL database data
Datadir=d:/mysql-5.6.13/data

# Maximum number of connections allowed
max_connections=200

In general, this configuration is OK, but it is also possible with the MySQL version of the upgrade some of the differences, specifically refer to the My-default.ini file

Of course, if you want to use the more advanced features of MySQL, you can also refer to the official website of the manual to operate.

The next step is to install MySQL into the Windows service so that the next service starts

Open a command prompt, switch directories to the bin directory in the MySQL installation directory, run the Mysql-install command, and if the return information prompts the service to install successfully, the installation succeeds.

Configure MySQL Password

By default, the root is a blank password, so run d:\mysql-5.6.13\bin\mysql-uroot-p directly, prompt for the password, the direct return to the root can enter the management of MySQL.
Root no password is too scary, let's set a password for it. Run d:\mysql-5.6.13\bin\mysqladmin-uroot-p password < new password >, replace < new password > with your custom password, then press ENTER. At this point will be prompted to enter a password, in fact, refers to the original password, the original password because it is empty, so here again enter to complete the setup

MySQL Zip version installation configuration