243
votes
Accepted
Cannot connect MySQL Workbench to MySQL server
You have installed MySQLWorkbench as a Snap package. You want to store the database password(s) in the Gnome Passwords & Keys facility.
However, a Snap package is sandboxed; it is not by default ...
- 27.3k
51
votes
Unable to connect via MySQL Workbench to localhost in Ubuntu 16.04 (passwordless root)
The issue is likely due to socket authentication being enabled for the root user by default when no password is set, during the upgrade to 16.04. This important caveat is documented in the 16.04 ...
- 611
45
votes
Accepted
Unable to connect via MySQL Workbench to localhost in Ubuntu 16.04 (passwordless root)
MySQL 5.7 and up don't support connecting as "root" in mysql-workbench so you must create a normal user and connect via that.
sudo mysql -u root -p
Create a user named "admin" and use that to ...
- 3,744
38
votes
Cannot connect MySQL Workbench to MySQL server
Go to Ubuntu Software.
Search for mysql-workbench and click on Mysql Workbench Community.
Click on Permissions.
Enable Read, add, change, or remove saved password̀s and ssh-keys (if you are also using ...
- 489
31
votes
Accepted
mysql-workbench and Gnome keyring daemon problem
The bug has been fixed in MySQL Workbench 6.2.5 / 6.3.0 releases. http://bugs.mysql.com/bug.php?id=74771
A possible workaround was to add this code to the top of file /usr/bin/mysql-workbench
export ...
- 426
24
votes
Accepted
How can I install MySQL Workbench on Ubuntu 20.04 LTS?
MySQL has updated their repository for Focal Fossa and removed the repository for Eoan Ermine. To install MySQL Workbench on 20.04, either download the Workbench for 20.04 from MySQL archives or ...
- 17.2k
18
votes
MySQL Workbench on Ubuntu 16.04
Try to reinstall the mysql-workbench.
To be sure you don't lose your connection data, copy following file: ~/.mysql/workbench/connections.xml
sudo apt-get remove mysql-workbench
sudo apt-get update
...
- 291
17
votes
Install MySQL Workbench in Ubuntu 19.04
so this were the steps I took in order to install it correctly:
Download the 2 Libraries that are needed and install them:
https://packages.ubuntu.com/cosmic/amd64/libssl1.0.0/download
https://...
- 207k
17
votes
Accepted
Why MySQL Workbench 8.x errors out with an SSL connection error, choose client version unsupported protocol
Ok, as pointed out in several places, the issue is related to that your client only allows to speak to TLS 1.2 or higher, as is required on new Ubuntu versions and software, but your server is only ...
- 431
15
votes
mysql-workbench and Gnome keyring daemon problem
There's a neat way I found, try this out.
Step 1: After installation unlock the workbench icon from launcher.
Step 2: press the super(window) button on your machine and search for workbench.
Step 3:...
- 251
12
votes
Accepted
E: Unable to locate package mysql-workbench-community
If you want to install Mysql Workbench Just run this command in terminal
sudo apt install mysql-workbench
You are good to go with Mysql Workbench
For Ubuntu 20.04 or higher version:
sudo snap install ...
- 656
11
votes
Accepted
Install MySQL Workbench in Ubuntu 19.04
I solved this problem by installing the libzip package, directly from the deb package. I found at libzip4_1.1.2-1.1_amd64.deb.
Download and install libzip4, then install mysql-workbench from the apt ...
- 126
11
votes
How can I install MySQL Workbench on Ubuntu 20.04 LTS?
What worked for me:
sudo snap install mysql-workbench-community
- 211
11
votes
Problems with mysql-workbench for Ubuntu 20.04
The standard way for installing MySQL Community Workbench now is through snap.
Snap sets up AppArmor profiles for applications it installs, and it looks like when AppArmor denies access to certain ...
- 213
9
votes
Accepted
Ubuntu 18.04 failed to boot: Faile to start MySQL Community Server
The problem has been solved by rebooting the system in the recovery mode.
To reach the recovery mode in Ubuntu 18.04, click the left Shift bottom and Esc. Then you will get options, choose Clean which ...
- 547
9
votes
how to completely remove mysql community workbench from my system
Based on the documentation, you can uninstall MySQL Workstation like this:
Open Terminal (if it’s not already open)
Uninstall the package:
sudo apt-get remove mysql-workbench-community
Check if ...
- 18.4k
9
votes
How to install MySQL Workbench Community on Ubuntu 22.04?
try the snap: snap install mysql-workbench-community
You would probably want to set/allow these. I got 'AppArmor'-errors when first trying and those were not set,
snap connect mysql-workbench-...
- 91
8
votes
How can I install MySQL Workbench on Ubuntu 20.04 LTS?
For anyone that comes here like I did by starting with a google search instead of going directly to the MySQL download page, there is a download explicitly for Ubuntu 20.04 on their downloads page:
...
- 191
8
votes
Connect MySQL Workbench to WSL2
I had the same problem with WSL 2 MySQL-Server; I fixed it by replacing 127.0.0.1 in the config of workbench connection with localhost.
127.0.0.1 config
Localhost config
I hope it will be useful for ...
- 181
7
votes
Unable to connect via MySQL Workbench to localhost in Ubuntu 16.04 (passwordless root)
This question might be two years old but my work with mysql-workbench tonight seems to have given me the answer to it.
root user now users auth_socket authentication by default. The only way root ...
7
votes
Accepted
Unable to install mysql-workbench for Ubuntu 16.04 LTS
It seems that you forgot to run sudo apt-get update before installing MySQL Workbench (Australian mirror is synced normally, it has correct version of gcc-5-base in pool).
If it does not help, try to ...
- 95.1k
7
votes
E: Unable to locate package mysql-workbench-community
snap install mysql-workbench-community
the problem that all snap packages are sanboxed and need to get permission to access local files & connect to DB.
Cannot connect MySQL Workbench to MySQL ...
- 201
7
votes
Connect MySQL Workbench to WSL2
The problem is how the root user is authenticated. By default this is set to use auth_socket instead of mysql_native_password.
Log into the mysql server in wsl as root user and run:
mysql > SELECT ...
- 71
6
votes
Accepted
mysql workbench broken after upgrade to Ubuntu 15.10
You installed version isn't the version of the Ubuntu Universe repository. Remove your installed version in /usr/local/bin
sudo rm /usr/local/bin/mysql-workbench*
and in /usr/local/lib
sudo rm -r /...
- 88.1k
6
votes
mysql-workbench and Gnome keyring daemon problem
Add this code to the top of file /usr/bin/mysql-workbench
if ls /run/user/`id -u`/keyring-* 1> /dev/null 2>&1; then
gnome-keyring-daemon > /dev/null
fi
export GNOME_KEYRING_CONTROL=$(ls -d /run/...
- 161
6
votes
Launcher icon doesn't start MySQL workbench
I am using Ubuntu 14.04 and was in the need of the same thing, so I resolved with this with a couple of easy steps.
I launched MySQL from the command:mysql-workbench
I right clicked the icon and ...
- 316
6
votes
Where is save data base made in mysql-workbench?
MySQL is a database and you're expected to interact with the database through tools (MySQL Workbench, the mysql command line tool, etc.) rather than directly interact with the files on disk.
In ...
- 171
6
votes
Accepted
Connect MySQL Workbench to WSL2
After some more searching I found hints that I may need to GRANT access. From inside the WSL2 box I added a new user and GRANTed access.
mysql> CREATE USER 'newguy'@'localhost' IDENTIFIED BY '...
- 301
5
votes
mysql-workbench and Gnome keyring daemon problem
I did as follows
i am using Workbench 6.3
sudo gedit /usr/bin/mysql-workbench
Just remove the comment
@line 5
WB_NO_GNOME_KEYRING=1
- 171
5
votes
MySQL importing CSV files really slow
You should have a look at the LOAD DATA function of MySQL, or the mysqlimport tool.
Those two functions are reportedly 20-30 times faster than insert'ing one by one, which would bring you up to at ...
- 20.5k
Only top scored, non community-wiki answers of a minimum length are eligible