本文详细介绍了如何在SQL环境中创建用户、设置密码，并分配不同级别的权限，包括为本地用户和远程用户设置权限。
create user test@'%' identified by 'test' //创建用户和密码
grant all on *.* to test@'localhost' identified by 'test'; //赋权限给localhost
grant all on *.* to test@'%' identified by 'test'; //赋权限给所有用户
create user test1@'%' identified by 'test'
grant select,insert,update,delete,create,drop on mysql.test to test1@'%' identified by 'test';
grant select,insert,update,delete,create,drop on mysql.test to test1@'localhost' identified by 'test'; //给本地用户赋予select,insert,update,delete,create,drop在mysql.test表
grant all on *.* to test@'localhost' identified by 'test'; //赋权限给localhost
grant all on *.* to test@'%' identified by 'test'; //赋权限给所有用户
create user test1@'%' identified by 'test'
grant select,insert,update,delete,create,drop on mysql.test to test1@'%' identified by 'test';
grant select,insert,update,delete,create,drop on mysql.test to test1@'localhost' identified by 'test'; //给本地用户赋予select,insert,update,delete,create,drop在mysql.test表
扫一扫
3796
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
