New install doesn't work, missing tables.

[Kelly Correll]

Brand new server, brand new install.  First time installing and configuring myself.  I am using mysql backend on a separate server.  Ran the installer, went through setup wizard to the point where it has me input an admin user with its password/email.  Then, it breaks.  

Cause

com.atlassian.core.exception.InfrastructureException: Failed to create default group: confluence-users
    at com.atlassian.confluence.setup.actions.SetupAdministrator.createDefaultGroups(SetupAdministrator.java:89)

caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
    at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:230)

caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)

caused by: java.sql.SQLSyntaxErrorException: Table 'confluence.cwd_application_attribute' doesn't exist
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)

Stack Trace:[hide]


com.atlassian.core.exception.InfrastructureException: Failed to create default group: confluence-users at 

Please help.  This is the most PITA install I think I've ever done (except ruby redmine). 

[repi]

Correct driver used?

https://confluence.atlassian.com/doc/database-jdbc-drivers-171742.html

[Gabor Nagy _Midori_]

Had the same problem with MySQL 5.7. Downgrading Connector/J to 5.1.49 solved the issue. Thank you very much!

[Kelly Correll]

Forgot to mention that this is an ec2 instance (ubuntu).