質問編集履歴
2
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -14,7 +14,28 @@
|
|
|
14
14
|
対処法を調べて試しましたが、上手くいきませんでした。
|
|
15
15
|
参考サイト：http://pickles-ochazuke.hatenablog.com/entry/2017/12/09/164921
|
|
16
16
|
```
|
|
17
|
+
Traceback (most recent call last):
|
|
18
|
+
File "/Users/***/Library/Python/3.6/lib/python/site-packages/mysql/connector/network.py", line 509, in open_connection
|
|
19
|
+
self.sock.connect(sockaddr)
|
|
20
|
+
TimeoutError: [Errno 60] Operation timed out
|
|
21
|
+
|
|
22
|
+
During handling of the above exception, another exception occurred:
|
|
23
|
+
|
|
24
|
+
Traceback (most recent call last):
|
|
25
|
+
File "/Users/***/../***.py", line 14, in <module>
|
|
26
|
+
database = 'LAA*******-***',
|
|
27
|
+
File "/Users/***/Library/Python/3.6/lib/python/site-packages/mysql/connector/__init__.py", line 179, in connect
|
|
28
|
+
return MySQLConnection(*args, **kwargs)
|
|
29
|
+
File "/Users/***/Library/Python/3.6/lib/python/site-packages/mysql/connector/connection.py", line 95, in __init__
|
|
30
|
+
self.connect(**kwargs)
|
|
31
|
+
File "/Users/***/Library/Python/3.6/lib/python/site-packages/mysql/connector/abstracts.py", line 716, in connect
|
|
32
|
+
self._open_connection()
|
|
33
|
+
File "/Users/***/Library/Python/3.6/lib/python/site-packages/mysql/connector/connection.py", line 206, in _open_connection
|
|
34
|
+
self._socket.open_connection()
|
|
35
|
+
File "/Users/***/Library/Python/3.6/lib/python/site-packages/mysql/connector/network.py", line 512, in open_connection
|
|
36
|
+
errno=2003, values=(self.get_address(), _strioerror(err)))
|
|
17
37
|
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'mysql***.phy.lolipop.lan:3306' (60 Operation timed out)
|
|
38
|
+
|
|
18
39
|
```
|
|
19
40
|
|
|
20
41
|
3306はデフォルトポート番号
|
1
誤字
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -11,7 +11,7 @@
|
|
|
11
11
|
|
|
12
12
|
### 発生している問題・エラーメッセージ
|
|
13
13
|
以下のようなエラーが発生してしまい、データーに接続できません。
|
|
14
|
-
対処法を調べた
|
|
14
|
+
対処法を調べて試しましたが、上手くいきませんでした。
|
|
15
15
|
参考サイト：http://pickles-ochazuke.hatenablog.com/entry/2017/12/09/164921
|
|
16
16
|
```
|
|
17
17
|
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'mysql***.phy.lolipop.lan:3306' (60 Operation timed out)
|