質問編集履歴
12
内容追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -161,7 +161,7 @@
|
|
|
161
161
|
|
|
162
162
|
```
|
|
163
163
|
|
|
164
|
-
###
|
|
164
|
+
### 上記のmy.cnf 中身をすべて確認
|
|
165
165
|
```
|
|
166
166
|
nekonoMacBook-Air:~ neko$ cat /usr/local/etc/my.cnf | grep caching_sha2_password
|
|
167
167
|
nekonoMacBook-Air:~ neko$ cat /usr/local/Cellar/mysql@5.6/5.6.43/my.cnf| grep caching_sha2_password
|
11
内容追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -147,6 +147,32 @@
|
|
|
147
147
|
==> Successfully started `mysql@5.6` (label: homebrew.mxcl.mysql@5.6)
|
|
148
148
|
```
|
|
149
149
|
|
|
150
|
+
|
|
151
|
+
|
|
152
|
+
### find / -name "my.cnf" -ls 2>/dev/null
|
|
153
|
+
```
|
|
154
|
+
3976441 8 -rw-r--r-- 1 neko admin 113 9 19 20:58 /usr/local/etc/my.cnf
|
|
155
|
+
3976443 8 -rw-r--r-- 1 neko staff 943 9 19 20:58 /usr/local/Cellar/mysql@5.6/5.6.43/my.cnf
|
|
156
|
+
3976187 8 -rw-r--r-- 1 neko staff 113 12 21 2018 /usr/local/Cellar/mysql@5.6/5.6.43/.bottle/etc/my.cnf
|
|
157
|
+
2607770 8 -rw-r--r-- 1 neko staff 202 7 21 09:04 /Users/neko/lara/laradock/mariadb/my.cnf
|
|
158
|
+
2607814 8 -rw-r--r-- 1 neko staff 266 7 21 09:04 /Users/neko/lara/laradock/percona/my.cnf
|
|
159
|
+
2607792 8 -rw-r--r-- 1 neko staff 272 7 21 09:04 /Users/neko/lara/laradock/mysql/my.cnf
|
|
160
|
+
3673914 16 -rw-rw-r-- 1 root admin 5405 9 11 21:26 /Applications/XAMPP/xamppfiles/etc/my.cnf
|
|
161
|
+
|
|
162
|
+
```
|
|
163
|
+
|
|
164
|
+
### ls -l /usr/local/var/
|
|
165
|
+
```
|
|
166
|
+
nekonoMacBook-Air:~ neko$ cat /usr/local/etc/my.cnf | grep caching_sha2_password
|
|
167
|
+
nekonoMacBook-Air:~ neko$ cat /usr/local/Cellar/mysql@5.6/5.6.43/my.cnf| grep caching_sha2_password
|
|
168
|
+
nekonoMacBook-Air:~ neko$ cat /usr/local/Cellar/mysql@5.6/5.6.43/my.cnf | grep caching_sha2_password
|
|
169
|
+
nekonoMacBook-Air:~ neko$ cat /usr/local/Cellar/mysql@5.6/5.6.43/.bottle/etc/my.cnf | grep caching_sha2_password
|
|
170
|
+
nekonoMacBook-Air:~ neko$ cat /Users/neko/lara/laradock/mariadb/my.cnf | grep caching_sha2_password
|
|
171
|
+
nekonoMacBook-Air:~ neko$ cat /Users/neko/lara/laradock/percona/my.cnf | grep caching_sha2_password
|
|
172
|
+
nekonoMacBook-Air:~ neko$ cat /Applications/XAMPP/xamppfiles/etc/my.cnf | grep caching_sha2_password
|
|
173
|
+
```
|
|
174
|
+
|
|
175
|
+
|
|
150
176
|
### 補足情報（FW/ツールのバージョンなど）
|
|
151
177
|
|
|
152
178
|
OS:mac
|
10
brew services restart mysql@5.6追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -139,7 +139,14 @@
|
|
|
139
139
|
|
|
140
140
|
```
|
|
141
141
|
|
|
142
|
+
###brew services restart mysql@5.6
|
|
143
|
+
```
|
|
142
144
|
|
|
145
|
+
Stopping `mysql@5.6`... (might take a while)
|
|
146
|
+
==> Successfully stopped `mysql@5.6` (label: homebrew.mxcl.mysql@5.6)
|
|
147
|
+
==> Successfully started `mysql@5.6` (label: homebrew.mxcl.mysql@5.6)
|
|
148
|
+
```
|
|
149
|
+
|
|
143
150
|
### 補足情報（FW/ツールのバージョンなど）
|
|
144
151
|
|
|
145
152
|
OS:mac
|
9
brew services start mysql@5.6追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -132,6 +132,14 @@
|
|
|
132
132
|
```
|
|
133
133
|
|
|
134
134
|
|
|
135
|
+
###brew services start mysql@5.6で起動
|
|
136
|
+
```
|
|
137
|
+
|
|
138
|
+
Service `mysql@5.6` already started, use `brew services restart mysql@5.6` to restart.
|
|
139
|
+
|
|
140
|
+
```
|
|
141
|
+
|
|
142
|
+
|
|
135
143
|
### 補足情報（FW/ツールのバージョンなど）
|
|
136
144
|
|
|
137
145
|
OS:mac
|
8
my.cnf追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -122,6 +122,14 @@
|
|
|
122
122
|
drwxr-xr-x 10 neko admin 320 9 19 19:22 mysql
|
|
123
123
|
```
|
|
124
124
|
|
|
125
|
+
###my.cnf
|
|
126
|
+
```
|
|
127
|
+
$ cat /usr/local/etc/my.cnf
|
|
128
|
+
# Default Homebrew MySQL server config
|
|
129
|
+
[mysqld]
|
|
130
|
+
# Only allow connections from localhost
|
|
131
|
+
bind-address = 127.0.0.1
|
|
132
|
+
```
|
|
125
133
|
|
|
126
134
|
|
|
127
135
|
### 補足情報（FW/ツールのバージョンなど）
|
7
内容追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -112,7 +112,7 @@
|
|
|
112
112
|
### ls -l /usr/local/var/mysql/nekonoMacBook-Air.local.pid
|
|
113
113
|
```
|
|
114
114
|
|
|
115
|
-
|
|
115
|
+
ls: /usr/local/var/mysql/nekonoMacBook-Air.local.pid: No such file or directory
|
|
116
116
|
```
|
|
117
117
|
|
|
118
118
|
### ls -l /usr/local/var/
|
6
内容追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -109,8 +109,21 @@
|
|
|
109
109
|
... ERROR! The server quit without updating PID file (/usr/local/var/mysql/nekonoMacBook-Air.local.pid).
|
|
110
110
|
```
|
|
111
111
|
|
|
112
|
+
### ls -l /usr/local/var/mysql/nekonoMacBook-Air.local.pid
|
|
113
|
+
```
|
|
112
114
|
|
|
115
|
+
-bash: $: command not found
|
|
116
|
+
```
|
|
113
117
|
|
|
118
|
+
### ls -l /usr/local/var/
|
|
119
|
+
```
|
|
120
|
+
total 0
|
|
121
|
+
drwxrwxr-x 4 neko admin 128 9 18 05:03 homebrew
|
|
122
|
+
drwxr-xr-x 10 neko admin 320 9 19 19:22 mysql
|
|
123
|
+
```
|
|
124
|
+
|
|
125
|
+
|
|
126
|
+
|
|
114
127
|
### 補足情報（FW/ツールのバージョンなど）
|
|
115
128
|
|
|
116
129
|
OS:mac
|
5
内容追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -101,6 +101,13 @@
|
|
|
101
101
|
42424 0 homebrew.mxcl.mysql@5.6
|
|
102
102
|
```
|
|
103
103
|
|
|
104
|
+
### mysql.server start
|
|
105
|
+
sudo rm -rf /usr/local/var/mysqlを行ってアンインストール＝＞インストールしても下記エラー
|
|
106
|
+
|
|
107
|
+
```
|
|
108
|
+
Starting MySQL
|
|
109
|
+
... ERROR! The server quit without updating PID file (/usr/local/var/mysql/nekonoMacBook-Air.local.pid).
|
|
110
|
+
```
|
|
104
111
|
|
|
105
112
|
|
|
106
113
|
|
4
内容追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -76,7 +76,31 @@
|
|
|
76
76
|
/etc/my.cnf /etc/mysql/my.cnf /usr/local/etc/my.cnf ~/.my.cnf
|
|
77
77
|
```
|
|
78
78
|
|
|
79
|
+
### mysqlアンインストールコマンド（上から順に実行）
|
|
79
80
|
|
|
81
|
+
```
|
|
82
|
+
$ brew uninstall mysql@5.6
|
|
83
|
+
|
|
84
|
+
$ rm -rf /usr/local/var/mysql
|
|
85
|
+
$ rm -rf /usr/local/var/mysql56/
|
|
86
|
+
|
|
87
|
+
$ brew install mysql@5.6
|
|
88
|
+
|
|
89
|
+
$ echo 'export PATH="/usr/local/opt/mysql@5.6/bin:$PATH"' >> ~/.bash_profile
|
|
90
|
+
$ . ~/.bash_profile
|
|
91
|
+
|
|
92
|
+
$ mysql.server start
|
|
93
|
+
=>Starting MySQL
|
|
94
|
+
... ERROR! The server quit without updating PID file (/usr/local/var/mysql/nekonoMacBook-Air.local.pid).
|
|
95
|
+
$ mysql.server stop
|
|
96
|
+
=>ERROR! MySQL server PID file could not be found!
|
|
97
|
+
|
|
98
|
+
$ brew services start mysql@5.6
|
|
99
|
+
|
|
100
|
+
$ launchctl list | grep mysql
|
|
101
|
+
42424 0 homebrew.mxcl.mysql@5.6
|
|
102
|
+
```
|
|
103
|
+
|
|
80
104
|
|
|
81
105
|
|
|
82
106
|
|
3
内容追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -69,8 +69,17 @@
|
|
|
69
69
|
/usr/local/opt/mysql@5.6/bin/mysql
|
|
70
70
|
```
|
|
71
71
|
|
|
72
|
+
### mysql --help | grep my.cnf
|
|
72
73
|
|
|
74
|
+
```
|
|
75
|
+
order of preference, my.cnf, $MYSQL_TCP_PORT,
|
|
76
|
+
/etc/my.cnf /etc/mysql/my.cnf /usr/local/etc/my.cnf ~/.my.cnf
|
|
77
|
+
```
|
|
73
78
|
|
|
79
|
+
|
|
80
|
+
|
|
81
|
+
|
|
82
|
+
|
|
74
83
|
### 補足情報（FW/ツールのバージョンなど）
|
|
75
84
|
|
|
76
85
|
OS:mac
|
2
内容追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -23,9 +23,9 @@
|
|
|
23
23
|
### 試したこと
|
|
24
24
|
PATHの設定は行いました。
|
|
25
25
|
```ここに言語を入力
|
|
26
|
-
echo 'export PATH="/usr/local/opt/mysql@5.6/bin:$PATH"' >> ~/.
|
|
26
|
+
echo 'export PATH="/usr/local/opt/mysql@5.6/bin:$PATH"' >> ~/.bash_profile
|
|
27
27
|
```
|
|
28
|
-
my.cnfを削除するため下記をコマンドを実行後に再度バージョン指定でインストール後、brew services start mysql@5.6を実行してからmysql -u rootを行っても表題の結果です。
|
|
28
|
+
my.cnfを削除するため下記をコマンドを実行後に再度バージョン指定(brew search mysql@5.6)でインストール後、brew services start mysql@5.6を実行してからmysql -u rootを行っても表題の結果です。
|
|
29
29
|
|
|
30
30
|
|
|
31
31
|
###my.cnfを削除するためのコマンド（rmの前にsudoが付いてましたが外して実行してます。）
|
|
@@ -39,6 +39,38 @@
|
|
|
39
39
|
rm -rf /etc/my.cnf
|
|
40
40
|
```
|
|
41
41
|
|
|
42
|
+
|
|
43
|
+
### ls -l /usr/local/Cellar/mysql*
|
|
44
|
+
|
|
45
|
+
```
|
|
46
|
+
total 0
|
|
47
|
+
drwxr-xr-x 17 neko staff 544 9 17 20:10 5.6.43
|
|
48
|
+
|
|
49
|
+
```
|
|
50
|
+
|
|
51
|
+
|
|
52
|
+
### echo $PATH
|
|
53
|
+
|
|
54
|
+
```
|
|
55
|
+
/usr/local/opt/mysql@5.6/bin:/usr/local/opt/mysql@5.6/bin:/usr/local/opt/mysql@5.6/bin:/usr/local/opt/mysql@5.6/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin
|
|
56
|
+
```
|
|
57
|
+
|
|
58
|
+
|
|
59
|
+
### cat /etc/mysql/my.cnf
|
|
60
|
+
|
|
61
|
+
```
|
|
62
|
+
cat: /etc/mysql/my.cnf: No such file or directory
|
|
63
|
+
```
|
|
64
|
+
|
|
65
|
+
|
|
66
|
+
### which mysql
|
|
67
|
+
|
|
68
|
+
```
|
|
69
|
+
/usr/local/opt/mysql@5.6/bin/mysql
|
|
70
|
+
```
|
|
71
|
+
|
|
72
|
+
|
|
73
|
+
|
|
42
74
|
### 補足情報（FW/ツールのバージョンなど）
|
|
43
75
|
|
|
44
76
|
OS:mac
|
1
エラー編集
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -25,8 +25,19 @@
|
|
|
25
25
|
```ここに言語を入力
|
|
26
26
|
echo 'export PATH="/usr/local/opt/mysql@5.6/bin:$PATH"' >> ~/.bash_profil
|
|
27
27
|
```
|
|
28
|
+
my.cnfを削除するため下記をコマンドを実行後に再度バージョン指定でインストール後、brew services start mysql@5.6を実行してからmysql -u rootを行っても表題の結果です。
|
|
28
29
|
|
|
29
30
|
|
|
31
|
+
###my.cnfを削除するためのコマンド（rmの前にsudoが付いてましたが外して実行してます。）
|
|
32
|
+
```ここに言語を入力
|
|
33
|
+
rm -rf /usr/local/Cellar/mysql*
|
|
34
|
+
rm -rf /usr/local/bin/mysql*
|
|
35
|
+
rm -rf /usr/local/var/mysql*
|
|
36
|
+
rm -rf /usr/local/etc/my.cnf
|
|
37
|
+
rm -rf /usr/local/share/mysql*
|
|
38
|
+
rm -rf /usr/local/opt/mysql*
|
|
39
|
+
rm -rf /etc/my.cnf
|
|
40
|
+
```
|
|
30
41
|
|
|
31
42
|
### 補足情報（FW/ツールのバージョンなど）
|
|
32
43
|
|