Fixing errors during installation of MySql Workbench in Linux.

HimanshuHimanshu
1 min read

Errors -

  • mysql can't connect to localhost.
  1. Go to /etc/my.cnf

  2. Add the following lines to your file if these are not written already-

     #skip-networking
     bind-address = 127.0.0.1
     port=3306
     datadir=/var/lib/mysql
     socket=/var/lib/mysql/mysql.sock
     log-error=/var/log/mysqld.log
     pid-file=/run/mysqld/mysqld.pid
     [mysql.server]
     basedir=/var/lib/mysql
    
  3. Remove 'skip-grant-tables', if it is written in the file.

  4. sudo systemctl daemon-reload.

  5. sudo systemctl restart mysqld.

Now, you can connect your mysql workbench to localhost.

0
Subscribe to my newsletter

Read articles from Himanshu directly inside your inbox. Subscribe to the newsletter, and don't miss out.

Written by

Himanshu
Himanshu