mysql 修改root权限

-- 创建一个新用户并授予对 mydb 数据库的权限
CREATE USER 'new_root'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON mydb.* TO 'new_root'@'localhost';

-- 删除 root 用户的全局权限
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'root'@'localhost';

-- 刷新权限
FLUSH PRIVILEGES;

-- 连接到 MySQL 数据库
USE mysql;

-- 更新 root 用户的权限
UPDATE user SET Host='localhost', Select_priv='Y', Insert_priv='Y', Update_priv='Y', Delete_priv='Y', Create_priv='N', Drop_priv='N', Reload_priv='N', Shutdown_priv='N', Process_priv='N', File_priv='N', Grant_priv='N', References_priv='N', Index_priv='N', Alter_priv='N', Show_db_priv='N', Super_priv='N', Create_tmp_table_priv='N', Lock_tables_priv='N', Execute_priv='N', Repl_slave_priv='N', Repl_client_priv='N', Create_view_priv='N', Show_view_priv='N', Create_routine_priv='N', Alter_routine_priv='N', Create_user_priv='N' WHERE User='root';

-- 刷新权限
FLUSH PRIVILEGES;

-- 刷新权限
FLUSH PRIVILEGES;

-- 检查密码是否正确
SELECT User, Host, Password FROM mysql.user WHERE User='root';

-- 检查所有用户的权限
SHOW GRANTS FOR 'root'@'localhost';

-- 确保所有相关权限都被正确修改
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'root'@'localhost';
FLUSH PRIVILEGES;