If it did, you'll be brought to the "workspace".Ĭonflict with GTK theme + how to set darktheme Now restart/open MySql Workbench again and test if it worked. Mysql> FLUSH PRIVILEGES # "refresh" cache Mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root' # change plugin for root user Mysql> SELECT User, Host, plugin FROM er # see all users and local hosts $ sudo mysql -u root -p # log-in into MySql (terminal) as root user with sudo In this case, we are going to change the plugin for the root user: To solve this, we'll have to change the plugin for the root user or create a new user and set the plugin we need for that one. The culprit is the default the UNIX or auth_socket plugin MySql uses for the Root user, which won't work in most Debian based distributions. Then keep reading, I'll show you what is causing this issue and how to solve it. If when trying to start a connection in MySql Workbench (clicking any of the available connections) something like this appears: (fusing 1 & 2) can't log-in to MySql and neither can I start a connection in MySql Workbench I suppose you already know how MySql work, so now I'm going to explain some issues I ran into:Ĭan't start a MySql connection in WorkbenchĬonflict with GTK theme (Workbench glitches) $ sudo apt-get update & sudo apt-get upgrade # update and upgrade the system In case something went wrong, or couldn’t finish installation (happened to me at first, but it was something I caused basically) due to lack of some dependencies, then: $ mkdir /tmp/mysql_workbench_install & cd /tmp/mysql_workbench_install To make life easier, copy and paste the following commands in the terminal (for Ubuntu 20.10 only, although you can also change the link below next to wget command with the one you want for your ubuntu version. You can just visit MySql’s download page and get the. You will just say "yes" or "no" to what it asks you (recommendation: SET a password :) Mysql-community-client mysql-community-server-debug mysql-server mysql-testsuiteįor the purposes of this tutorial, we will install just the server version:Ĭonfigure it using a simple script that comes with it. Mysql-common mysql-community-server-core mysql-sandbox mysqltcl Mysql-client-core-8.0 mysql-community-server mysql-router mysql-source-8.0 mysql-workbench-community Mysql-client-8.0 mysql-community-client-plugins mysql-community-test-debug mysql-server-core-8.0 mysqltuner Mysql-client mysql-community-client-core mysql-community-test mysql-server-8.0 mysql-testsuite-8.0 In this case, this is everything you can install: $ sudo apt-get update & sudo apt-get upgrade You will run into errors that I'll be going over in the end Instructions are oriented for Ubuntu 20.10, tho they can be adapted to other debian based distros/Ubuntu versions And like so, I created this little guide on how to install both in Debian-based distros (mainly ubuntu tho instructions can be adapted). While trying to install MySql and MySql Workbench and ran into many problems, which of course, I solved.
0 Comments
Leave a Reply. |