mysql怎么可视化连接_IDEA连接MySQL可视化工具连接操作

IDEA连接MySQL可视化工具连接操作入下所示&＃xff1a;

填写完成后&＃xff0c;点击测试连接&＃xff0c;连接成功如图所示点击OK即可

报告错误(如图所示)&＃xff1a;[08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up. java.net.ConnectException: Connection refused: connect.

解决方案&＃xff1a;搜索框中输出CMD&＃xff0c;以管理员身份运行&＃xff0c;在命令提示符中输入&＃xff1a;net start mysql。成功启动后方可连接。

报告错误(如图所示)&＃xff1a;Server returns invalid timezone. Go to &＃39;Advanced&＃39; tab and set &＃39;serverTimezone&＃39; property manually.

解决方案&＃xff1a;win&＃43;R&＃xff0c;键入cmd打开命令提示符&＃xff0c;登录mysql&＃xff0c;键入 set global time_zone &＃61; &＃39;&＃43;8:00&＃39;;方可连接成功