UJP - 技術情報2 : MySQL5.6.31のインストール HomeBrew/MySQL5.6

Life is fun and easy!

不正IP報告数

Okan Sensor
 
メイン
ログイン
ブログ カテゴリ一覧

Page Top

はじめに anchor.png

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

Page Top

brew search mysqlでモジュールを確認 anchor.png

 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が必要と出ている.

Page Top

インストールする. anchor.png

 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$

 停止した.


トップ   差分 バックアップ 複製 名前変更 リロード   ページ新規作成 全ページ一覧 単語検索 最新ページの一覧   ヘルプ   最新ページのRSS 1.0 最新ページのRSS 2.0 最新ページのRSS Atom
Counter: 1422, today: 2, yesterday: 0
最終更新: 2016-07-18 (月) 20:58:47 (JST) (2800d) by shinnai(shinnai)

広告スペース
Google