mysql报错1045(2800)
2019-05-06 13:15:56

般这个错误出现在mysql密码错误的时候,


ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

在mysql.user表中设置初始密码时未使用password()函数加密密码。因此就出现了ERROR 1045


UPDATE mysql.user SET password = 'root'

WHERE user = 'root' AND host = 'localhost'

密码正确更新方式是:


UPDATE mysql.user SET password =PASSWORD( 'root98') 

WHERE user = 'root' AND host = 'localhost'