Installation of MySQL environment under Window

Installation brief for MySQL environment under Window:

MySQL is the most popular relational database management system, and in Web applications MySQL is one of the best RDBMS (relational database Management system: relational databases Management systems) application software.
I chose it for several reasons:

1. Small size, fast speed
2. Free, source code open source, cross platform
3. Large user volume, easy to find solutions to problems

Download:

You can download the required version on their official website, note that some premium version is charged, but for most users, the free version is enough, recommended: MySQL Community Server 5.6, can download the free installation package, decompression after eliminating the installation program.

Installation:

1. After unpacking the zip package, go to the CMD command line tool under this directory D:\MySQL\mysql-5.6.40-winx64\bin (adjust it yourself according to your installation location)
2. Install MySQL Service, execute mysqld Install
3. Log in to MySQL, the first login by default is the root account, there is no password, so you can enter the direct carriage.
   D:\MySQL\mysql-5.6.40-winx64\bin > Mysql-u root-p
4. Query user password,mysql> select host,user,authentication_string from Mysql.user;
   The password is encrypted, cannot see the plaintext, this is a string of characters, but can see the user name
5. Set or modify user password,mysql> update mysql.user set Authentication_string=password ("123456") where user= "root";
   Root is the user name and can be changed according to the current user
6. To modify the root user name:
   mysql> use MySQL;
   mysql> Update user set user= ' xly ' where user= ' root ';
7. Quit MySQL, mysql> quit

Other:

1. Environment variables
2. Generate Data file, mysqld--initialize-insecure--user=mysql Generate Data directory in D:\MySQL\mysql-5.6.40-winx64 directory

Reference Links:

installation, configuration and use of MySQL download under Windows
Windows installation mysql-text

Installation of MySQL environment under Window