Search code examples
mysqltomcatdatabase-migrationmysql-connectormysql-5.7

Why migrating from MySQL 5.5 to 5.7 is refusing to connect?

I am trying to upgrade from MySQL 5.5(port:3306) to 5.7(port:3308) and following changes i have made.

  1. Install new MySQL service for 5.7.
  2. Replace MySQL-connector-java from v.3.1.11-bin.jar to v5.1.9.jar
  3. Change port in database.properties from 3306 to 3308.

But when i try to run application from local tomcat, it is throwing below exception.

java.net.ConnectException: Connection refused: connect
    java.net.DualStackPlainSocketImpl.connect0(Native Method)
    java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
    java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
    java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
    java.net.AbstractPlainSocketImpl.connect(Unknown Source)

Don't know what i am missing in this migration? Also: If I run both MySQL services, instead of 3308, application is trying to connect to older service 3306!!!

Solution

  • Use old drivers instead of new. This will solve the issue. Also make sure that database is having all tables and minimum required data available in new database.