标签: ERROR 1045

  • Access denied for user ‘root’@’localhost’ (using password: NO)

    # /etc/init.d/mysql 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

    # /etc/init.d/mysql restart

    # mysql -uroot -p

    Enter password: <输入新设的密码newpassword>

    mysql>