Detailed explanation of DBeaver connecting to MySQL version 8 and above and solving possible problems

Database MySQL version 8.0.18

Download a DBeaver.exe

Download address: https://dbeaver.io/download/

Click New->Database Connection->Next

Select database--》Next--》Finish

Double-clicking the newly created file will prompt the following error

The reason is that the database time zone configuration is incorrect

Open cmd and run as administrator

Log in to the database--"Enter show variables like '%time_zone%';

SYSTEM is the default US time. Solution: enter set global time_zone='+8:00';

Although it still displays SYSTEM, exit the database and restart it

Then return to DBeaver and double-click the connection again

The red box indicates a successful connection

This is the end of this article about connecting DBeaver to MySQL version 8 and above and solving possible problems. For more information about connecting DBeaver to MySQL 8, 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!