Trying to connect the MySQL server with Spring boot application but failed. Can anyone tell what is wrong with the below code. Tried with the SQLYog to establish the connection with the IP server but failed.
**Application.properties:**
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://43.231.78.77:3306/crm?createDatabaseIfNotExist=true
spring.datasource.username=uzzal
spring.datasource.password=F1f0t3ch!@#!@#
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update
spring.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
db.query.native.enabled=true
spring.servlet.multipart.enabled=true
spring.servlet.multipart.max-file-size=10MB
spring.servlet.multipart.max-request-size=10MB
spring.console.path=/h2-ui
enter image description here
Mehedi Hasan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
0
Got this error on Windows because my mysqld.exe wasn’t running.
Ran “C:Program FilesMySQLMySQL Server 5.5binmysqld” –install from the command line to add it to my services, ran services.msc (start -> run), found the MySQL service and started it.
Didn’t have to worry about it from there on out.
LVΔIR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.