I recently upgraded to Ubuntu 18.04 and started having this issue, I can connect to my local mysql server via the terminal fine using
mysql -u root -p
however when I try to use mysql workbench it just gets stuck on connecting and wb.log displays the following:
11:39:07 [INF][ WBContext UI]: Initializing workbench context UI with these values:
base dir: /usr/share/mysql-workbench
plugin path: /usr/lib/mysql-workbench/plugins
struct path: /usr/share/mysql-workbench/grt
module path: /usr/lib/mysql-workbench/modules
library path: /usr/share/mysql-workbench/libraries
user data dir: /home/<REPLACED USERNAME>/.mysql/workbench
open at start:
open type:
run at startup:
run type:
Force SW rendering: No
Force OpenGL: No
quit when done: No
11:39:07 [INF][ WBContext]: WbContext::init
11:39:08 [INF][ WBA]: Looking for extension modules for WBA...
11:39:08 [INF][ WBA]: 0 extension modules found
11:39:08 [WRN][ grt]: /usr/share/mysql-workbench/modules/data/mysql_rdbms_info.xml:1401: link 'om.mysql.rdbms.mysql.driver.native_sshtun' <object > key=owner could not be resolved
11:39:08 [WRN][ grt]: /home/<REPLACED USERNAME>/.mysql/workbench/connections.xml:27: link '6d8ecd74-acad-11e8-9c35-408d5cdbf11f' <object GrtObject> key=owner could not be resolved
11:39:08 [INF][ WBContext]: System info:
MySQL Workbench Community (GPL) for Linux/Unix version 8.0.12 CE build 13312926 (64 bit)
Configuration Directory: /home/<REPLACED USERNAME>/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.15.10
OS: Ubuntu 18.04 x86_64
CPU: 8x Intel(R) Xeon(R) CPU E3-1230 v5 @ 3.40GHz (3700.971MHz) - 15.62GiB RAM
No video adapter info available
Distribution: Ubuntu 18.04.1 LTS
Fips mode enabled: no
11:39:08 [INF][ WQE backend]: Found auto-save workspace /home/<REPLACED USERNAME>/.mysql/workbench/sql_workspaces/local-1.autosave
11:39:09 [INF][SQL Editor Form]: Opened connection 'local' to (Ubuntu) version 5.7.23-0ubuntu0.18.04.1
When I edit the connection in mysql workbench and click "Test Connection" i get the following result:
So here is a few things I have tried so far:
- Completely purged mysql-server, mysql-commons, mysql-client etc.
- Reinstalled mysql-server
- Logged into the mysql server via terminal and modified the plugin for root user to use mysql_native_password
- Tried creating a new custom user and tried logging into that, once again it works via terminal but not via MySQL Workbench.
- Ran apt update, apt upgrade
- Downloaded latest MySQL Workbench from their website and installed that.
It wouldn't even allow me to connect to a fresh db install after mysql server reinstall.
These are the versions I'm working on: MYSQL Server version: 5.7.23-0ubuntu0.18.04.1 (Ubuntu) Linux Kernel Version: 4.15.0-33-generic Distribution: Ubuntu 18.04.1 LTS MYSQL Client Version: mysql Ver 14.14 Distrib 5.7.23, for Linux (x86_64) using EditLine wrapper