Search code examples
mysqlmysql-workbenchlocalserver

MySql workbench not responding w local server

I have been using MySql Workbench to connect to a local MySql server and to remote MySql Servers. The last couple of days the Workbench freezes when I connect to the local version. It still works for the remote servers.

I am using workbench 6.3.4 and then tried 6.2.5 just to see if it is a version issue.

I also can access the local MySql instance using HeidiSQL.

Any recommendations on what to look for?

Update The advice to recreate the connection solved the issue. I just created a new one and it works fine.

Solution

  • A couple of things you can try:

    • Try restarting the sql server (remember, workbench is just a utility for accessing a db, it does not host the database for you)

    • See if you can access mysql on the command prompt / terminal, the command for mac & windows

    (once you navigate to the mysql folder, try the command:)

    mysql -u root

    (if you have a password-protected account, the command will be

    mysql -u someuser -p
    • If the above doesn't work, mysql is either offline or denying you access (depending on response), and you'll need to setup the server / assign privileges.
    • If all else fails, it may help to try another version of SQL / Workbench (for a easy-to-use sql sever setup, I'd recommend WAMP or MAMP, assuming you want a HTTP server bundled with it)

    Additionally, it may help to recreate the local connection in workbench (of if your getting regular crashes, reinstall & update workbench). Good luck with it.