mysql数据库常见问题及解决办法

（一）安装方面和调整默认数据位置

问题一：安装时候问题

1、安装之前，需要先执行安装vcredist，分别32位或64位。先试试new不行再试试old

2、执行安装“mysql-installer-community-5.7.20.msi”选择"server only"即可，后面都"next"

3、MySQL server5.7版出现server failed

报错日志：

1. 1: Action 14:02:10: INSTALL.
2. 1: 1: MySQL Server 5.7 2: {EC09D203-422B-4C9F-B623-230EF57EE709}
3. 1: Action 14:02:10: FindRelatedProducts. Searching for related applications
4. 1: Action 14:02:10: AppSearch. Searching for installed applications
5. 1: Action 14:02:10: LaunchConditions. Evaluating launch conditions
6. 1: This application requires Visual Studio 2013 Redistributable. Please install the Redistributable then run this installer again.
7. 1