How does Springboot connect to a database on a remote server?

This article mainly explains "how Springboot connects to the database on the remote server". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how Springboot connects to the database on the remote server".

How a Springboot project connects to a database on a remote server

Without a database server, I installed mysql on my own server. I want to open the mysql of the database to external users, as follows.

1. Open port 3306 on your own server. Of course, you can also limit the source of ip and restrict which ip can be accessed.

2. Create a role for opening up in the remote database. You can open a database and grant different permissions according to different demand scenarios. Below I created a user Akio that allows users from any ip to log in. Of course, you can also create more types and scenarios of users according to the syntax.

3. Grant permissions. ALL PRIVILEGES grants all permissions. *. * means all databases. 'Akio'@'%' is the user and its host.

GRANT ALL PRIVILEGES ON *. * to 'Akio'@'%'

Flush privileges; flushes to memory and takes effect immediately

4. Try to log in

5. Then you can use it in your project

# mysql connect messagespring.datasource.driver-class-name=com.mysql.cj.jdbc.Driverspring.datasource.url=jdbc:mysql:// server address: 3306 / database name? characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=truespring.datasource.username=Akiospring.datasource.password=

Note: please pay attention to the authorization of the user

Thank you for reading, the above is the content of "how Springboot connects to the database on the remote server". After the study of this article, I believe you have a deeper understanding of how Springboot connects to the database on the remote server, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!