Snow Leopard にMacPortsでMySQL 5.1.44をインストール

mac mysql

実行環境

インストール

$ sudo port install mysql5-server

MySQL設定ファイル編集

$ sudo cp /opt/local/share/mysql5/mysql/my-medium.cnf /opt/local/etc/mysql5/my.cnf
$ sudo vi /opt/local/etc/mysql5/my.cnf
##[client]の項目へ追加
[client]
default-character-set=utf8
##[mysqld]の項目へ追加
[mysqld]
default-character-set = utf8
skip-character-set-client-handshake
character-set-server = utf8
collation-server = utf8_general_ci
init-connect = SET NAMES utf8
##[mysqldump]の項目へ追加
[mysqldump]
default-character-set=utf8
##[mysql]の項目へ追加
[mysql]
default-character-set=utf8

初期化

$ sudo -u mysql mysql_install_db5

MySQL起動

$ sudo /opt/local/share/mysql5/mysql/mysql.server start

MySQLのrootアカウントのパスワードを設定

$ /opt/local/lib/mysql5/bin/mysqladmin -u root password 'new-password'
$ /opt/local/lib/mysql5/bin/mysqladmin -u root -h [$hostname].local password 'new-password'

MySQLにPATHを通す

$ vi ~/.bash_profile
# MySQL
export PATH=/opt/local/lib/mysql5/bin:$PATH
:wq

rootのパスワードを設定

$ mysql -u root -p
mysql> select user,host,password from mysql.user;
mysql> set password for root@'$[hostname].local'=password('パスワード');
mysql> set password for root@'127.0.0.1'=password('パスワード');
mysql> exit

MySQL停止

$ sudo /opt/local/share/mysql5/mysql/mysql.server stop

launchd経由で起動

$ sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist

launchd経由で停止

$ sudo launchctl unload -w /Library/LaunchDaemons/org.macports.mysql5.plist

起動・停止エイリアスの設定

$ vi ~/.bash_profile
alias mysql_start="sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist"
alias mysql_stop="sudo launchctl unload -w /Library/LaunchDaemons/org.macports.mysql5.plist"
:wq