QA@IT
«質問へ戻る

brew info mysql の結果 を追記

40
本文
  
 ```
 
+【追記】brew info mysql の結果
+
+```
+$ brew info mysql
+mysql: stable 5.5.25a (bottled)
+http://dev.mysql.com/doc/refman/5.5/en/
+Depends on: cmake, pidof
+Conflicts with: percona-server, mariadb
+/usr/local/Cellar/mysql/5.5.25a (6382 files, 222M) *
+https://github.com/mxcl/homebrew/commits/master/Library/Formula/mysql.rb
+==> Options
+--with-tests
+    Build with unit tests
+--universal
+    Build a universal binary
+--with-archive-storage-engine
+    Compile with the ARCHIVE storage engine enabled
+--with-embedded
+    Build the embedded server
+--with-blackhole-storage-engine
+    Compile with the BLACKHOLE storage engine enabled
+--with-libedit
+    Compile with editline wrapper instead of readline
+--enable-local-infile
+    Build with local infile loading support
+==> Caveats
+Set up databases to run AS YOUR USER ACCOUNT with:
+    unset TMPDIR
+    mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
+
+To set up base tables in another folder, or use a different user to run
+mysqld, view the help for mysqld_install_db:
+    mysql_install_db --help
+
+and view the MySQL documentation:
+  * http://dev.mysql.com/doc/refman/5.5/en/mysql-install-db.html
+  * http://dev.mysql.com/doc/refman/5.5/en/default-privileges.html
+
+To run as, for instance, user "mysql", you may need to `sudo`:
+    sudo mysql_install_db ...options...
+
+Start mysqld manually with:
+    mysql.server start
+
+    Note: if this fails, you probably forgot to run the first two steps up above
+
+A "/etc/my.cnf" from another install may interfere with a Homebrew-built
+server starting up correctly.
+
+To connect:
+    mysql -uroot
+
+To launch on startup:
+* if this is your first install:
+    mkdir -p ~/Library/LaunchAgents
+    cp /usr/local/Cellar/mysql/5.5.25a/homebrew.mxcl.mysql.plist ~/Library/LaunchAgents/
+    launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
+
+* if this is an upgrade and you already have the homebrew.mxcl.mysql.plist loaded:
+    launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
+    cp /usr/local/Cellar/mysql/5.5.25a/homebrew.mxcl.mysql.plist ~/Library/LaunchAgents/
+    launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
+
+You may also need to edit the plist to use the correct "UserName".
+```
+
 【参考】
 http://tukaikta.blog135.fc2.com/blog-entry-197.html
 http://dev.classmethod.jp/etc/macbookair-homebrew-mysql5-5-14/

MySQLが起動できない

homebrewでMySQLをインストールすることはできましたが、サーバ起動でエラーになります。MBPのLion(MacOS10.7.4)です。

$ mysql.server start
Starting MySQL
......... ERROR! The server quit without updating PID file (/usr/local/var/mysql/hogehoge.pid).

その前に unknown variable 'mysql.default_socket=/tmp/mysql.sock'エラーも出てます。


$ mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
Installing MySQL system tables...
120824 14:31:55 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
120824 14:31:55 [ERROR] Aborting

120824 14:31:55 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete

Installation of system tables failed!  Examine the logs in
/usr/local/var/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &

and use the command line tool /usr/local/Cellar/mysql/5.5.25a/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /usr/local/var/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/local/Cellar/mysql/5.5.25a/scripts/mysqlbug script!

なお /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant & の結果は次のように
unknown variable 'mysql.default_socket=/tmp/mysql.sock'となります。

$ /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &
[1] 6762
16:18:03 ~/todo $ 120824 16:18:03 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
120824 16:18:03 InnoDB: The InnoDB memory heap is disabled
120824 16:18:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120824 16:18:03 InnoDB: Compressed tables use zlib 1.2.5
120824 16:18:03 InnoDB: Initializing buffer pool, size = 128.0M
120824 16:18:03 InnoDB: Completed initialization of buffer pool
120824 16:18:03 InnoDB: highest supported file format is Barracuda.
120824 16:18:03  InnoDB: Waiting for the background threads to start
120824 16:18:04 InnoDB: 1.1.8 started; log sequence number 1595675
120824 16:18:04 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
120824 16:18:04 [ERROR] Aborting

120824 16:18:04  InnoDB: Starting shutdown...
120824 16:18:05  InnoDB: Shutdown completed; log sequence number 1595675
120824 16:18:05 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete

また以前に中途半端にdmgでインストールしようとした事はありました。
システム環境設定に「MySQL」が残っていて /usr/local/mysql/bin/mysqladminを呼んでいたので

$ cd /usr/local 
$ ln -s /usr/local/Cellar/mysql/5.5.25a mysql

でリンクを作って、「Start MySQL Server」ボタンを押せるようにして押しても

The MySQL Server Instance is stopped 

のままびくともしません。

エラーログまわりの設定が必要なのかもしれませんが、Lionでのエラーログの正しい場所が
Linuxでの/var/log/mysql/error.log とは違うのだろうなとは思いつつ良く解っていません。

ご教示のほどよろしくお願い致します。

tmtmsさんのご指摘で再トライの結果

$ /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant & 
[1] 12595
$ 120824 18:11:30 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
120824 18:11:30 InnoDB: The InnoDB memory heap is disabled
120824 18:11:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120824 18:11:30 InnoDB: Compressed tables use zlib 1.2.5
120824 18:11:30 InnoDB: Initializing buffer pool, size = 128.0M
120824 18:11:30 InnoDB: Completed initialization of buffer pool
120824 18:11:30 InnoDB: highest supported file format is Barracuda.
120824 18:11:30  InnoDB: Waiting for the background threads to start
120824 18:11:31 InnoDB: 1.1.8 started; log sequence number 1595675
120824 18:11:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120824 18:11:31 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120824 18:11:31 [Note] Server socket created on IP: '0.0.0.0'.
120824 18:11:31 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
120824 18:11:31 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
120824 18:11:31 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: ready for connections.
Version: '5.5.25a'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

$ /usr/local/Cellar/mysql/5.5.25a/bin/mysql -u root mysql
/usr/local/Cellar/mysql/5.5.25a/bin/mysql: unknown variable 'mysql.default_socket=/tmp/mysql.sock'

【追記】brew info mysql の結果

$ brew info mysql
mysql: stable 5.5.25a (bottled)
http://dev.mysql.com/doc/refman/5.5/en/
Depends on: cmake, pidof
Conflicts with: percona-server, mariadb
/usr/local/Cellar/mysql/5.5.25a (6382 files, 222M) *
https://github.com/mxcl/homebrew/commits/master/Library/Formula/mysql.rb
==> Options
--with-tests
    Build with unit tests
--universal
    Build a universal binary
--with-archive-storage-engine
    Compile with the ARCHIVE storage engine enabled
--with-embedded
    Build the embedded server
--with-blackhole-storage-engine
    Compile with the BLACKHOLE storage engine enabled
--with-libedit
    Compile with editline wrapper instead of readline
--enable-local-infile
    Build with local infile loading support
==> Caveats
Set up databases to run AS YOUR USER ACCOUNT with:
    unset TMPDIR
    mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp

To set up base tables in another folder, or use a different user to run
mysqld, view the help for mysqld_install_db:
    mysql_install_db --help

and view the MySQL documentation:
  * http://dev.mysql.com/doc/refman/5.5/en/mysql-install-db.html
  * http://dev.mysql.com/doc/refman/5.5/en/default-privileges.html

To run as, for instance, user "mysql", you may need to `sudo`:
    sudo mysql_install_db ...options...

Start mysqld manually with:
    mysql.server start

    Note: if this fails, you probably forgot to run the first two steps up above

A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.

To connect:
    mysql -uroot

To launch on startup:
* if this is your first install:
    mkdir -p ~/Library/LaunchAgents
    cp /usr/local/Cellar/mysql/5.5.25a/homebrew.mxcl.mysql.plist ~/Library/LaunchAgents/
    launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

* if this is an upgrade and you already have the homebrew.mxcl.mysql.plist loaded:
    launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
    cp /usr/local/Cellar/mysql/5.5.25a/homebrew.mxcl.mysql.plist ~/Library/LaunchAgents/
    launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

You may also need to edit the plist to use the correct "UserName".

【参考】
http://tukaikta.blog135.fc2.com/blog-entry-197.html
http://dev.classmethod.jp/etc/macbookair-homebrew-mysql5-5-14/

homebrewでMySQLをインストールすることはできましたが、サーバ起動でエラーになります。MBPのLion(MacOS10.7.4)です。

```
$ mysql.server start
Starting MySQL
......... ERROR! The server quit without updating PID file (/usr/local/var/mysql/hogehoge.pid).
```

その前に `unknown variable 'mysql.default_socket=/tmp/mysql.sock'`エラーも出てます。

```

$ mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
Installing MySQL system tables...
120824 14:31:55 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
120824 14:31:55 [ERROR] Aborting

120824 14:31:55 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete

Installation of system tables failed!  Examine the logs in
/usr/local/var/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &

and use the command line tool /usr/local/Cellar/mysql/5.5.25a/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /usr/local/var/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/local/Cellar/mysql/5.5.25a/scripts/mysqlbug script!

```
なお /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant & の結果は次のように
unknown variable 'mysql.default_socket=/tmp/mysql.sock'となります。

```
$ /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &
[1] 6762
16:18:03 ~/todo $ 120824 16:18:03 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
120824 16:18:03 InnoDB: The InnoDB memory heap is disabled
120824 16:18:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120824 16:18:03 InnoDB: Compressed tables use zlib 1.2.5
120824 16:18:03 InnoDB: Initializing buffer pool, size = 128.0M
120824 16:18:03 InnoDB: Completed initialization of buffer pool
120824 16:18:03 InnoDB: highest supported file format is Barracuda.
120824 16:18:03  InnoDB: Waiting for the background threads to start
120824 16:18:04 InnoDB: 1.1.8 started; log sequence number 1595675
120824 16:18:04 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
120824 16:18:04 [ERROR] Aborting

120824 16:18:04  InnoDB: Starting shutdown...
120824 16:18:05  InnoDB: Shutdown completed; log sequence number 1595675
120824 16:18:05 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete

