idea连接MySQL测试报错与 Unknown initial character set index '255' received from server.

太过爱你忘了你带给我的痛 2021-12-16 06:43 411阅读 0赞

点击右边栏的database  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dvb19ob21l_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dvb19ob21l_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dvb19ob21l_size_16_color_FFFFFF_t_70 2]  
这里有一点需要注意，就是连接不上，报了个错，错误显示 *Connection to stu@localhost failed. \[08001\] Could not create connection to database server. Attempted reconnect 3 times. Giving up.*  
![在这里插入图片描述][20190705115330926.]  
错误的原因是MySQL的驱动不一致，MySQL用的是 5.+ 的，而在idea中下载的是 8.+ 的，这里只需按照下面选择5.1即可  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dvb19ob21l_size_16_color_FFFFFF_t_70 3]  
再次测试连接，ok  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dvb19ob21l_size_16_color_FFFFFF_t_70 4]  
代码方式：

import java.sql.Statement;
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    
    public class Jdbc { 
    
        Connection connection = null;
        Statement statement = null;
    
        public void test(){ 
            try{ 
                String driver = "com.mysql.jdbc.Driver";
                String URL = "jdbc:mysql://localhost:3306/stu?useSSL=false";
                String USER = "用户名";
                String PASSWORD = "密码";
                Class.forName(driver);
                connection = DriverManager.getConnection(URL,USER,PASSWORD);
                System.out.println("连接成功");
                statement = (Statement) connection.createStatement();
            }catch (Exception e){ 
                e.printStackTrace();
            }
            try { 
                String sSQL = "SELECT * FROM student";//查询数据库表信息
                ResultSet resultSet = statement.executeQuery(sSQL);
                while (resultSet.next()){ 
                    System.out.println(resultSet.getString(2));
                }
            }catch(Exception e){ 
                System.out.println(e.getMessage());
    
            }
    
        }
    
        public static void main(String[] args) { 
            Jdbc jdbc = new Jdbc();
            jdbc.test();
        }
    }

运行这个代码的时候有时候会报错，报错信息为：

java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    	at com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionImpl.java:1785)
    	at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3496)
    	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2385)
    	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)
    	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
    	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
    	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    	at java.sql.DriverManager.getConnection(DriverManager.java:664)
    	at java.sql.DriverManager.getConnection(DriverManager.java:247)
    	at Jdbc.test(Jdbc.java:18)
    	at Jdbc.main(Jdbc.java:39)
    null

从而拿到的结果是null值，主要错误是这个：  
`Initial client character set can be forced via the 'characterEncoding' property.`  
没有设置这个characterEncoding属性，只要在下面这句话的后面加个\*\*&characterEncoding=utf8\*\*就可以了

String URL = "jdbc:mysql://localhost:3306/stu?useSSL=false&characterEncoding=utf8";

测试：  
![在这里插入图片描述][20190706111524132.]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dvb19ob21l_size_16_color_FFFFFF_t_70]: /images/20211214/63821be10b3a4b33abe768aaeea0dba2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dvb19ob21l_size_16_color_FFFFFF_t_70 1]: /images/20211214/c737ca65d81c421d85331d8db650a7e5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dvb19ob21l_size_16_color_FFFFFF_t_70 2]: /images/20211214/54a8b3571fb74d46881bf8932f80e43f.png
[20190705115330926.]: /images/20211214/c4920cd93e8c4ebb9769d36ef79400fc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dvb19ob21l_size_16_color_FFFFFF_t_70 3]: /images/20211214/b07488376dc94059afaa7b8e3e770a02.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dvb19ob21l_size_16_color_FFFFFF_t_70 4]: /images/20211214/672a7f60659b4330af565aae0aed738b.png
[20190706111524132.]: /images/20211214/bef2a786ba024ae6b8f6345267889e0a.png

idea连接MySQL测试报错与 Unknown initial character set index '255' received from server.

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 MySQL报错Slave: received end packet from server, apparent master shutdown

相关 Error updating database. Cause: java.sql.SQLException: Unknown initial character set index ‘255‘ re

相关 idea连接MySQL报错Server returns invalid timezone

相关 mysql连接池报错:The last packet successfully received from the server was XXXXX milliseconds ago

相关 Unknown initial character set index ‘255‘ received from server. Initial client character set can be

相关【MySQL】连接MySQL时，字符无法识别(java.sql.SQLException: Unknown character set index for field '224' received )

相关 Mysql 连接报错:Unknown initial character set index '255' received from server. Initial ...

相关 idea连接MySQL测试报错与 Unknown initial character set index '255' received from server.

相关 java.sql.SQLException: Unknown initial character set index '45' received from server.

相关 JDBC连接MySQL：Unknown initial character set index '255' received from server.Initial client character