Alex (SirShurf) Frenkel's Blog

A web log of a PHP professional

Posts Tagged ‘Workbench

Ubuntu 11.10 (Oneiric Ocelot) and MySQL Workbench gpl, fix plus deb repository

with 3 comments

Since the install of Ubuntu 11.10 (Oneiric Ocelot) my MySQL Workbench was mostly unusable. I could not open it normally and Query Browser was not accessible. Finally a few days ago a patch was summited to the MySQL forum, but it was for a self compile version only.

Today I found a debian repository that maintains MySQL Workbench gpl and the fix is already implemented there. In order to update it use next commands:

sudo add-apt-repository ppa:olivier-berten/misc
sudo apt-get update
sudo apt-get install mysql-workbench-gpl

Now we have a debian repository for MySQL Workbench and a version that will work on Ubuntu 11.10 (Oneiric Ocelot)

Advertisements

Written by Alex (Shurf) Frenkel

November 7, 2011 at 9:46 am

Lost connection to MySQL server at ‘reading initial communication packet’, system error: 111

leave a comment »

For the past couple of days, for some reason I was unable to connect to the MySQL database on the system I worked, it was not a problem till now, since all I needed was a data grid, but now I had to use workbench.

The error I was getting was: Lost connection to MySQL server at ‘reading initial communication packet’, system error: 111

Well, it took me a couple of hours to gast that but I have finally found the reasone.

Early this week we have changed the bind address of the MySQL server in the my.inf file to be the external address of the system.

What i had to do was to match the address of the bind from localhost to the external one, so the correct command was:

ssh -v -f -N -L 3307:192.168.0.1:3306 user@host.server.com

Written by Alex (Shurf) Frenkel

May 5, 2010 at 9:46 pm

Posted in Uncategorized

Tagged with , ,