brew mysql workbench_自制" brew install mysql" 给出" ......将值'127.0.0.1'设置为'server_id'时出错" (Homebrew "b...

2014-10-20 01:01:08

0

I recently upgraded my system to OS X Yosemite and started encountering some issues to connect locally to my Database via MySQL Workbench.

It was mainly classic ones about the PID files and socket, that I managed to find solutions for looking over the web. However one was remaining : "Can't connect to MySQL server on '127.0.0.1' (61) (2003)", and none of the solutions I found on the MySQL website, stackoverflow and other forums were working.

I therefore decided to reinstall MySQL using the dmg file (version for OS X 10.9 though, no version yet available for 10.10). It did not work.

That's why I eventually uninstalled every little piece of mysql that I could and reinstalled a clean version using homebrew. The steps I followed are those ones.

However, this did not work either and here is the error message I got :

$ brew postinstall mysql

==> /usr/local/Cellar/mysql/5.6.21/bin/mysql_install_db --verbose --user=Antoine

Installing MySQL system tables...Unknown suffix '.' used for variable 'server_id' (value '127.0.0.1')

2014-10-20 02:35:05 0 [ERROR] /usr/local/Cellar/mysql/5.6.21/bin/mysqld: Error while setting value '127.0.0.1' to 'server_id'

2014-10-20 02:35:05 0 [ERROR] Aborting

2014-10-20 02:35:05 0 [Note] Binlog end

It makes now a little more sense that MySQL server was not able to connect to 127.0.0.1, but I must say that I'm lost and do not really know where to look anymore. I can't find anything on this error message. I had a look to the mysqld file, but it was useless.

Do you think the issue is linked to OS X Yosemite? Any clue of what I could do from here?