Hello everyone.
So, tip for anyone facing issues trying to use MySQL and the workbench in Ubuntu. I’m using Ubuntu 18 and I was having problems connecting the bench to the server. Nothing I was trying solved. It was some issue related to permissions and access denied to the workbench (but forcing permissions didnt work).
Just uninstall everything: mysql, mysql-client, mysql workbench. Install everything by the terminal only followig this video:
Its in portuguese but you dont need to understand much haha. Just follow the commands. The guy installs everything and also run some commands to test. mysql-client was also installed. This installation method launches the server by default with no password, but then, via MySQL at the terminal, he sets up a password to the root user also defining the password method (i dont know much about it).
It works now.
I had installed MySQL from the terminal before, and I think with a bit different commands. Then I had installed the workbench by the ubuntu app store. Well… It was a mess.
Cheers!