centos 下刚安装完MySQL就出现密码错误 Access denied for user 'root'

    xiaoxiao2021-03-25  75

    错误信息:

    # mysql -uroot -p

    Enter password:

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

    解决办法:

    # service mysqld stop # mysqld_safe --user=mysql --skip-grant-tables --skip-networking & # mysql -u root mysql mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root'; mysql> FLUSH PRIVILEGES;  //这里主要;号 mysql> quit # service mysqld restart # mysql -uroot -p Enter password: <输入新设的密码newpassword>

    转载请注明原文地址: https://ju.6miu.com/read-39482.html

    最新回复(0)