MySql创建用户并授予root超级权限

 

--查询数据

SELECT * FROM user  
SELECT * FROM global_priv

--创建用户 user_erp  密码 vtr12345  远程访问地址为全部 %

CREATE USER 'user_erp'@'%' IDENTIFIED BY 'vtr12345';

--设置user_erp的权限为root超级权限

update global_priv set Priv = '{"access":18446744073709551615,"plugin":"mysql_native_password","authentication_string":"*26FBECC69F2CBC3C857DE28650FB0C52D122B92E","password_last_changed":1714017434}' where user = 'user_erp'