1.赋予所有权限:
grant all privileges on dbname.* to test1@'192.168.2.100‘ identified by 'password'
2.赋予部分权限:
grant select ,update,delete,insert on *.* to test2@'%' identified by 'password'
grant all privileges on dbname.* to test1@'192.168.2.100‘ identified by 'password'
2.赋予部分权限:
grant select ,update,delete,insert on *.* to test2@'%' identified by 'password'