Problems and Solutions in the process of mysql5.7 installation
1. Problem description: mysql 5.7 installation in the initialization database phase error as follows:
Solution: Install Visual C++ 2013 library link: www.microsoft.com/zh-cn/download/confirmation.aspx? id=40784
2. Problem description: After installation, only this machine can connect, other machines cannot use IP to connect to mysql, error Access denied for user 'root'@'localhost' (using password:YES)
Solution: Open the mysql 5.7 command line client that comes with installing mysql, as follows:
Note: where % means allow all IP, bvt means database connection password;
digression: this article records the problems encountered by the author in the installation process, for reference only, I hope to help you!
Wish you happy every day!
