mysql密码的长度有限制吗?

tkmxxg

update user set password=password('k8_-&jd,GL2^5$3!fL9.]/sdK?><:[\[}32[|}[{57*)(&3%?>,Kk(^%lkjL6)(4x09!$*(-Kj*60_+=J09%&*+_}{\|\dk\.,%&') where user='root';
flush privileges;

我设置这样的100位密码后,用该密码登录不进去的

mysql密码的设置有长度和规则限制吗?

yueliangdao0608

mysql> grant all privileges on test.* to 'w_user'@'localhost' identified by 'ddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd
dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd
ddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd';
Query OK, 0 rows affected (0.03 sec)

sunnyfun

由于mysql使用的是HASH加密，对密码的字符和长度一般没有特殊的限制，除非操作系统不支持。

楼主的问题出在设密码时在引号中出现了“\”，这是一个转义符，有特殊的含义，因此，实际的存入的密码是：

k8_-&jd,GL2^5$3!fL9.]/sdK?><:[[}32[|}[{57*)(&3%?>,Kk(^%lkjL6)(4x09!$*(-Kj*60_+=J09%&*+_}{|dk.,%&

当然还有操作系统这关，解决方法：

新建一个文本文件比如pass.txt，内容为:

[mysql]
user=root
password=k8_-&jd,GL2^5$3!fL9.]/sdK?><:[[}32[|}[{57*)(&3%?>,Kk(^%lkjL6)(4x09!$*(-Kj*60_+=J09%&*+_}{|dk.,%&

假设将其放在根目录，登陆时使用：

mysql --defaults-extra-file=\pass.txt

即可

tkmxxg

OK了,谢谢了