Home / ubuntu / Questions / 1242026
Accepted
parv desai
Asked: 2020-05-21 23:55:43 +0800 CST

Cannot connect MySQL Workbench to MySQL server

  • 772

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 ...

mysql snap mysql-workbench

3 Answers

  1. Best Answer

    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.

    • 196
    1. Go to Ubuntu Software.
    2. Search for mysql-workbench and click on Mysql Workbench Community.
    3. Click on Permissions.
    4. Enable Read, add, change, or remove saved password̀s and ssh-keys (if you are also using ssh keys)
    • 31

  3. 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

    MySQL Workbench connected fine in Ubuntu 20.04

    • 1