mysql 取消root权限设置密码

-- 删除 root 用户
DROP USER 'root'@'localhost';

-- 创建一个新的 root 用户并赋予所有权限
CREATE USER 'root'@'localhost' IDENTIFIED BY 'new_password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

mysqladmin -u root password 'new_password'

-- 登录 MySQL
mysql -u root

-- 在 MySQL 命令行中设置密码
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('new_password');
FLUSH PRIVILEGES;

# 停止 MySQL 服务
sudo systemctl stop mysql

# 以不检查权限的方式启动 MySQL
sudo mysqld_safe --skip-grant-tables &

# 登录 MySQL
mysql -u root

# 重置密码
USE mysql;
UPDATE user SET Password=PASSWORD('new_password') WHERE User='root';
FLUSH PRIVILEGES;
EXIT;

# 重启 MySQL 服务
sudo systemctl start mysql