Installation of MySQL encountered several pits

1. Download the compressed version of MySQL, configuration is too complex to abandon

2. Download the latest version of the MySQL installation package 5.8.X, installation success, all the way next, after the installation successfully found not see the custom installation path, see the MySQL installation completed path is in C drive, uninstall

3. Find out how to customize the installation path, install MySQL again to find the default port 3306 is occupied, restart the

4. Continue to install MySQL, found that Windows services name MYSQL80 has been used, delete the registry, various deletions, and then restart, still not, and finally changed the Windows services name to mysql81 installation succeeded

5. Install NAVICAT Premium, connection database error, report password is not correct, mom a chicken, check the reason is mysql8.0 version after the problem (do not forget, toss half a day do not want to drop version)

6. In the cmd command line, login mysql password configuration information (using the encoding what), a pass configuration, and then restart the MySQL service, shit, incredibly in the command line also can not open MySQL, input mysql-u root-p, and then input password, direct report password error

7. Look again Niang, Degree Niang said change my.ini information, login ignore password, look very good look, try, shit, or not, so far has spent 3 hours

8. Uninstall MySQL 8, download a more stable version of mysql5.7, all the way next installation succeeded. Navicat Premium also connected successfully ( the whole process took only 5 minutes )

Conclusion: Do not install MYSQL8. x version, look for mysql5.7

Attach a custom path location:

Installation of MySQL encountered several pits