MySQL Compression pack installation method

From the official website https://dev.mysql.com/downloads/mysql/Download Mysql-5.6.31-winx64.zip, unzip it, the next installation is to install the MySQL database by command. (The version of P.S. 5.7 will be problematic, preferably a 5.6 version)

(1) Mysql-5.6.31-winx64.zip unzip to E:\JavaWebDeveloper\ file, open command prompt to run as Administrator, CD to E:\JavaWebDeveloper\ Mysql-5.6.31-winx64\bin under

The command is: cd/d E:\JavaWebDeveloper\mysql-5.6.31-winx64\bin

(2) Installing MySQL

Mysqld install, the MySQL installation succeeds after running the command.

(3) Start the MySQL service.

net start MySQL will start the MySQL service. It is worth noting that MySQL is installed with the command under the default service name MySQL under Windows system, the default password is empty.

(4) Configuring environment variables

1) Create a new mysql_home variable and configure the value to: E:\JavaWebDeveloper\mysql-5.6.31-winx64

Mysql_home:e:\javawebdeveloper\mysql-5.6.31-winx64

2) Edit the path system variable and add%mysql_home%\bin to the PATH variable. Configure the PATH environment variable, or do not create a new mysql_home variable, but directly configure the bin under the MySQL installation directory under the PATH variable,

Path:%mysql_home%\bin

(5) Enter MySQL

Mysql-u root-p, the password defaults to empty. displaying "mysql>" means entering MySQL and can perform various operations on the database with T-SQL statements. Database can also be managed with graphical management tools

This method does not install MySQL Workbench after successful installation, and it needs to download and install itself.

MySQL Compression pack installation method