はじめに
brew search mysqlでモジュールを確認
MBA2014:~ ujpadmin$ 🆑brew search mysql
automysqlbackup mysql++ mysql-sandbox
homebrew/versions/mysql55 mysql-cluster mysql-search-replace
homebrew/versions/mysql56🈁 mysql-connector-c mysqltuner
mysql mysql-connector-c++
MBA2014:~ ujpadmin$
- 今回は，musql56モジュールをインストールするので，情報を確認．
MBA2014:~ ujpadmin$ 🆑brew info homebrew/versions/mysql56
homebrew/versions/mysql56: stable 5.6.31 (bottled)🈁
Open source relational database management system
https://dev.mysql.com/doc/refman/5.6/en/
Conflicts with: mariadb, mysql-cluster, mysql-connector-c, percona-server
Not installed
From: https://github.com/Homebrew/homebrew-versions/blob/master/mysql56.rb
==> Dependencies
Build: cmake ✘🈁
Required: openssl ✔
==> Options
--universal
Build a universal binary
--with-archive-storage-engine
Compile with the ARCHIVE storage engine enabled
--with-blackhole-storage-engine
Compile with the BLACKHOLE storage engine enabled
--with-debug
Build with debug support
--with-embedded
Build the embedded server
--with-local-infile
Build with local infile loading support
--with-memcached
Enable innodb-memcached support
--with-tests
Build with unit tests
==> Caveats
A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.
To connect:
mysql -uroot
To have launchd start homebrew/versions/mysql56 now and restart at login:
brew services start homebrew/versions/mysql56
Or, if you don't want/need a background service you can just run:
/usr/local/opt/mysql56/bin/mysql.server start
MBA2014:~ ujpadmin$
インストールする．
MBA2014:~ ujpadmin$ 🆑brew install homebrew/versions/mysql56
==> Installing mysql56 from homebrew/versions
==> Downloading https://homebrew.bintray.com/bottles-versions/mysql56-5.6.31.yosemite.bottle.ta
######################################################################## 100.0%
==> Pouring mysql56-5.6.31.yosemite.bottle.tar.gz
==> /usr/local/Cellar/mysql56/5.6.31/bin/mysql_install_db --verbose --user=ujpadmin --basedir=/
==> Caveats
A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.
To connect:
mysql -uroot
To have launchd start homebrew/versions/mysql56 now and restart at login:
brew services start homebrew/versions/mysql56🈁
Or, if you don't want/need a background service you can just run:
/usr/local/opt/mysql56/bin/mysql.server start🈁
==> Summary
🍺 /usr/local/Cellar/mysql56/5.6.31: 9,979 files, 314.3M
MBA2014:~ ujpadmin$
/usr/local/opt/mysql56/bin/mysql.server start
MBA2014:redmine ujpadmin$ 🆑/usr/local/opt/mysql56/bin/mysql.server start
Starting MySQL
.. SUCCESS!
MBA2014:redmine ujpadmin$
MBA2014:redmine ujpadmin$ 🆑ps -ef|grep mysql
240633758 15725 1 0 2:39PM ttys003 0:00.02 /bin/sh /usr/local/Cellar/mysql56/5.6.31/bin/mysqld_safe
--datadir=/usr/local/var/mysql --pid-file=/usr/local/var/mysql/MBA2014.local.pid
240633758 15823 15725 0 2:39PM ttys003 0:00.47 /usr/local/Cellar/mysql56/5.6.31/bin/mysqld
--basedir=/usr/local/Cellar/mysql56/5.6.31 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/
mysql56/5.6.31/lib/plugin --log-error=/usr/local/var/mysql/MBA2014.local.err --pid-file=/usr/local/var/mysql/
MBA2014.local.pid
240633758 15854 81146 0 2:39PM ttys003 0:00.00 grep mysql
MBA2014:redmine ujpadmin$
MBA2014:redmine ujpadmin$ 🆑mysql -uroot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.31 Homebrew🈁
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> 🆑quit
Bye🈁
MBA2014:redmine ujpadmin$
/usr/local/opt/mysql56/bin/mysql.server stop
MBA2014:redmine ujpadmin$ 🆑/usr/local/opt/mysql56/bin/mysql.server stop
Shutting down MySQL
.. SUCCESS!
MBA2014:redmine ujpadmin$ 🆑ps -ef|grep mysql
240633758 16609 81146 0 2:42PM ttys003 0:00.00 grep mysql
MBA2014:redmine ujpadmin$
