brew search mysqlでモジュールを確認
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が必要と出ている.
インストールする.
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$
停止した.
Counter: 1422,
today: 2,
yesterday: 0
最終更新: 2016-07-18 (月) 20:58:47 (JST) (2800d) by shinnai(shinnai)