編集履歴

質問編集履歴

誤字

2021/01/03 04:28

投稿

kisagi

スコア7

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -200,7 +200,7 @@
-### 2. ERROR! The server quit without updating PID file (/usr/local/var/mysql/Hoge.local.pid).
+### 4. ERROR! The server quit without updating PID file (/usr/local/var/mysql/Hoge.local.pid).

ls /usr/local/var/mysql/*.pidの追加

2021/01/03 04:28

投稿

kisagi

スコア7

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -233,3 +233,17 @@
 2021-01-03T04:17:13.716544Z 0 [ERROR] Aborting
 ```
+- `ls /usr/local/var/mysql/*.pid`
+```
+hoge@Hoge ~ % ls /usr/local/var/mysql/*.pid
+zsh: no matches found: /usr/local/var/mysql/*.pid
+```

質問番号1, 4の修正

2021/01/03 04:26

投稿

kisagi

スコア7

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -6,11 +6,11 @@
-1. my.confが自動で作成されない．
+1. my.cnfが自動で作成されない．
-2. Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
+2. ~~Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) ~~
-3. Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
+3. ~~Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)~~
 4. ERROR! The server quit without updating PID file (/usr/local/var/mysql/Hoge.local.pid).
@@ -158,15 +158,53 @@
-- 手動で作成する
+#### アプローチ
+- `/usr/local/Cellar/mysql@5.7/5.7.32/.bottle/etc/my.cnf`からコピーして`/usr/local/etc/my.cnf`とした．
-```
+```
+hoge@Hoge ~ % find /usr/local/Cellar/mysql@5.7 -name "my*.cnf"
+/usr/local/Cellar/mysql@5.7/5.7.32/.bottle/etc/my.cnf
+hoge@Hoge ~ % cp /usr/local/Cellar/mysql@5.7 /usr/local/etc/my.cnf
-hoge@Hoge ~ % sudo vim /etc/my.cnf
+hoge@Hoge ~ % mysql --help | grep my.cnf
+                      order of preference, my.cnf, $MYSQL_TCP_PORT,
+/etc/my.cnf /etc/mysql/my.cnf /usr/local/etc/my.cnf ~/.my.cnf
+```
-Password:
+#### 参考
+- [Homebrewで入れたMySQLのmy-xxx.cnfの場所とmy.cnfの設置](https://qiita.com/madai0517/items/4df3ac0ce002301c7059)
+### 2. ERROR! The server quit without updating PID file (/usr/local/var/mysql/Hoge.local.pid).
+```
 hoge@Hoge ~ % mysql.server start
@@ -178,360 +216,20 @@
-```
-[mysqld]
-socket=/tmp/mysql.sock
-[client]
-socket=/tmp/mysql.soc
-```
-#### 参考
-- [Homebrewで入れたMySQLのmy-xxx.cnfの場所とmy.cnfの設置](https://qiita.com/madai0517/items/4df3ac0ce002301c7059)
-- [[MySQL] my.cnf の設定方法 (Mac + Homebrew 編)](https://codenote.net/mysql/3579.html)
-- [mampでのmy.cnfファイルの作り方がわかりません(mac)](https://teratail.com/questions/197701)
-- [基礎MySQL ~その２~ my.cnf (設定ファイル)](https://qiita.com/yoheiW@github/items/bcbcd11e89bfc7d7f3ff)
-### 2. Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
 #### エラー詳細
-```
-hoge@Hoge ~ % mysql_secure_installation
-Securing the MySQL server deployment.
-Enter password for user root:
-Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
-```
-#### アプローチ
-```
-hoge@Hoge ~ % sudo touch /tmp/mysql.sock
-Password:
-hoge@Hoge ~ % mysql_secure_installation
-Securing the MySQL server deployment.
-Enter password for user root:
-Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
-```
-#### 参考
-- [mysql起動時でエラーが起きた時の対処](https://qiita.com/makuramoto1/items/52159370d00bef708595)
-### 3. Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
-#### エラー詳細
-```
-hoge@Hoge ~ % mysql_secure_installation
-Securing the MySQL server deployment.
-Enter password for user root:
-Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
-```
-#### アプローチ
-```
-hoge@Hoge ~ % ls -la /tmp/mysql.sock
--rw-r--r--  1 root  _mysql  0  1  2 23:59 /tmp/mysql.sock
-hoge@Hoge ~ % cd /tmp
-hoge@Hoge /tmp % chown -R _mysql:wheel /tmp/mysql.sock
-chown: /tmp/mysql.sock: Operation not permitted
-hoge@Hoge /tmp % sudo chown -R _mysql:wheel /tmp/mysql.sock
-Password:
-hoge@Hoge /tmp % mysql.server start
-Starting MySQL
-./usr/local/Cellar/mysql@5.7/5.7.32/bin/mysqld_safe: line 626: /usr/local/var/mysql/Hoge.local.err: No such file or directory
-Logging to '/usr/local/var/mysql/Hoge.local.err'.
-/usr/local/Cellar/mysql@5.7/5.7.32/bin/mysqld_safe: line 144: /usr/local/var/mysql/Hoge.local.err: No such file or directory
-/usr/local/Cellar/mysql@5.7/5.7.32/bin/mysqld_safe: line 198: /usr/local/var/mysql/Hoge.local.err: No such file or directory
-/usr/local/Cellar/mysql@5.7/5.7.32/bin/mysqld_safe: line 885: /usr/local/var/mysql/Hoge.local.err: No such file or directory
-/usr/local/Cellar/mysql@5.7/5.7.32/bin/mysqld_safe: line 144: /usr/local/var/mysql/Hoge.local.err: No such file or directory
- ERROR! The server quit without updating PID file (/usr/local/var/mysql/Hoge.local.pid).
-hoge@Hoge /tmp % mysql_secure_installation
-Securing the MySQL server deployment.
-Enter password for user root:
-Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
-```
-### 4. ERROR! The server quit without updating PID file (/usr/local/var/mysql/Hoge.local.pid).
-####エラー詳細
-```
-hoge@Hoge /tmp % mysql.server start
-Starting MySQL
-./usr/local/Cellar/mysql@5.7/5.7.32/bin/mysqld_safe: line 626: /usr/local/var/mysql/Hoge.local.err: No such file or directory
-Logging to '/usr/local/var/mysql/Hoge.local.err'.
-/usr/local/Cellar/mysql@5.7/5.7.32/bin/mysqld_safe: line 144: /usr/local/var/mysql/Hoge.local.err: No such file or directory
-/usr/local/Cellar/mysql@5.7/5.7.32/bin/mysqld_safe: line 198: /usr/local/var/mysql/Hoge.local.err: No such file or directory
-/usr/local/Cellar/mysql@5.7/5.7.32/bin/mysqld_safe: line 885: /usr/local/var/mysql/Hoge.local.err: No such file or directory
-/usr/local/Cellar/mysql@5.7/5.7.32/bin/mysqld_safe: line 144: /usr/local/var/mysql/Hoge.local.err: No such file or directory
- ERROR! The server quit without updating PID file (/usr/local/var/mysql/Hoge.local.pid).
-```
-#### アプローチ
-- `/usr/local/var/mysql`を作成すると，ファイルが自動で作成される
-```
-hoge@Hoge % mkdir /usr/local/var/mysql
-hoge@Hoge % ls /usr/local/var/mysql
-Hoge.local.err	ca-key.pem	client-cert.pem	ib_buffer_pool	ib_logfile1	private_key.pem	server-cert.pem
-auto.cnf	ca.pem		client-key.pem	ib_logfile0	ibdata1		public_key.pem	server-key.pem
-hoge@Hoge /tmp % mysql_secure_installation
-Securing the MySQL server deployment.
-Enter password for user root:
-Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
-hoge@Hoge /tmp % mysql.server start
-Starting MySQL
-.. ERROR! The server quit without updating PID file (/usr/local/var/mysql/Hoge.local.pid).
-```
-- PIDファイルを作成してみる
-```
-hoge@Hoge /tmp % touch /usr/local/var/mysql/Hoge.local.pid
-hoge@Hoge /tmp % ls /usr/local/var/mysql/
-Hoge.local.err	ca-key.pem	client-cert.pem	ib_buffer_pool	ib_logfile1	private_key.pem	server-cert.pem
-auto.cnf	ca.pem		client-key.pem	ib_logfile0	ibdata1		public_key.pem	server-key.pem
-hoge@Hoge /tmp % sudo touch /usr/local/var/mysql/Hoge.local.pid
-Password:
-hoge@Hoge /tmp % ls /usr/local/var/mysql/
-Hoge.local.err	auto.cnf	ca.pem		client-key.pem	ib_logfile0	ibdata1		public_key.pem	server-key.pem
-Hoge.local.pid	ca-key.pem	client-cert.pem	ib_buffer_pool	ib_logfile1	private_key.pem	server-cert.pem
-hoge@Hoge /tmp % mysql.server start
-Starting MySQL
-.. ERROR! The server quit without updating PID file (/usr/local/var/mysql/Hoge.local.pid).
-hoge@Hoge /tmp % ls /usr/local/var/mysql/
-Hoge.local.err	ca-key.pem	client-cert.pem	ib_buffer_pool	ib_logfile1	private_key.pem	server-cert.pem
-auto.cnf	ca.pem		client-key.pem	ib_logfile0	ibdata1		public_key.pem	server-key.pem
-```
-## 補足
- - 起動中のプロセスはなし
-```
-hoge@Hoge ~ % ps ax | grep mysql
-16567 s000  S+     0:00.01 grep mysql
-```
-- パスワードを求められる
-```
-hoge@Hoge ~ % mysql_secure_installation
-Securing the MySQL server deployment.
-Enter password for user root:
-Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
-```
-- `/usr/local/var/mysql/Hoge.local.err`
+- `/usr/local/var/mysql/Hoge.local.err`ERROR抜粋
+```
+2021-01-03T04:17:13.707342Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
+2021-01-03T04:17:13.716502Z 0 [ERROR] Could not create unix socket lock file /tmp/mysql.sock.lock.
+2021-01-03T04:17:13.716529Z 0 [ERROR] Unable to setup unix socket lock file.
+2021-01-03T04:17:13.716544Z 0 [ERROR] Aborting
+```

誤字の修正

2021/01/03 04:21

投稿

kisagi

スコア7

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -154,7 +154,7 @@
-### 1. my.cnfが作成されない
+### 1. my.cnfが自動で作成されない
@@ -196,7 +196,7 @@
 #### 参考
-- [Homebrewで入れたMySQLのmy-xxx.cnfの場所とmy.cnfの設置](https://www.notion.so/5f09245f757b4a1ebd1dbf0906f69f4e#05e2ad48eeb148aca339c807d6f41097)
+- [Homebrewで入れたMySQLのmy-xxx.cnfの場所とmy.cnfの設置](https://qiita.com/madai0517/items/4df3ac0ce002301c7059)
 - [[MySQL] my.cnf の設定方法 (Mac + Homebrew 編)](https://codenote.net/mysql/3579.html)

補足の追加

2021/01/03 02:32

投稿

kisagi

スコア7

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -491,3 +491,47 @@
 auto.cnf	ca.pem		client-key.pem	ib_logfile0	ibdata1		public_key.pem	server-key.pem
 ```
+## 補足
+ - 起動中のプロセスはなし
+```
+hoge@Hoge ~ % ps ax | grep mysql
+16567 s000  S+     0:00.01 grep mysql
+```
+- パスワードを求められる
+```
+hoge@Hoge ~ % mysql_secure_installation
+Securing the MySQL server deployment.
+Enter password for user root:
+Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
+```
+- `/usr/local/var/mysql/Hoge.local.err`