似乎不行，MYSQL5的加密方法更加严密。 为什么要用旧的版本不用加密更好的版本？mysql help: MySQL 5.1 employs the stronger authentication method (first implemented in MySQL 4.1) that has better password protection during the connection process than in earlier versions. It is secure even if TCP/IP packets are sniffed or the mysql database is captured. Section 5.7.9, “Password Hashing as of MySQL 4.1”, discusses password encryption further.
SET PASSWORD FOR cc@'192.168.188.%' = OLD_PASSWORD('密码');
Rigth answer.I think that lz may have lower client.
用函数OLD_PASSWORD可以设置，不过有好的方法为什么不用？ MYSQL HELP： OLD_PASSWORD(str) OLD_PASSWORD() was added to MySQL when the implementation of PASSWORD() was changed to improve security. OLD_PASSWORD() returns the value of the old (pre-4.1) implementation of PASSWORD() as a binary string, and is intended to permit you to reset passwords for any pre-4.1 clients that need to connect to your version 5.1 MySQL server without locking them out. See Section 5.7.9, “Password Hashing as of MySQL 4.1”.
详细一点，什么加密方式？
正常的话,用4.1以后的mysql版本,sql中的password("**")会用新版本的加密方式去处理;
而我的意思是,用回旧版本的mysql加密方式来启动mysql,令到sql中的password("**")会用回旧版本的加密方式去处理.请大家多多发表意见.帮帮忙..
为什么要用旧的版本不用加密更好的版本？mysql help:
MySQL 5.1 employs the stronger authentication method (first implemented in MySQL 4.1) that has better password protection during the connection process than in earlier versions. It is secure even if TCP/IP packets are sniffed or the mysql database is captured. Section 5.7.9, “Password Hashing as of MySQL 4.1”, discusses password encryption further.
Rigth answer.I think that lz may have lower client.
MYSQL HELP：
OLD_PASSWORD(str) OLD_PASSWORD() was added to MySQL when the implementation of PASSWORD() was changed to improve security. OLD_PASSWORD() returns the value of the old (pre-4.1) implementation of PASSWORD() as a binary string, and is intended to permit you to reset passwords for any pre-4.1 clients that need to connect to your version 5.1 MySQL server without locking them out. See Section 5.7.9, “Password Hashing as of MySQL 4.1”.