Erro "Could not open JPA EntityManager for transaction" após configuração do Transaction

Oiee... Após a configuração do TransactionManager apresenta o erro status 500 "Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection" e não cria a tabela no banco....alguem consegue me dar um help?

import javax.persistence.EntityManagerFactory;

import org.springframework.context.annotation.Bean;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.orm.jpa.JpaTransactionManager;
import org.springframework.orm.jpa.JpaVendorAdapter;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;
import org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@EnableTransactionManagement
public class JPAConfiguration {


    @Bean
    public LocalContainerEntityManagerFactoryBean entityManagerFactory()
    {
     LocalContainerEntityManagerFactoryBean factoryBean = new LocalContainerEntityManagerFactoryBean();
     JpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
     factoryBean.setJpaVendorAdapter(vendorAdapter);

      DriverManagerDataSource dataSource = new DriverManagerDataSource();
      dataSource.setUsername("root");
      dataSource.setPassword("");
      dataSource.setUrl("jdbc:mysql://localhost:3306/musify");
      dataSource.setDriverClassName("com.mysql.jdbc.Driver");      
      factoryBean.setDataSource(dataSource);

      Properties properties  = new Properties();
      properties.setProperty("hibernate.dialect","org.hibernate.dialect.MySQL5Dialect");
      properties.setProperty("hibernate.show_sql", "true");
      properties.setProperty("hibernate.hbm2ddl.auto","create");

      factoryBean.setJpaProperties(properties );
      factoryBean.setPackagesToScan("org.musify.models");

      return factoryBean;


}
    @Bean
    public JpaTransactionManager transactionManager (EntityManagerFactory emf)
    {
        return new JpaTransactionManager(emf);
    }
}