MySQL Latest Version 5.7.12 installation tutorial (windows)

1. Download The ZIPArchive file from the official website: dev. mysql. comdownloadsmysql 2. decompress the downloaded compressed package to the place where you want to install 3. Configure the INI file to open the decompressed file, which contains a my-default.ini file. Now we want to create a new my, INI file, and then create a file with at least a package of content.

1. Download the Archive file URL from the official website: http://dev.mysql.com/downloads/mysql/ 2. Unzip the downloaded compressed package to the place where you want to install 3. Configure the INI file to open the decompressed file, which has a my-default.ini file. Now we want to create a new my, INI file, and then create a file with at least a package of content.

1. Download the ZIP Archive file from the official website

Web: http://dev.mysql.com/downloads/mysql/

Ii. Decompress

Decompress the downloaded package to the desired location

3. Configure the INI File

Open the decompressed file, which contains a my-default.ini file. Now we want to create a new my and ini file, and the content of the new file should at least include but not limited to the following content:

[Mysql]
# Set the default Character Set of the mysql client
Default-character-set = utf8
[Mysqld]
# Set port 3306
Port = 3306
# Set the installation directory of mysql
Basedir = E: \ Program Files (x86) \ mysql-5.7.12-winx64
# Set the directory for storing mysql database data
Datadir = E: \ Program Files (x86) \ mysql-5.7.12-winx64 \ data
# Maximum number of connections allowed
Max_connections = 200
# The default character set used by the server is the 8-bit latin1 character set.
Character-set-server = utf8
# The default storage engine used to create a new table
Default-storage-engine = INNODB

** Note that the latest MySQL version does not contain the data folder. You must create a new one.

Iv. installation environment

Run the command prompt (cmd) as an administrator to switch the directory to the binfile directory in your unzipped file, without switching to the image,

Enter mysqld install and press Enter.

Enter mysqld -- initialize-insecure -- user = mysql and press Enter.

Enter net start mysql to start the service

V. Start MySQL

Enter mysql-uroot-p. By default, there is no password. Press enter to enter.

Set the password and enter mysqladmin-uroot-p password.

To exit, enter exit. Shutting Down cmd will not exit the database.

6. Set Environment Variables

After MySQL can be opened successfully, it will be difficult to cd to the installation directory every time you open it. After configuring the environment variables, you can directly use mysql-uroot-p to enter the database.

Find the environment variable editing page (different systems can be opened in different ways, and search for environment variables in the lower left corner of win10), find the path, and edit it, just add the binfile path in the file to be decompressed.

Now you can open cmd and enter mysql-uroot-p to open MySQL.