How to connect Springboot to the database on the remote server

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

In the absence of a database server, I installed MySQL on my own server and wanted to open access to the database to external users . The specific settings are as follows:.

1. Open port 3306 on your own server. Of course, you can also restrict the source of IPs and restrict access to only those IPs.

#2. Create a role in the remote database for opening. With this role, you can open a database and grant different permissions according to different demand scenarios. I created a user called Akio and allowed users from any IP address to log in using that user. Of course, you can also create more types of users with more scenarios based on grammar.

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

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

flush privileges; is flushed into the memory and takes effect immediately

4. Try to log in

5. Then you can use it in your project

#mysql connect message
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://服务器地址:3306/数据库名称?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true
spring.datasource.username=Akio
spring.datasource.password=

Note: Please pay attention to the user’s authorization

The above is the detailed content of How to connect Springboot to the database on the remote server. For more information, please follow other related articles on the PHP Chinese website!