MySQL Forums
Forum List  »  MySQL Workbench

Workbench can't connect but mysql command line can?
Posted by: Jon Daniel
Date: February 10, 2021 05:31AM

So I'm connecting to a mysql database ...

Works fine from the command line --

jonathans-MacBook-Pro:synergysuite jon$ mysql -h ***snipped*** -P 3306 -u jon.daniel -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 49647833
Server version: 5.6.10-log MySQL Community Server (GPL)

Copyright (c) 2000, 2021, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use emdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select count(*) from person;
| count(*) |
| 156893 |
1 row in set (0.52 sec)

mysql> quit

Workbench set up --

Test Connection -- works fine, 'Successfully made the MySQL connection'

Attempt to open a connection there so I can run some queries ... MySQL workbench hangs. I've tried playing with various settings (require ssl, etc. - no effect, test connection succeeds, opening a DB doesn't)

Any ideas???

Options: ReplyQuote

Written By
Workbench can't connect but mysql command line can?
February 10, 2021 05:31AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.