Cannot connect MySQL Workbench to MySQL server

Question

I have installed MySQL workbench from Snap Store and MySQL server 8.0 using apt. The server is running fine and I can access MySQL shell from terminal. But I am having issues connecting the Workbench to the server. I'm getting

Cannot Connect to Database Server

Your connection attempt failed for user 'root' to the MySQL server at localhost:3306:

An AppArmor policy prevents this sender from sending this message to this recipient; type="method_call", sender=":1.125" (uid=1000 pid=7944 comm="/snap/mysql-workbench-community/5/usr/bin/mysql- wo" label="snap.mysql-workbench-community.mysql-workbench- community (enforce)") interface="org.freedesktop.Secret.Service" member="OpenSession” error name="(unset)" requested_reply="0" destination=":1.13" (uid=1000 pid=2044 comm="/usr/bin/gnome- keyring-daemon --daemonize --login" label="unconfined")

Please:

1 Check that MySQL is running on address localhost

2 Check that MySQL is reachable on port 3306 (note: 3306 is the default, but this can be changed)

3 Check the user root has rights to connect to localhost from your address (MySQL rights define what clients can connect to the server and from which machines)

4 Make sure you are both providing a password if needed and using the correct password for localhost connecting from the host address you're connecting from

There no field for entering password. It shows two options store in keychain and clear. On selecting store in keychain it prompts for a password, and I enter the password. But then it shows an error:

Could not store password: An AppArmor policy prevents this sender ...

Just about certain that you have the dreaded MySql can't connect with a password. See step 3 on this page. Try it. https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-18-04 — walttheboss, May 21 '20 at 09:35
FYI: MySQL Workbench's Snap package isn't officially maintained by MySQL while the debs are. — Kulfy, May 21 '20 at 11:49
I'm running Ubuntu 20.10 (I like to use latest, but I often can't switch right away because of GPU driver issues) so I can't use an officially-supported deb file right now. They only officially support 20.04 and 21.04 right now. So I tried the snap today, and ran into this. — Matt Welke, May 03 '21 at 00:22

score 252 · Accepted Answer · answered May 23 '20 at 11:13

252

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 allowed to access this service. When you choose "Store in keychain" MySQLWorkbench is blocked by AppArmor.

You need to enter a command to allow this package to access the service. The command is:

sudo snap connect mysql-workbench-community:password-manager-service :password-manager-service

I got this from the discussion at this site.

answered May 23 '20 at 11:13

Jos

29,224

4

This worked for me on ubuntu 20.10 – bhattraideb Mar 08 '21 at 16:00
this didnt work for me, I had to enter mysql as root and use:<< ALTER USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; then it worked. Need to point out that my user had <<auth_plugin>> activated meaning to enter mysql I had only to type mysql now I need to do mysql -p and enter my password – pippo1980 Mar 11 '21 at 19:30
but then worked – pippo1980 Mar 11 '21 at 19:52
I get the error error: snap "snapd" has no slot named "password-manager" – Mathew Alden Apr 16 '21 at 15:54
Tiago's solution worked for me. – Mathew Alden Apr 16 '21 at 16:02
This worked for me; although I also had to change the permissions in the Software Center to allow me to access certs. – HardlyNoticeable Apr 20 '21 at 03:46
this worked beautifully... thanks – Wizard Sultan Apr 26 '21 at 11:27
This got me past the error for storing the password. I was able to begin connecting. But then I got an error after about 30 seconds saying Your connection attempt failed for user 'admin' to the MySQL server at <aws_host>:3306: Unable to connect to localhost. Strange that it's trying to connect to localhost despite me putting in my AWS RDS database host as the host to connect to. – Matt Welke May 03 '21 at 00:28
I was able to connect. It turns out I forgot to allowlist my IP address. :P My bad. So it looks like for me, just running the snap commands in this answer was enough to get me able to connect using Ubuntu 20.10. – Matt Welke May 03 '21 at 00:47
It's worked me thank you brother – Praveen Chelumalla Jun 28 '21 at 05:30
Do I need to do it only once or every time? – Payel Senapati Sep 03 '21 at 19:31
Once should be enough. – Jos Sep 03 '21 at 23:53
worked for me on ubuntu 20.04 – Mohit Malviya Dec 14 '21 at 06:31
solved my problem on ubuntu 20.04 - thanks! – Loz Jan 07 '22 at 15:11
Thank you so much . This command worked fine and resolved the issue! – Farooq Khan Feb 04 '22 at 07:16
3

This worked for me on Ubuntu 22.04. Thanks. – Tinashe Chinyanga May 04 '22 at 18:04
Thanks much this worked for me – Laban May 17 '22 at 13:55
1

@Jos thank you very much struggling all day morning both on Ubuntu 22.04 and Linux Mint 21. Until I arrived to your response. Thank you man. Much appreciated. – Matija Jan 16 '23 at 11:04

score 40 · Answer 2 · edited Apr 23 '21 at 07:00

40

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 ssh keys)

edited Apr 23 '21 at 07:00

HardlyNoticeable

103
3

answered Nov 05 '20 at 17:25

Miral Modi

509

I think this solution is the easiest. Thanks! – Marcelo Pereira Rodrigues May 17 '21 at 21:38

score 2 · Answer 3 · edited Nov 05 '20 at 19:22

To make it work I tested a different approach and went to MySQL Community Downloads.

In there, selected the operating system Ubuntu Linux, version 20.04 (x86, 64-bit) and clicked the Download button. Then, "No thanks, just start my download" and saved it. This is a .deb file that got saved in the Download folder and so, to install it,

cd ~/Downloads
sudo apt-get install ./mysql-workbench-community_8.0.20-1ubuntu20.04_amd64.deb

After installation is complete, went to Applications, opened it and the AppArmor policy error didn't show up again but couldn't still connect using the root user.

Then, tying to connect with the credentials created in the approach two, it worked just fine

Cannot connect MySQL Workbench to MySQL server

Cannot Connect to Database Server

3 Answers3

Linked

Related