MySQLをMacに入れる時につまづきすぎた

MySQL

同じ記事ばっかり書いてるみたいですが、多少は違います

$ sudo rm -rf /usr/local/var/mysql
$ sudo brew uninstall mysql
$ vi /etc/my.cnf

[mysqld]
basedir = /usr/local/Cellar/mysql/5.1.54
datadir = /usr/local/var/mysql
socket = /tmp/mysql.sock
#user = mysql
#old_passwords = 1

character-set-server = utf8
skip-character-set-client-handshake
#default-character-set = utf8

default-storage-engine=InnoDB

innodb_buffer_pool_size = 1024MB

log-warnings = 1
general_log = /usr/local/Cellar/mysql/5.1.54/log/query.log

slow_query_log = 1
slow-query-log = /usr/local/Cellar/mysql/5.1.54/log/query-slow.log

log-error = /usr/local/Cellar/mysql/5.1.54/log/error.log

[mysqld_safe]
#pid-file = /var/run/mysqld/mysqld.pid

[mysql]
#default-character-set = utf8
no-auto-rehash

[mysqldump]
#default-character-set = utf8
quick
max_allowed_packet = 16M

[client]
socket = /tmp/mysql.sock

$ sudo brew install mysql
$ unset TMPDIR
$ mysql_install_db


↓これだけ別ウィンドウで起動しつつ、下記コマンド実行
$ cd /usr/local/Cellar/mysql/5.1.54 ; /usr/local/Cellar/mysql/5.1.54/bin/mysqld_safe &
↓このコマンド
$ /usr/local/Cellar/mysql/5.1.54/bin/mysql_secure_installation
※表示されてる内容を適当に設定


$ mysql.server start
$ mysql.server stop