MYSQL Workbench cannot find command line client

Questions about applications and software
Forum rules
Before you post read how to get help. Topics in this forum are automatically closed 6 months after creation.
Locked
oatly93
Level 1
Level 1
Posts: 30
Joined: Mon Feb 15, 2021 3:09 pm

MYSQL Workbench cannot find command line client

Post by oatly93 »

Hey!

I'm trying to execute a very simple command from MySQL Workbench in Linux Mint. Connection to the server seems OK and the server is running. However, when I try to run a code I get:

"mysql command line client not found. Please fix its path in Preferences -> Administration"

But when I try to select the path /usr/bin/mysql from Administration I cannot even access the /usr path, I get 'permission denied'.
I tried playing around with apparmor, stopping the service to see if that was the case, but no results so far.
I already posted in stack overflow, but I'm wondering if this is more of a Linux Mint issue....
Thanks!
Last edited by LockBot on Fri Jun 02, 2023 10:00 pm, edited 1 time in total.
Reason: Topic automatically closed 6 months after creation. New replies are no longer allowed.
mikeflan
Level 17
Level 17
Posts: 7106
Joined: Sun Apr 26, 2020 9:28 am
Location: Houston, TX

Re: MYSQL Workbench cannot find command line client

Post by mikeflan »

Howdy.

How did you install MySQL?

If you do a search for that error message you get a ton of hits, including this one:
https://askubuntu.com/questions/369910/ ... -not-found
oatly93
Level 1
Level 1
Posts: 30
Joined: Mon Feb 15, 2021 3:09 pm

Re: MYSQL Workbench cannot find command line client

Post by oatly93 »

mikeflan wrote: Fri Dec 02, 2022 9:38 am How did you install MySQL?
The workbench I did a snap. Server and client are installed through apt-get install :) Googled quite a bit before posting, but still cannot find anything relevant...
I can access the client easily through the command line, but I cannot point the Workbench application to that directory (or at least what I think it's the directory, /usr/bin/mysql) because every time I click on /usr it says permission denied...
oatly93
Level 1
Level 1
Posts: 30
Joined: Mon Feb 15, 2021 3:09 pm

Re: MYSQL Workbench cannot find command line client

Post by oatly93 »

UPDATE:
I tried opening from the command line using the command: sudo mysql-workbench-community and I get the following output:

mkdir: cannot create directory '/run/user/0': Permission denied Warning: Schema “org.gnome.system.locale” has path “/system/locale/”. Paths starting with “/apps/”, “/desktop/” or “/system/” are deprecated. Warning: Schema “org.gnome.system.proxy” has path “/system/proxy/”. Paths starting with “/apps/”, “/desktop/” or “/system/” are deprecated. Warning: Schema “org.gnome.system.proxy.http” has path “/system/proxy/http/”. Paths starting with “/apps/”, “/desktop/” or “/system/” are deprecated. Warning: Schema “org.gnome.system.proxy.https” has path “/system/proxy/https/”. Paths starting with “/apps/”, “/desktop/” or “/system/” are deprecated. Warning: Schema “org.gnome.system.proxy.ftp” has path “/system/proxy/ftp/”. Paths starting with “/apps/”, “/desktop/” or “/system/” are deprecated. Warning: Schema “org.gnome.system.proxy.socks” has path “/system/proxy/socks/”. Paths starting with “/apps/”, “/desktop/” or “/system/” are deprecated. Using /snap/mysql-workbench-community/10/usr/lib/x86_64-linux-gnu/libproj.so. No protocol specified
Locked

Return to “Software & Applications”