jdbc连接本地mysql数据库Caused by: java.net.UnknownHostException: mysql

秒速五厘米 2023-09-25 20:43 88阅读 0赞

# 问题： #

Caused by: java.net.UnknownHostException: mysql

## 原因 ##

Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

## 代码 ##

Caused by: java.net.UnknownHostException: mysql
    	at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
    	at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:929)
    	at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1324)
    	at java.net.InetAddress.getAllByName0(InetAddress.java:1277)
    	at java.net.InetAddress.getAllByName(InetAddress.java:1193)
    	at java.net.InetAddress.getAllByName(InetAddress.java:1127)
    	at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:132)
    	at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
    	... 110 common frames omitted
    
    org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
    ### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
    
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    ### The error may exist in cn/itcast/hotel/mapper/HotelMapper.java (best guess)
    ### The error may involve cn.itcast.hotel.mapper.HotelMapper.selectById
    ### The error occurred while executing a query
    ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
    
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

# 解决方法： #

datasource:
        url: jdbc:mysql://127.0.01:3306/elasticsearch?useSSL=false
        username: root
        password: *****
        driver-class-name: com.mysql.cj.jdbc.Driver

数据库配置文件修改：  
`jdbc:mysql://mysql:3306/`改成 `jdbc:mysql://127.0.0.1:3306/`