How To launch MySQL as Docker Container

1. Comman Line

docker run --detach 

--env MYSQL_ROOT_PASSWORD=dummypassword 

// to connect to the database from our application
--env MYSQL_USER=social-media-user 
--env MYSQL_PASSWORD=dummypassword 

--env MYSQL_DATABASE=social-media-database 
--name mysql 
--publish 3306:3306 
mysql:8-oracle

2. application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/social-media-database
spring.datasource.username=social-media-user
spring.datasource.password=dummypassword

spring.jpa.hibernate.ddl-auto=update
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQLDialect

3. gradle dependecy

implementation 'com.mysql:mysql-connector-j:8.0.33'

4. MySQL Shell

\connect social-media-user@localhost:3306
\use social-media-database
\sql select * from user_datails