```

また以前に中途半端にdmgでインストールしようとした事はありました。
システム環境設定に「MySQL」が残っていて /usr/local/mysql/bin/mysqladminを呼んでいたので

```
$ cd /usr/local 
$ ln -s /usr/local/Cellar/mysql/5.5.25a mysql
```

でリンクを作って、「Start MySQL Server」ボタンを押せるようにして押しても

```
The MySQL Server Instance is stopped 
```

のままびくともしません。

エラーログまわりの設定が必要なのかもしれませんが、Lionでのエラーログの正しい場所が
Linuxでの/var/log/mysql/error.log とは違うのだろうなとは思いつつ良く解っていません。

ご教示のほどよろしくお願い致します。

tmtmsさんのご指摘で再トライの結果

```
$ /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant & 
[1] 12595
$ 120824 18:11:30 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
120824 18:11:30 InnoDB: The InnoDB memory heap is disabled
120824 18:11:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120824 18:11:30 InnoDB: Compressed tables use zlib 1.2.5
120824 18:11:30 InnoDB: Initializing buffer pool, size = 128.0M
120824 18:11:30 InnoDB: Completed initialization of buffer pool
120824 18:11:30 InnoDB: highest supported file format is Barracuda.
120824 18:11:30  InnoDB: Waiting for the background threads to start
120824 18:11:31 InnoDB: 1.1.8 started; log sequence number 1595675
120824 18:11:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120824 18:11:31 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120824 18:11:31 [Note] Server socket created on IP: '0.0.0.0'.
120824 18:11:31 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
120824 18:11:31 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
120824 18:11:31 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: ready for connections.
Version: '5.5.25a'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

$ /usr/local/Cellar/mysql/5.5.25a/bin/mysql -u root mysql
/usr/local/Cellar/mysql/5.5.25a/bin/mysql: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
 
```

【追記】brew info mysql の結果

```
$ brew info mysql
mysql: stable 5.5.25a (bottled)
http://dev.mysql.com/doc/refman/5.5/en/
Depends on: cmake, pidof
Conflicts with: percona-server, mariadb
/usr/local/Cellar/mysql/5.5.25a (6382 files, 222M) *
https://github.com/mxcl/homebrew/commits/master/Library/Formula/mysql.rb
==> Options
--with-tests
    Build with unit tests
--universal
    Build a universal binary
--with-archive-storage-engine
    Compile with the ARCHIVE storage engine enabled
--with-embedded
    Build the embedded server
--with-blackhole-storage-engine
    Compile with the BLACKHOLE storage engine enabled
--with-libedit
    Compile with editline wrapper instead of readline
--enable-local-infile
    Build with local infile loading support
==> Caveats
Set up databases to run AS YOUR USER ACCOUNT with:
    unset TMPDIR
    mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp

To set up base tables in another folder, or use a different user to run
mysqld, view the help for mysqld_install_db:
    mysql_install_db --help

and view the MySQL documentation:
  * http://dev.mysql.com/doc/refman/5.5/en/mysql-install-db.html
  * http://dev.mysql.com/doc/refman/5.5/en/default-privileges.html

To run as, for instance, user "mysql", you may need to `sudo`:
    sudo mysql_install_db ...options...

Start mysqld manually with:
    mysql.server start

    Note: if this fails, you probably forgot to run the first two steps up above

A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.

To connect:
    mysql -uroot

To launch on startup:
* if this is your first install:
    mkdir -p ~/Library/LaunchAgents
    cp /usr/local/Cellar/mysql/5.5.25a/homebrew.mxcl.mysql.plist ~/Library/LaunchAgents/
    launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

* if this is an upgrade and you already have the homebrew.mxcl.mysql.plist loaded:
    launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
    cp /usr/local/Cellar/mysql/5.5.25a/homebrew.mxcl.mysql.plist ~/Library/LaunchAgents/
    launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

You may also need to edit the plist to use the correct "UserName".
```

【参考】
http://tukaikta.blog135.fc2.com/blog-entry-197.html
http://dev.classmethod.jp/etc/macbookair-homebrew-mysql5-5-14/

my.cnfのmysql.default_socket=/tmp/mysql.sockをコメントアウトした結果を追記

40
本文
 
 ご教示のほどよろしくお願い致します。
 
+tmtmsさんのご指摘で再トライの結果
+
+```
+$ /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant & 
+[1] 12595
+$ 120824 18:11:30 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
+120824 18:11:30 InnoDB: The InnoDB memory heap is disabled
+120824 18:11:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
+120824 18:11:30 InnoDB: Compressed tables use zlib 1.2.5
+120824 18:11:30 InnoDB: Initializing buffer pool, size = 128.0M
+120824 18:11:30 InnoDB: Completed initialization of buffer pool
+120824 18:11:30 InnoDB: highest supported file format is Barracuda.
+120824 18:11:30  InnoDB: Waiting for the background threads to start
+120824 18:11:31 InnoDB: 1.1.8 started; log sequence number 1595675
+120824 18:11:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
+120824 18:11:31 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
+120824 18:11:31 [Note] Server socket created on IP: '0.0.0.0'.
+120824 18:11:31 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
+120824 18:11:31 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
+120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
+120824 18:11:31 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: ready for connections.
+Version: '5.5.25a'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
+
+$ /usr/local/Cellar/mysql/5.5.25a/bin/mysql -u root mysql
+/usr/local/Cellar/mysql/5.5.25a/bin/mysql: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
+ 
+```
+
 【参考】
 http://tukaikta.blog135.fc2.com/blog-entry-197.html
 http://dev.classmethod.jp/etc/macbookair-homebrew-mysql5-5-14/

MySQLが起動できない

homebrewでMySQLをインストールすることはできましたが、サーバ起動でエラーになります。MBPのLion(MacOS10.7.4)です。

$ mysql.server start
Starting MySQL
......... ERROR! The server quit without updating PID file (/usr/local/var/mysql/hogehoge.pid).

その前に unknown variable 'mysql.default_socket=/tmp/mysql.sock'エラーも出てます。


$ mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
Installing MySQL system tables...
120824 14:31:55 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
120824 14:31:55 [ERROR] Aborting

120824 14:31:55 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete

Installation of system tables failed!  Examine the logs in
/usr/local/var/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &

and use the command line tool /usr/local/Cellar/mysql/5.5.25a/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /usr/local/var/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/local/Cellar/mysql/5.5.25a/scripts/mysqlbug script!

なお /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant & の結果は次のように
unknown variable 'mysql.default_socket=/tmp/mysql.sock'となります。

$ /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &
[1] 6762
16:18:03 ~/todo $ 120824 16:18:03 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
120824 16:18:03 InnoDB: The InnoDB memory heap is disabled
120824 16:18:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120824 16:18:03 InnoDB: Compressed tables use zlib 1.2.5
120824 16:18:03 InnoDB: Initializing buffer pool, size = 128.0M
120824 16:18:03 InnoDB: Completed initialization of buffer pool
120824 16:18:03 InnoDB: highest supported file format is Barracuda.
120824 16:18:03  InnoDB: Waiting for the background threads to start
120824 16:18:04 InnoDB: 1.1.8 started; log sequence number 1595675
120824 16:18:04 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
120824 16:18:04 [ERROR] Aborting

120824 16:18:04  InnoDB: Starting shutdown...
120824 16:18:05  InnoDB: Shutdown completed; log sequence number 1595675
120824 16:18:05 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete

また以前に中途半端にdmgでインストールしようとした事はありました。
システム環境設定に「MySQL」が残っていて /usr/local/mysql/bin/mysqladminを呼んでいたので

$ cd /usr/local 
$ ln -s /usr/local/Cellar/mysql/5.5.25a mysql

でリンクを作って、「Start MySQL Server」ボタンを押せるようにして押しても

The MySQL Server Instance is stopped 

のままびくともしません。

エラーログまわりの設定が必要なのかもしれませんが、Lionでのエラーログの正しい場所が
Linuxでの/var/log/mysql/error.log とは違うのだろうなとは思いつつ良く解っていません。

ご教示のほどよろしくお願い致します。

tmtmsさんのご指摘で再トライの結果

$ /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant & 
[1] 12595
$ 120824 18:11:30 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
120824 18:11:30 InnoDB: The InnoDB memory heap is disabled
120824 18:11:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120824 18:11:30 InnoDB: Compressed tables use zlib 1.2.5
120824 18:11:30 InnoDB: Initializing buffer pool, size = 128.0M
120824 18:11:30 InnoDB: Completed initialization of buffer pool
120824 18:11:30 InnoDB: highest supported file format is Barracuda.
120824 18:11:30  InnoDB: Waiting for the background threads to start
120824 18:11:31 InnoDB: 1.1.8 started; log sequence number 1595675
120824 18:11:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120824 18:11:31 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120824 18:11:31 [Note] Server socket created on IP: '0.0.0.0'.
120824 18:11:31 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
120824 18:11:31 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
120824 18:11:31 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: ready for connections.
Version: '5.5.25a'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

$ /usr/local/Cellar/mysql/5.5.25a/bin/mysql -u root mysql
/usr/local/Cellar/mysql/5.5.25a/bin/mysql: unknown variable 'mysql.default_socket=/tmp/mysql.sock'

【参考】
http://tukaikta.blog135.fc2.com/blog-entry-197.html
http://dev.classmethod.jp/etc/macbookair-homebrew-mysql5-5-14/

homebrewでMySQLをインストールすることはできましたが、サーバ起動でエラーになります。MBPのLion(MacOS10.7.4)です。

```
$ mysql.server start
Starting MySQL
......... ERROR! The server quit without updating PID file (/usr/local/var/mysql/hogehoge.pid).
```

その前に `unknown variable 'mysql.default_socket=/tmp/mysql.sock'`エラーも出てます。

```

$ mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
Installing MySQL system tables...
120824 14:31:55 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
120824 14:31:55 [ERROR] Aborting

120824 14:31:55 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete

Installation of system tables failed!  Examine the logs in
/usr/local/var/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &

and use the command line tool /usr/local/Cellar/mysql/5.5.25a/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /usr/local/var/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/local/Cellar/mysql/5.5.25a/scripts/mysqlbug script!

```
なお /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant & の結果は次のように
unknown variable 'mysql.default_socket=/tmp/mysql.sock'となります。

```
$ /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &
[1] 6762
16:18:03 ~/todo $ 120824 16:18:03 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
120824 16:18:03 InnoDB: The InnoDB memory heap is disabled
120824 16:18:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120824 16:18:03 InnoDB: Compressed tables use zlib 1.2.5
120824 16:18:03 InnoDB: Initializing buffer pool, size = 128.0M
120824 16:18:03 InnoDB: Completed initialization of buffer pool
120824 16:18:03 InnoDB: highest supported file format is Barracuda.
120824 16:18:03  InnoDB: Waiting for the background threads to start
120824 16:18:04 InnoDB: 1.1.8 started; log sequence number 1595675
120824 16:18:04 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
120824 16:18:04 [ERROR] Aborting

120824 16:18:04  InnoDB: Starting shutdown...
120824 16:18:05  InnoDB: Shutdown completed; log sequence number 1595675
120824 16:18:05 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete

```

また以前に中途半端にdmgでインストールしようとした事はありました。
システム環境設定に「MySQL」が残っていて /usr/local/mysql/bin/mysqladminを呼んでいたので

```
$ cd /usr/local 
$ ln -s /usr/local/Cellar/mysql/5.5.25a mysql
```

でリンクを作って、「Start MySQL Server」ボタンを押せるようにして押しても

```
The MySQL Server Instance is stopped 
```

のままびくともしません。

エラーログまわりの設定が必要なのかもしれませんが、Lionでのエラーログの正しい場所が
Linuxでの/var/log/mysql/error.log とは違うのだろうなとは思いつつ良く解っていません。

ご教示のほどよろしくお願い致します。

tmtmsさんのご指摘で再トライの結果

```
$ /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant & 
[1] 12595
$ 120824 18:11:30 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
120824 18:11:30 InnoDB: The InnoDB memory heap is disabled
120824 18:11:30 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120824 18:11:30 InnoDB: Compressed tables use zlib 1.2.5
120824 18:11:30 InnoDB: Initializing buffer pool, size = 128.0M
120824 18:11:30 InnoDB: Completed initialization of buffer pool
120824 18:11:30 InnoDB: highest supported file format is Barracuda.
120824 18:11:30  InnoDB: Waiting for the background threads to start
120824 18:11:31 InnoDB: 1.1.8 started; log sequence number 1595675
120824 18:11:31 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120824 18:11:31 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120824 18:11:31 [Note] Server socket created on IP: '0.0.0.0'.
120824 18:11:31 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
120824 18:11:31 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
120824 18:11:31 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
120824 18:11:31 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: ready for connections.
Version: '5.5.25a'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

$ /usr/local/Cellar/mysql/5.5.25a/bin/mysql -u root mysql
/usr/local/Cellar/mysql/5.5.25a/bin/mysql: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
 
```

【参考】
http://tukaikta.blog135.fc2.com/blog-entry-197.html
http://dev.classmethod.jp/etc/macbookair-homebrew-mysql5-5-14/

エラー情報追加

40
本文
 you do mail us, you MUST use the /usr/local/Cellar/mysql/5.5.25a/scripts/mysqlbug script!
 
 ```
+なお /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant & の結果は次のように
+unknown variable 'mysql.default_socket=/tmp/mysql.sock'となります。
 
-以前に中途半端にdmgでインストールしようとした事はありました。
+```
+$ /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &
+[1] 6762
+16:18:03 ~/todo $ 120824 16:18:03 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
+120824 16:18:03 InnoDB: The InnoDB memory heap is disabled
+120824 16:18:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
+120824 16:18:03 InnoDB: Compressed tables use zlib 1.2.5
+120824 16:18:03 InnoDB: Initializing buffer pool, size = 128.0M
+120824 16:18:03 InnoDB: Completed initialization of buffer pool
+120824 16:18:03 InnoDB: highest supported file format is Barracuda.
+120824 16:18:03  InnoDB: Waiting for the background threads to start
+120824 16:18:04 InnoDB: 1.1.8 started; log sequence number 1595675
+120824 16:18:04 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
+120824 16:18:04 [ERROR] Aborting
+
+120824 16:18:04  InnoDB: Starting shutdown...
+120824 16:18:05  InnoDB: Shutdown completed; log sequence number 1595675
+120824 16:18:05 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete
+
+```
+
+また以前に中途半端にdmgでインストールしようとした事はありました。
 システム環境設定に「MySQL」が残っていて /usr/local/mysql/bin/mysqladminを呼んでいたので
 
 ```

MySQLが起動できない

homebrewでMySQLをインストールすることはできましたが、サーバ起動でエラーになります。MBPのLion(MacOS10.7.4)です。

$ mysql.server start
Starting MySQL
......... ERROR! The server quit without updating PID file (/usr/local/var/mysql/hogehoge.pid).

その前に unknown variable 'mysql.default_socket=/tmp/mysql.sock'エラーも出てます。


$ mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
Installing MySQL system tables...
120824 14:31:55 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
120824 14:31:55 [ERROR] Aborting

120824 14:31:55 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete

Installation of system tables failed!  Examine the logs in
/usr/local/var/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &

and use the command line tool /usr/local/Cellar/mysql/5.5.25a/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /usr/local/var/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/local/Cellar/mysql/5.5.25a/scripts/mysqlbug script!

なお /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant & の結果は次のように
unknown variable 'mysql.default_socket=/tmp/mysql.sock'となります。

$ /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &
[1] 6762
16:18:03 ~/todo $ 120824 16:18:03 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
120824 16:18:03 InnoDB: The InnoDB memory heap is disabled
120824 16:18:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120824 16:18:03 InnoDB: Compressed tables use zlib 1.2.5
120824 16:18:03 InnoDB: Initializing buffer pool, size = 128.0M
120824 16:18:03 InnoDB: Completed initialization of buffer pool
120824 16:18:03 InnoDB: highest supported file format is Barracuda.
120824 16:18:03  InnoDB: Waiting for the background threads to start
120824 16:18:04 InnoDB: 1.1.8 started; log sequence number 1595675
120824 16:18:04 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
120824 16:18:04 [ERROR] Aborting

120824 16:18:04  InnoDB: Starting shutdown...
120824 16:18:05  InnoDB: Shutdown completed; log sequence number 1595675
120824 16:18:05 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete

また以前に中途半端にdmgでインストールしようとした事はありました。
システム環境設定に「MySQL」が残っていて /usr/local/mysql/bin/mysqladminを呼んでいたので

$ cd /usr/local 
$ ln -s /usr/local/Cellar/mysql/5.5.25a mysql

でリンクを作って、「Start MySQL Server」ボタンを押せるようにして押しても

The MySQL Server Instance is stopped 

のままびくともしません。

エラーログまわりの設定が必要なのかもしれませんが、Lionでのエラーログの正しい場所が
Linuxでの/var/log/mysql/error.log とは違うのだろうなとは思いつつ良く解っていません。

ご教示のほどよろしくお願い致します。

【参考】
http://tukaikta.blog135.fc2.com/blog-entry-197.html
http://dev.classmethod.jp/etc/macbookair-homebrew-mysql5-5-14/

homebrewでMySQLをインストールすることはできましたが、サーバ起動でエラーになります。MBPのLion(MacOS10.7.4)です。

```
$ mysql.server start
Starting MySQL
......... ERROR! The server quit without updating PID file (/usr/local/var/mysql/hogehoge.pid).
```

その前に `unknown variable 'mysql.default_socket=/tmp/mysql.sock'`エラーも出てます。

```

$ mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
Installing MySQL system tables...
120824 14:31:55 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
120824 14:31:55 [ERROR] Aborting

120824 14:31:55 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete

Installation of system tables failed!  Examine the logs in
/usr/local/var/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &

and use the command line tool /usr/local/Cellar/mysql/5.5.25a/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /usr/local/var/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/local/Cellar/mysql/5.5.25a/scripts/mysqlbug script!

```
なお /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant & の結果は次のように
unknown variable 'mysql.default_socket=/tmp/mysql.sock'となります。

```
$ /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &
[1] 6762
16:18:03 ~/todo $ 120824 16:18:03 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
120824 16:18:03 InnoDB: The InnoDB memory heap is disabled
120824 16:18:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120824 16:18:03 InnoDB: Compressed tables use zlib 1.2.5
120824 16:18:03 InnoDB: Initializing buffer pool, size = 128.0M
120824 16:18:03 InnoDB: Completed initialization of buffer pool
120824 16:18:03 InnoDB: highest supported file format is Barracuda.
120824 16:18:03  InnoDB: Waiting for the background threads to start
120824 16:18:04 InnoDB: 1.1.8 started; log sequence number 1595675
120824 16:18:04 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
120824 16:18:04 [ERROR] Aborting

120824 16:18:04  InnoDB: Starting shutdown...
120824 16:18:05  InnoDB: Shutdown completed; log sequence number 1595675
120824 16:18:05 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete

```

また以前に中途半端にdmgでインストールしようとした事はありました。
システム環境設定に「MySQL」が残っていて /usr/local/mysql/bin/mysqladminを呼んでいたので

```
$ cd /usr/local 
$ ln -s /usr/local/Cellar/mysql/5.5.25a mysql
```

でリンクを作って、「Start MySQL Server」ボタンを押せるようにして押しても

```
The MySQL Server Instance is stopped 
```

のままびくともしません。

エラーログまわりの設定が必要なのかもしれませんが、Lionでのエラーログの正しい場所が
Linuxでの/var/log/mysql/error.log とは違うのだろうなとは思いつつ良く解っていません。

ご教示のほどよろしくお願い致します。

【参考】
http://tukaikta.blog135.fc2.com/blog-entry-197.html
http://dev.classmethod.jp/etc/macbookair-homebrew-mysql5-5-14/

質問を投稿

MySQLが起動できない

homebrewでMySQLをインストールすることはできましたが、サーバ起動でエラーになります。MBPのLion(MacOS10.7.4)です。

$ mysql.server start
Starting MySQL
......... ERROR! The server quit without updating PID file (/usr/local/var/mysql/hogehoge.pid).

その前に unknown variable 'mysql.default_socket=/tmp/mysql.sock'エラーも出てます。


$ mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
Installing MySQL system tables...
120824 14:31:55 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
120824 14:31:55 [ERROR] Aborting

120824 14:31:55 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete

Installation of system tables failed!  Examine the logs in
/usr/local/var/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &

and use the command line tool /usr/local/Cellar/mysql/5.5.25a/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /usr/local/var/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/local/Cellar/mysql/5.5.25a/scripts/mysqlbug script!

以前に中途半端にdmgでインストールしようとした事はありました。
システム環境設定に「MySQL」が残っていて /usr/local/mysql/bin/mysqladminを呼んでいたので

$ cd /usr/local 
$ ln -s /usr/local/Cellar/mysql/5.5.25a mysql

でリンクを作って、「Start MySQL Server」ボタンを押せるようにして押しても

The MySQL Server Instance is stopped 

のままびくともしません。

エラーログまわりの設定が必要なのかもしれませんが、Lionでのエラーログの正しい場所が
Linuxでの/var/log/mysql/error.log とは違うのだろうなとは思いつつ良く解っていません。

ご教示のほどよろしくお願い致します。

【参考】
http://tukaikta.blog135.fc2.com/blog-entry-197.html
http://dev.classmethod.jp/etc/macbookair-homebrew-mysql5-5-14/

homebrewでMySQLをインストールすることはできましたが、サーバ起動でエラーになります。MBPのLion(MacOS10.7.4)です。

```
$ mysql.server start
Starting MySQL
......... ERROR! The server quit without updating PID file (/usr/local/var/mysql/hogehoge.pid).
```

その前に `unknown variable 'mysql.default_socket=/tmp/mysql.sock'`エラーも出てます。

```

$ mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
Installing MySQL system tables...
120824 14:31:55 [ERROR] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: unknown variable 'mysql.default_socket=/tmp/mysql.sock'
120824 14:31:55 [ERROR] Aborting

120824 14:31:55 [Note] /usr/local/Cellar/mysql/5.5.25a/bin/mysqld: Shutdown complete

Installation of system tables failed!  Examine the logs in
/usr/local/var/mysql for more information.

You can try to start the mysqld daemon with:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysqld --skip-grant &

and use the command line tool /usr/local/Cellar/mysql/5.5.25a/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /usr/local/Cellar/mysql/5.5.25a/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /usr/local/var/mysql that may be helpful.

Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS.  Another information source are the
MySQL email archives available at http://lists.mysql.com/.

Please check all of the above before mailing us!  And remember, if
you do mail us, you MUST use the /usr/local/Cellar/mysql/5.5.25a/scripts/mysqlbug script!

```

以前に中途半端にdmgでインストールしようとした事はありました。
システム環境設定に「MySQL」が残っていて /usr/local/mysql/bin/mysqladminを呼んでいたので

```
$ cd /usr/local 
$ ln -s /usr/local/Cellar/mysql/5.5.25a mysql
```

でリンクを作って、「Start MySQL Server」ボタンを押せるようにして押しても

```
The MySQL Server Instance is stopped 
```

のままびくともしません。

エラーログまわりの設定が必要なのかもしれませんが、Lionでのエラーログの正しい場所が
Linuxでの/var/log/mysql/error.log とは違うのだろうなとは思いつつ良く解っていません。

ご教示のほどよろしくお願い致します。

【参考】
http://tukaikta.blog135.fc2.com/blog-entry-197.html
http://dev.classmethod.jp/etc/macbookair-homebrew-mysql5-5-14/