mysql更改默认密码错误

# 停止MySQL服务
sudo systemctl stop mysql

# 以跳过权限表的方式启动MySQL
sudo mysqld_safe --skip-grant-tables &

# 登录MySQL
mysql -u root

# 在MySQL shell中更新密码
UPDATE mysql.user SET Password=PASSWORD('new_password') WHERE User='root';
FLUSH PRIVILEGES;
EXIT;

# 重启MySQL服务
sudo systemctl start mysql

-- 使用具有足够权限的用户登录
mysql -u root -p

-- 授予当前用户更改密码的权限
GRANT ALL PRIVILEGES ON *.* TO 'current_user'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

-- 正确的命令语法
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
FLUSH PRIVILEGES;

[mysqld]
bind-address = 127.0.0.1

sudo systemctl restart mysql