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. >>>