Solution to the problem that Java cannot connect to MySQL 8.0

Solution to the problem that Java cannot connect to MySQL 8.0

This article shares a collection of Java problems that cannot connect to MySQL 8.0 for your reference. The specific content is as follows

Question 1: Client does not support authentication protocol requested by Server;…

Question 2: Unknown initial character set index '255' received from server…

Question 3: MySQL 8.0 connection necessary URL statement

Problem 4: Duplicate method calls

Run Question 1 :

Solution: (note the semicolon in the 3 sentences, wy123456 is the password of my database)

Question 2:

Solution: (delete duplicate packages)

The import is also deleted, leaving only the correct one:

Then重啟eclipse! The environment will be updated~

Key: MySQL 8.0 needs to add this sentence : ?useSSL=false&serverTimezone=UTC

public static String dbUrl="jdbc:mysql://localhost:3306/websql?useSSL=false&serverTimezone=UTC"; 

Running results:

Question 4:

Solution: (The second connection name must be different)

Running results:

Attach the connection DbUtil class:

package com.cungudafa;

import java.sql.Connection;
import java.sql.DriverManager;

public class DbUtil {
  public static String dbUrl="jdbc:mysql://localhost:3306/websql?useSSL=false&serverTimezone=UTC";
  public static String dbUserName="root";
  public static String dbPassword="wy123456";
  public static String jdbcName="com.mysql.jdbc.Driver";

  public static Connection getCon() throws Exception {
   Class.forName(jdbcName);
   Connection con=DriverManager.getConnection(dbUrl,dbUserName,dbPassword);
    return con;
  }
  public static void closeCon(Connection con) {
    try {
      if (con != null) {
        con.close();
      }
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
}

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:
  • Java connects to mysql database code example program
  • Detailed explanation of the underlying encapsulation of Java connection to MySQL
  • Detailed explanation of how to connect Java to Mysql version 8.0.18
  • Java connects to MySQL database to implement single and batch insertion
  • Implementing a student management system based on MySQL in Java
  • Java+MySQL to implement student information management system source code
  • Detailed explanation of dynamically generating Mysql stored procedures in Java Spring

<<:  How to expand the disk partition for centos system

>>:  vue_drf implements SMS verification code

Recommend

How to install MySQL database on Ubuntu

Ubuntu is a free and open source desktop PC opera...

MySQL 5.7.33 installation process detailed illustration

Table of contents Installation package download I...

uniapp Sample code for implementing global sharing of WeChat mini-programs

Table of contents Create a global shared content ...

How to implement simple data monitoring with JS

Table of contents Overview first step Step 2 Why ...

How to get the maximum or minimum value of a row in sql

Original data and target data Implement SQL state...

Solutions to the problem of table nesting and border merging

【question】 When the outer table and the inner tab...

Implementation of MySQL GRANT user authorization

Authorization is to grant certain permissions to ...

Use and understanding of MySQL triggers

Table of contents 1. What is a trigger? 2. Create...

Detailed explanation of the relationship between Linux and GNU systems

Table of contents What is the Linux system that w...

Using cursor loop to read temporary table in Mysql stored procedure

cursor A cursor is a method used to view or proce...

Detailed explanation and examples of database account password encryption

Detailed explanation and examples of database acc...

Select web page drop-down list and div layer covering problem

Questions about select elements in HTML have been...