flush privileges;
grant all privileges on *.* to 'root'@'%' identified by 'Test2024' with grant option;
grant all privileges on *.* to 'magic'@'%' identified by 'Test2024' with grant option;
flush privileges;
select user,host from mysql.user;
revoke all on *.* from 'root'@'%';
show grants for 'root'@'%';
show grants for 'magic'@'%';
账号和权限管理
2024-01-25 06:54:04 47 阅读