Mysql PASSWORD（）哈希无法正常工作(Mysql PASSWORD() hash not working correctly)

Mysql PASSWORD（）哈希无法正常工作(Mysql PASSWORD() hash not working correctly)

我正在尝试建立一个登录系统。 但是当我使用时

SELECT * FROM `users` WHERE `password` = PASSWORD('notgonnasaythat');

它不会显示任何内容......“选择零行”。 我用的时候

SELECT * FROM `users` WHERE `name` = 'lalala';

它运作良好。 我遇到了与SHA1（）或MD5（）相同的问题。

I am trying to make a login system. But when I use

SELECT * FROM `users` WHERE `password` = PASSWORD('notgonnasaythat');

It won't display anything... "Zero rows selected". When I use

SELECT * FROM `users` WHERE `name` = 'lalala';

It works well. I'm having the same problem with SHA1() or MD5().

最满意答案

现在修复了！ 我将它存储在VARCHAR（32）中，但32不足以存储加密。 将其更改为128，现在工作正常。

Fixed now! I stored it in a VARCHAR(32) but 32 wasn't enough to store the encryption. Changed it to 128 and it's working fine now.