为什么我用:UPDATE mysql.user SET Password = '1234' WHERE Host = 'localhost' AND User = 'bugs';
flush privileges;
再用用户名bugs,密码1234就登陆不上数据库了,真的快晕了,哪位数据库高手指教一下,小女子不胜感激!
user表里的password里面放的是加密过的密码,你这样直接改,当然登不进去了
应该加个password函数,PASSWORD('password')
UPDATE mysql.user SET Password = PASSWORD('1234') WHERE Host = 'localhost' AND User = 'bugs';
flush privileges;