折腾了一个下午,这些做法都是错的(包括官网的)
以下方法尝试后均报错
UPDATE user SET password = PASSWORD('你要设置的密码') WHERE user = 'root';
sudo mysqladmin -u root password oldpass "123456"
sudo mysqladmin -u root password "123456"
SET PASSWORD = PASSWORD ("123456");
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
使用官网的做法失败:
sudo service mysql start --skip-grant-tables
mysql但是我执行不了
sudo mysql
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
退出mysql
service mysql restart
mysql -u root -p123456失效
sudo mysql -u root -p123456没用
看官网的第二种方法失败
sudo service mysql start --user=mysql
sudo service mysql stop
`sudo su`
试图找.pid文件
cd /var/lib/mysql/
cd /var/ru