0

My app (gs-spring-boot.zip) is unable to connect to the locally running MySQL 8.0 database after carrying out the following configurations as described in various tutorials online.

Please find the errors in the attached log file named cf_spring_boot_log.txt

Please find a screenshot of the MySQL account with same credentials as configured below.

Local MySQL account

PS C:\WINDOWS\system32> cf login -a https://api.dev.cfdev.sh --skip-ssl-validation -u admin -p admin

PS E:\> cf cups mysql80-db -p '{\"username\": \"pcf\", \"password\": \"pcfpassword\", \"name\": \"world\", \"hostname\": \"127.0.0.1\", \"port\": 3306, \"uri\": \"mysql://pcf:pcfpassword@127.0.0.1:3306/world\", \"jdbcUrl\": \"jdbc:mysql://127.0.0.1:3306/world?user=pcf&password=pcfpassword\"}'

PS E:\> cf push pcf-people-mgmt -p C:\Users\ranadeep-sharma\IdeaProjects\gs-spring-boot\complete\target\pcf-people-mgmt-1.0-SNAPSHOT.jar

PS E:\> cf bind-service pcf-people-mgmt mysql80-db

PS E:\> cf restage pcf-people-mgmt

I have spent weeks with no success. Please let me know what I am missing in my configuration.

Ranadeep Sharma
  • 21
  • 5

1 Answers1

0

Problem resolved, after using correct IP Address.

Ranadeep Sharma
  • 21
  • 5