linux mysql 新增用户分配权限

分类: IT文章 • 2025-01-10 18:39:50

insert into mysql.user(Host,User,Password) values("%","admin",password("admin"));

grant all privileges on *.* to 'admin' identified by 'admin';

grant all privileges on *.* to admin@localhost identified by 'admin';

grant all privileges on *.* to admin@'%'identified by 'admin';

flush privileges; 刷新权限

linux mysql 新增用户 分配权限