Homebrew/mysql/古い情報
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
&tag(Homebrew/mysql/古い情報);
*目次 [#m3f3f969]
#contents
*関連ページ [#u3547cf9]
*参考情報 [#t0885667]
*5.5.30のインストール(homebrew-versionsを使用) [#bafcf4bc]
-下にある過去のバージョンをcheckoutする方法だと、[[MySQL ...
-[[Homebrew/homebrew-versions · GitHub:https://githu...
brew tap homebrew/versions
brew install mysql55
-以下のインストラクションが表示される。
#pre{{
A "/etc/my.cnf" from another install may interfere with a...
server starting up correctly.
To connect:
mysql -uroot
This formula is keg-only: so it was not symlinked into /u...
Conflicts with mysql, mariadb, percona-server, mysql-clus...
Generally there are no consequences of this for you. If y...
own software and it requires this formula, you'll need to...
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/Laun...
Then to load mysql55 now:
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.m...
Or, if you don't want/need launchctl, you can just run:
mysql.server start
}}
**my.cnfの作成 [#re588cec]
-my.cnfの作成。/usr/locdal/mysql55/bin/mysql --helpによる...
/etc/my.cnf /etc/mysql/my.cnf /usr/local/etc/my.cnf ~/.m...
-ひな形をコピー
$ cp /usr/local/Cellar/mysql55/5.5.30/support-files/my-m...
-文字コードをUTF-8にするなど修正。
#pre{{
[client]
default-character-set=utf8
[mysqldump]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
}}
** 自動起動(brew services) [#z4f24ad5]
- brew services start mysql55
** 自動起動(手動)[#f03ff32c]
- plistをlink
ln -sfv /usr/local/opt/mysql55/*.plist ~/Library/LaunchA...
-launchctlに登録
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysq...
*5.5.29(古いバージョンの)インストール [#s0900ce8]
-バージョンを確認
#pre{{
$ brew versions mysql
5.6.10 git checkout 3bffe56 Library/Formula/mysql.rb
5.5.29 git checkout 336c976 Library/Formula/mysql.rb
5.5.28 git checkout 5825f62 Library/Formula/mysql.rb
5.5.27 git checkout 93aecfa Library/Formula/mysql.rb
}}
-古いバージョンをチェックアウト。例えば5.5.29の場合
#pre{{
$ cd /usr/local
$ git checkout 336c976 Library/Formula/mysql.rb
}}
-インストール
$ brew install mysql
-以下の手順でインストール後の処理を行う
#pre{{
Set up databases to run AS YOUR USER ACCOUNT with:
unset TMPDIR
mysql_install_db --verbose --user=`whoami` --basedir=...
To set up base tables in another folder, or use a differe...
mysqld, view the help for mysql_install_db:
mysql_install_db --help
and view the MySQL documentation:
* http://dev.mysql.com/doc/refman/5.5/en/mysql-install-...
* http://dev.mysql.com/doc/refman/5.5/en/default-privil...
To run as, for instance, user "mysql", you may need to `s...
sudo mysql_install_db ...options...
A "/etc/my.cnf" from another install may interfere with a...
server starting up correctly.
To connect:
mysql -uroot
To have launchd start mysql at login:
ln -sfv /usr/local/opt/mysql/*.plist ~/Library/Launch...
Then to load mysql now:
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.m...
Or, if you don't want/need launchctl, you can just run:
mysql.server start
}}
--データベースをインストールする
$ mysql_install_db --verbose --user=`whoami` --basedir="...
--my.cnfをコピーし、utf-8設定にする。
$ cp /usr/local/Cellar/mysql/5.5.29/support-files/my-me...
--自動起動&起動
$ ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchA...
$ launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl...
終了行:
&tag(Homebrew/mysql/古い情報);
*目次 [#m3f3f969]
#contents
*関連ページ [#u3547cf9]
*参考情報 [#t0885667]
*5.5.30のインストール(homebrew-versionsを使用) [#bafcf4bc]
-下にある過去のバージョンをcheckoutする方法だと、[[MySQL ...
-[[Homebrew/homebrew-versions · GitHub:https://githu...
brew tap homebrew/versions
brew install mysql55
-以下のインストラクションが表示される。
#pre{{
A "/etc/my.cnf" from another install may interfere with a...
server starting up correctly.
To connect:
mysql -uroot
This formula is keg-only: so it was not symlinked into /u...
Conflicts with mysql, mariadb, percona-server, mysql-clus...
Generally there are no consequences of this for you. If y...
own software and it requires this formula, you'll need to...
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/Laun...
Then to load mysql55 now:
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.m...
Or, if you don't want/need launchctl, you can just run:
mysql.server start
}}
**my.cnfの作成 [#re588cec]
-my.cnfの作成。/usr/locdal/mysql55/bin/mysql --helpによる...
/etc/my.cnf /etc/mysql/my.cnf /usr/local/etc/my.cnf ~/.m...
-ひな形をコピー
$ cp /usr/local/Cellar/mysql55/5.5.30/support-files/my-m...
-文字コードをUTF-8にするなど修正。
#pre{{
[client]
default-character-set=utf8
[mysqldump]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
}}
** 自動起動(brew services) [#z4f24ad5]
- brew services start mysql55
** 自動起動(手動)[#f03ff32c]
- plistをlink
ln -sfv /usr/local/opt/mysql55/*.plist ~/Library/LaunchA...
-launchctlに登録
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysq...
*5.5.29(古いバージョンの)インストール [#s0900ce8]
-バージョンを確認
#pre{{
$ brew versions mysql
5.6.10 git checkout 3bffe56 Library/Formula/mysql.rb
5.5.29 git checkout 336c976 Library/Formula/mysql.rb
5.5.28 git checkout 5825f62 Library/Formula/mysql.rb
5.5.27 git checkout 93aecfa Library/Formula/mysql.rb
}}
-古いバージョンをチェックアウト。例えば5.5.29の場合
#pre{{
$ cd /usr/local
$ git checkout 336c976 Library/Formula/mysql.rb
}}
-インストール
$ brew install mysql
-以下の手順でインストール後の処理を行う
#pre{{
Set up databases to run AS YOUR USER ACCOUNT with:
unset TMPDIR
mysql_install_db --verbose --user=`whoami` --basedir=...
To set up base tables in another folder, or use a differe...
mysqld, view the help for mysql_install_db:
mysql_install_db --help
and view the MySQL documentation:
* http://dev.mysql.com/doc/refman/5.5/en/mysql-install-...
* http://dev.mysql.com/doc/refman/5.5/en/default-privil...
To run as, for instance, user "mysql", you may need to `s...
sudo mysql_install_db ...options...
A "/etc/my.cnf" from another install may interfere with a...
server starting up correctly.
To connect:
mysql -uroot
To have launchd start mysql at login:
ln -sfv /usr/local/opt/mysql/*.plist ~/Library/Launch...
Then to load mysql now:
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.m...
Or, if you don't want/need launchctl, you can just run:
mysql.server start
}}
--データベースをインストールする
$ mysql_install_db --verbose --user=`whoami` --basedir="...
--my.cnfをコピーし、utf-8設定にする。
$ cp /usr/local/Cellar/mysql/5.5.29/support-files/my-me...
--自動起動&起動
$ ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchA...
$ launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl...
ページ名: