Problems and solutions of error 08001 when linking to MySQL in IDEA and no table display after successful connection

Error: Connection to blog0@localhost failed. [08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up.

insert image description here

Solution: Add ?serverTimezone=UTC to the end of the URL

insert image description here

After the connection is successful, the database does not display the table

insert image description here

Solved by setting:

insert image description here

Scheme selects the currently used database

This is the end of this article about the problem and solution of IDEA linking to MySQL and reporting error 08001 and not displaying the table after successful connection. For more related IDEA linking to MySQL and not displaying the table content, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope you will support 123WORDPRESS.COM in the future!

You may also be interested in:

The problem of Chinese garbled characters appearing when connecting to MySQL database in Idea
Detailed steps for Java to connect to MySQL 8.0 JDBC (IDEA version)
Create a SpringBoot+MyBatis+MySql project in IDEA to implement dynamic login and registration functions
Detailed steps to use IDEA to configure Tomcat and connect to MySQL database (JDBC)
Solution to IDEA not being able to connect to MySQL port number occupation
Bugs encountered when using mybatis-generator with mysql8.0.3 in IDEA
Detailed explanation of how to connect to MySQL database using Java in IntelliJ IDEA
JDBC-idea import mysql to connect java jar package (mac)
Problems and solutions for IDEA connecting to MySQL
Tutorial on how to connect and use MySQL 8.0 in IDEA's Maven project
IDEA uses properties configuration file to connect to MySQL database
Detailed diagram of IntelliJ IDEA connecting to MySQL database
Solution to the error when connecting to MySQL database in IDEA

<<: Linux deb package decompression, modification and other operation methods code examples

>>: Usage of Vue filters and timestamp conversion issues