![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
Tag: Homebrew/mysql/古い情報20220419
brew install mysql
cp /usr/local/Cellar/mysql/5.6.10/support-files/my-default.cnf /usr/local/etc/my.cnf
mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
mysql.server start
mysqladmin -uroot password
brew install mysql@5.5
==> Caveats
A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.
To connect:
/usr/local/opt/mysql@5.5/bin/mysql -uroot
To have launchd start mysql@5.5 now and restart at login:
brew services start mysql@5.5
Or, if you don't want/need a background service you can just run:
/usr/local/opt/mysql55/bin/mysql.server start
==> Summary
/etc/my.cnf /etc/mysql/my.cnf /usr/local/etc/my.cnf ~/.my.cnf
$ cp /usr/local/Cellar/mysql@5.5/5.5.49/support-files/my-medium.cnf /usr/local/etc/my.cnf
[client] default-character-set=utf8 [mysqldump] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] character-set-server=utf8
ln -svf /usr/local/opt/mysql@5.5/*.plist ~/Library/LaunchAgents
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql@5.5.plist
mysql -uUSER -p -e 'SHOW VARIABLES WHERE Variable_Name LIKE "%dir"'
launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.mysql@5.5.plist cd /usr/local/var mv mysql mysql.new mv mysql55 mysql
/usr/local/opt/mysql@5.5/bin
brew tap homebrew/versions brew install mysql55
A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.
To connect:
mysql -uroot
This formula is keg-only, which means it was not symlinked into /usr/local.
Conflicts with mysql, mariadb, percona-server, mysql-cluster, etc.
Generally there are no consequences of this for you. If you build your
own software and it requires this formula, you'll need to add to your
build variables:
LDFLAGS: -L/usr/local/opt/mysql55/lib
CPPFLAGS: -I/usr/local/opt/mysql55/include
To have launchd start mysql55 at login:
ln -sfv /usr/local/opt/mysql55/*.plist ~/Library/LaunchAgents
Then to load mysql55 now:
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql55.plist
Or, if you don't want/need launchctl, you can just run:
mysql.server start
/etc/my.cnf /etc/mysql/my.cnf /usr/local/etc/my.cnf ~/.my.cnf
$ cp /usr/local/Cellar/mysql55/5.5.30/support-files/my-medium.cnf /usr/local/etc/my.cnf
[client] default-character-set=utf8 [mysqldump] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] character-set-server=utf8
ln -sfv /usr/local/opt/mysql55/*.plist ~/Library/LaunchAgents
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql55.plist
brew link mysql55 --force
mysqladmin -uroot password
