天天看点

mysql root登陆报错 ERROR 1045 (28000): Access denied for user 'root'@'localhost'

安装完mysql登陆时报错1045:,解决办法

388 killall -9 mysqld

389 ./mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

390 netstat -an|grep 3306

391 ./mysql -uroot mysql

392 /etc/init.d/mysqld restart

393 netstat -an|grep 3306

394 ./mysql -uroot -p

mysql> update user set Password=password('root')where user = 'root';

mysql> flush privileges;

mysql> quit

继续阅读