Detailed graphic tutorial on mysql 5.7.14 installation and configuration method_MySQL

The installation process of mysql 5.7.14 is recorded as follows, I hope it will be helpful to everyone.

1. Download MySQL 5.7.14

Download link: http://dev.mysql.com/downloads/installer/

The specific download process is shown in the picture below:

2. MySQL 5.7 installation

Better installation instructions found online:

Article 1: http://www.bitsCN.com/article/84152.htm

Article 2: http://www.bitsCN.com/article/90275.htm (configuration in folder format)

3. Summary of MySQL 5.7 problems

1. Solve the problem of crash when opening MySQL 5.7 Command line Client (as shown in the picture below)

Case introduction:

I am learning ssh recently and need to use a database, so I downloaded a MySQL Server from the official website. After installation, when I opened the command line, it always crashed and I was very anxious, so I collected some solutions online and wrote them here. Share it with everyone.

1). Check out some parameters executed by MySQL Command Line Client by default. Method: Start->All Programs->MySQL->MySQL Server 5.7->MySQL 5.7 Command Line Client, right-click properties.

2). View the contents of the target file:

Copy the file content as follows:

"D:MySQLMySQL Server 5.7binmysql.exe" "--defaults-file=D:MySQLMySQL Server 5.7my.ini" "-uroot" "-p"

3). Go to the directory D:MySQLMySQL Server 5.7my.ini to check if there is a my.ini file. I find that there is no file, there is only one my-default.ini.

4). Copy my-default.ini, rename it to my.ini, problem solved! ! !

2. Note that during this change process, the originally configured root user password may be deleted (change the root user password)

Reference link: http://www.bitsCN.com/article/84146.htm (written in more detail)

Note: The above picture content can be realized by my own operation, and the relevant reference links are more comprehensive.

The above is the entire content of this article. I hope it will be helpful to everyone’s study and I hope you will support me a lot.