Python连接mysql提示old (insecure) passwords is not supported
Authentication with old (insecure) passwords is not supported. For more information, lookup Password Hashing in the latest MySQL manual
如上所示,如果一旦出现这个问题,主要是因为客户端用了新的密码版本,而服务器却使用了老的密码版本,需要设置一下服务器的密码:
SET old_passwords=FALSE;
SET PASSWORD = PASSWORD('hello123');
更改密码为41位加密