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>

Drop Your Comment