我在DOS中运行mysql,在msql提示符下键入:
grant select,insert,update,delete on mydb.* to myname@"*" identified by "abc";
但在phpMyAdmin中看时,它的密码不是我以上输入的"abc",而成了"7cd2b5942be28759",
而且用这个myname新用户及密码登入时,有下列错误:
#1045 - Access denied for user: 'myname@localhost' (Using password: YES)不知什么办才好,请高手指路.谢谢.
grant select,insert,update,delete on mydb.* to myname@"*" identified by "abc";
但在phpMyAdmin中看时,它的密码不是我以上输入的"abc",而成了"7cd2b5942be28759",
而且用这个myname新用户及密码登入时,有下列错误:
#1045 - Access denied for user: 'myname@localhost' (Using password: YES)不知什么办才好,请高手指路.谢谢.
#1045 - Access denied for user: 'cin@localhost' (Using password: YES)
什么办,再次请指,谢
再侃侃吧!
grant select,insert,update,delete on mydb.* to myname@"*" identified by "abc";
但在phpMyAdmin中看时,它的密码不是我以上输入的"abc",而成了"7cd2b5942be28759",
#############################原因是mysql用md5()对密码进行了加密。所以是7cd2b5942be28759。