UJP - 技術情報2 バックアップ : HomeBrew/MySQL5.6のソース

差分を表示
HomeBrew/MySQL5.6 へ行く。
*MySQL5.6.31のインストール [#tddade4f]

**はじめに [#eae0feed]

　MySQL5.6.31をインストールする手順

**brew search mysqlでモジュールを確認 [#udafe6ba]

　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$

　cmakeが必要と出ている．

**インストールする． [#f9b8b021]

　brewコマンドでインストールする．

 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$

　MySQLモニターを使って接続して切断する．

 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$

　停止した．
« Prev
HomeBrew/MySQL5.6 のバックアップ一覧
HomeBrew/MySQL5.6 のバックアップソース(No. All)
- 1: 2016-07-18 (月) 20:58:47 nobuaki
- 現: 2016-07-18 (月) 20:58:47 shinnai(shinnai)
  - Rewound to 2 ages ago. at 2017-12-04 (月) 23:19:46
Counter: 1610, today: 1, yesterday: 0
MySQL5.6.31のインストール のソース

MySQL5.6.31のインストールのソース
