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:
- Small size, fast speed
- Free, source code open source, cross platform
- 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:
- 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)
- Install MySQL Service, execute mysqld Install
- 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
- 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
- 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
- To modify the root user name:
mysql> use MySQL;
mysql> Update user set user= ' xly ' where user= ' root ';
- Quit MySQL, mysql> quit
Other:
- Environment variables
- 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