Could not save XML data to file /home/username/.mysql/workbench/connections.xml

I have installed mysql workbench on Ubuntu 18.04. I'm getting error:

[2003] can't connect to database on 127.0.0.1 (111).

so I have tried to put bind-address=127.0.0.1 in /etc/my.cnf file but i couldn't find it at that location and it was in /etc/mysql/my.cnf but it was only read-only. From terminal

vi /etc/my.cnf

then wrote that and exit from the file (it was new file), i tried to reopen mysql-workbench but got new problem at starting

 Error while setting up home screen. The error message is: Could not save XML data to file /home/anup/.mysql/workbench/connections.xml

after that when i was trying to create a connection got the below problem. now ,i'm not even able create new connection.

Exception caught while processing action from home screen: error calling Python module function WbAdmin.autoDetectLocalInstance 

I uninstalled and then reinstall mysql workbench but nothing worked. I just don't know what happened and how to fix it.

6

1 Answer

$ gksu gedit /usr/share/applications/mysql-workbench.desktop**

Change relevant lines to:

Exec=gksu mysql-workbench
Terminal=false
Type=application

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy