Hatena::ブログ(Diary)

Memo

2012-08-14

[][] MacPorts で MySQL5.5 を入れる

新しい Mac を買ったので環境を再構築。


MacPorts*1 で MySQL5.5 を入れようとしてハマったのでメモ。

$ sudo port install mysql55 +openssl +system_readline
--->  Computing dependencies for mysql55
--->  Fetching archive for mysql55
--->  Attempting to fetch mysql55-5.5.27_0+openssl+system_readline.darwin_12.x86_64.tbz2 from http://packages.macports.org/mysql55
--->  Attempting to fetch mysql55-5.5.27_0+openssl+system_readline.darwin_12.x86_64.tbz2 from http://macports.packages.ionic.de/mysql55
--->  Fetching distfiles for mysql55
--->  Verifying checksum(s) for mysql55
--->  Extracting mysql55
--->  Applying patches to mysql55
--->  Configuring mysql55
--->  Building mysql55
--->  Staging mysql55 into destroot
--->  Installing mysql55 @5.5.27_0+openssl+system_readline
The mysql55 client has been installed.
To install the mysql55 server, install the mysql55-server port.
--->  Activating mysql55 @5.5.27_0+openssl+system_readline
--->  Cleaning mysql55
--->  Updating database of binaries: 100.0%
--->  Scanning binaries for linking errors: 100.0%
--->  No broken files found.
$ sudo port install mysql55-server
--->  Computing dependencies for mysql55-server
--->  Fetching archive for mysql55-server
--->  Attempting to fetch mysql55-server-5.5.27_0.darwin_12.noarch.tbz2 from http://packages.macports.org/mysql55-server
--->  Attempting to fetch mysql55-server-5.5.27_0.darwin_12.noarch.tbz2 from http://macports.packages.ionic.de/mysql55-server
--->  Fetching distfiles for mysql55-server
--->  Verifying checksum(s) for mysql55-server
--->  Extracting mysql55-server
--->  Configuring mysql55-server
--->  Building mysql55-server
--->  Staging mysql55-server into destroot
--->  Creating launchd control script
###########################################################
# A startup item has been generated that will aid in
# starting mysql55-server with launchd. It is disabled
# by default. Execute the following command to start it,
# and to cause it to launch at startup:
#
# sudo port load mysql55-server
###########################################################
--->  Installing mysql55-server @5.5.27_0
--->  Activating mysql55-server @5.5.27_0

If this is a new install you might want to run:

$ sudo -u _mysql /opt/local/lib/mysql55/bin/mysql_install_db

--->  Cleaning mysql55-server
--->  Updating database of binaries: 100.0%
--->  Scanning binaries for linking errors: 100.0%
--->  No broken files found.
$ sudo -u _mysql /opt/local/lib/mysql55/bin/mysql_install_db

を実行しろと表示されているが、これをそのまま実行すると…

$ sudo -u _mysql /opt/local/lib/mysql55/bin/mysql_install_db
Installing MySQL system tables...
ERROR: 1005  Can't create table 'tmp_db' (errno: 13)
120814 21:38:26 [ERROR] Aborting

120814 21:38:26 [Note] /opt/local/lib/mysql55/bin/mysqld: Shutdown complete


Installation of system tables failed!  Examine the logs in
/opt/local/var/db/mysql55 for more information.

You can try to start the mysqld daemon with:

    shell> /opt/local/lib/mysql55/bin/mysqld --skip-grant &

and use the command line tool /opt/local/lib/mysql55/bin/mysql
to connect to the mysql database and look at the grant tables:

    shell> /opt/local/lib/mysql55/bin/mysql -u root mysql
    mysql> show tables

Try 'mysqld --help' if you have problems with paths.  Using --log
gives you a log in /opt/local/var/db/mysql55 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 /opt/local/lib/mysql55/bin/mysqlbug script!

とかって言われてエラーになる。

$ sudo -u _mysql /opt/local/lib/mysql55/bin/mysql_install_db --tmpdir=/tmp
Installing MySQL system tables...
OK
Filling help tables...
OK
- 略 -

と --tmpdir をつけると行けた。


後は

$ sudo port load mysql55-server
$ sudo port select mysql mysql55
Selecting 'mysql55' for 'mysql' succeeded. 'mysql55' is now active.

とかして MySQL を起動して、mysql コマンドを使えるようにする。

*1homebrew? /usr 領域を汚すので嫌だから使ってない

スパム対策のためのダミーです。もし見えても何も入力しないでください
ゲスト


画像認証

リンク元