Possible MySQL authentication issue with python package (PyMySQL3) -

i found blog post pretty sums problem. at

http://simon04.net/2013/03/python3-mysql/

the blog post clear summarize: i'm trying access remote mysql database python package called pymysql3. keep getting error: "attributeerror: 'bytes' object has no attribute 'encode'". blog post above , other research, think has database having old authentication method.

however, i'm confused because looks old authentication method phased out sometime in mysql 4.0. database have runs mysql 5.0.51a. shouldn't database have correct authentication?

i've been working on awhile , getting little frustrated. can help. thanks,

from https://github.com/petehunt/pymysql/issues/64

for me problem due usage of old authentication method (cf. http://dev.mysql.com/doc/internals/en/authentication-method.html). creating new user (resetting password might work well) , making sure password column user in mysql.user table starts * (otherwise check server configuration according above link), solved problem me.

have created users version mentioned?

the thread shows how fix problem in code aswell, tellme when need additional fix it. edit answer accordingly.