집 >데이터 베이스 >MySQL 튜토리얼 >Accessdeniedforuser'root'@&#
$mysqld --skip-grant-tables $ mysql -u root mysql$mysql UPDATE user SET Password=PASSWORD('my_password') where USER='root';$mysql FLUSH PRIVILEGES; $ /etc/init.d/mysql restart $ mysql -u root -pEnter password: my_password 在执行命令前,kil
$mysqld --skip-grant-tables <pre class="brush:sql;">$ mysql -u root mysql $mysql> UPDATE user SET Password=PASSWORD('my_password') where USER='root'; $mysql> FLUSH PRIVILEGES; <pre class="brush:sql;">$ /etc/init.d/mysql restart <pre class="brush:sql;">$ mysql -u root -p Enter password: my_password在执行命令前,kill掉mysql的进程