mysqlconnect bug 處理一例。

python  3.6  遇到這個問題。 

其實不是  python 的問題 是  mysqlconnect  驅動的問題。 

用 mysqlconnect   去連結   mysql 5.5.x 版本的資料庫的時候。  就報這個錯誤了。 

修改方法放這裡了。 

C:\Python36\Lib\site-packages\mysql\connector\protocol.py

mysql  connect   的這個  protocol.py  程式碼 

 

第 225 行 。

capabilities & ClientFlag.PLUGIN_AUTH:
    (packet
            res[].startswith()):

把

and res['server_version_original'].startswith("5.5.8")):

 修改為  

and (res['server_version_original'].startswith("5.5.8") or res['server_version_original'].startswith("5.5.9"))):

然後儲存 從新 連結資料庫就可以了。 

當然了 ，如果你用的 5.5.x  就再後面不停的加 or 然後加版本就行了。 

這本身是 mysql 的一個bug 

好了，問題就再這裡了。 

出錯資訊 在下面。 

1. >>> import os ,sys

2. >>> import dba1 as dba

3. python 版本 ok

4. >>> db=dba.mysql('192.168.x.x',3306,'hounew','hounew','hounew')

5. Traceback (most recent call last):

6.   File "C:\Python36\lib\site-packages\mysql\connector\utils.py", line 279, in read_string

7.     idx = buf.index(end)

8. ValueError: subsection not found

9. 
   

10. During handling of the above exception, another exception occurred:

11. 
    

12. Traceback (most recent call last):

13.   File "C:\Python36\lib\site-packages\mysql\connector\connection.py", line 152, in _do_handshake

14.     handshake = self._protocol.parse_handshake(packet)

15.   File "C:\Python36\lib\site-packages\mysql\connector\protocol.py", line 233, in parse_handshake

16.     packet, end=b'\x00')

17.   File "C:\Python36\lib\site-packages\mysql\connector\utils.py", line 281, in read_string

18.     raise ValueError("end byte not present in buffer")

19. ValueError: end byte not present in buffer

20. 
    

21. During handling of the above exception, another exception occurred:

22. 
    

23. Traceback (most recent call last):

24.   File "<pyshell#2>", line 1, in <module>

25.     db=dba.mysql('192.168.75.100',3306,'houselib_new','houselib_new','houselib_new')

26.   File "C:\Python36\lib\dba1.py", line 286, in __init__

27.     self.conn = connection.MySQLConnection(host=host, port=port, user=user, password=passwd, database=database)

28.   File "C:\Python36\lib\site-packages\mysql\connector\connection.py", line 104, in __init__

29.     self.connect(**kwargs)

30.   File "C:\Python36\lib\site-packages\mysql\connector\abstracts.py", line 960, in connect

31.     self._open_connection()

32.   File "C:\Python36\lib\site-packages\mysql\connector\connection.py", line 289, in _open_connection

33.     self._do_handshake()

34.   File "C:\Python36\lib\site-packages\mysql\connector\connection.py", line 155, in _do_handshake

35.     raise errors.get_mysql_exception(msg=err.msg, errno=err.errno,

36. AttributeError: 'ValueError' object has no attribute 'msg'

37. >>>