mvn flyway:migrate 执行报错

[onedaywen]

看readme文档

3. 运行数据库脚本，创建本地数据库

   mvn flyway:migrate

   如果需要使用 MySQL 数据库，运行脚本前修改两处配置

   # src/main/resources/application.properties 
   spring.datasource.url=jdbc:h2:~/community
   spring.datasource.username=sa
   spring.datasource.password=123

   
   # pom.xml
   <properties>
   <db.url>jdbc:h2:~/community</db.url>
   <db.user>sa</db.user>
   <db.password>123</db.password>
   </properties>

然后我改成了，
# src/main/resources/application.properties 
spring.datasource.url=jdbc:mysql://localhost:3306/community?useUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

# pom.xml
<properties>
    <db.url>jdbc:mysql://localhost:3306/community?useUnicode=true&characterEncoding=utf8</db.url>
    <db.user>root</db.user>
    <db.password>123456</db.password>
</properties>

执行

mvn flyway:migrate

报错：

Failed to execute goal org.flywaydb:flyway-maven-plugin:5.2.4:migrate (default-cli) on project community: org.flywaydb.core.internal.exception.FlywaySqlException: 
[ERROR] Unable to obtain connection from database (jdbc:mysql://localhost:3306/community) for user 'root': Communications link failure

在sh窗口，通过 mysql -u root -p 输入123456是可以连接成功的

[dialectice]

同问