CODEWITHSUNDEEP
mysqlmacosmysql-workbench
David North
David North

Reputation: 447

MySQL Workbench error when adding a connection

I'm new to mac and mySQL. I installed mySQL 5.6.14 and mySQLWorkbench 1.6. I turned on mySQL in system preferences.

Then I went into workbench, clicked to add a new connection and filled in the details: host is localhost; username is root; password is empty/nothing. Tested the connection and its all good.

Clicked OK and got this error: Exception caught while processing action from home screen: error calling Python module function WbAdmin.autoDetectLocalInstance.

I also can not access mySQL from the terminal.

I've googled and can't find anything. Has anyone got any ideas of what could be wrong something I could try to fix it.

Upvotes: 4

Views: 16068

Answers (3)

ismailarilik
ismailarilik

Reputation: 2386

I've had the same problem. I solved this issue by getting settings section from main window and then connecting from appeared connection from the main window.

Upvotes: 1

kristinb
kristinb

Reputation: 11

If you are a mac your default password is root . Same as the username.

Upvotes: 1

user3688000
user3688000

Reputation: 11

I've had de same problem. For me the solution:

Check that you have the file /etc/my.cnf if you don't have sudo cp my-default.cnf on the terminal

Try to put password Virlli$ sudo /usr/local/mysql/bin/mysqladmin -u root password 'password'

Restart Mysql and Workbench

for Mysql :sudo /usr/local/mysql/support-files/mysql.server stop

Upvotes: 1

Related Questions