1.授予所有权限给一个用户
grant all privileges on *.* to '用户名'@'ip地址' identified by '密码' with grant option;
flush privileges;
2. 授予test数据库给一个用户
grant all privileges on test.* to '用户名'@'ip地址' identified by '密码' with grant option;
flush privileges;
1.授予所有权限给一个用户
grant all privileges on *.* to '用户名'@'ip地址' identified by '密码' with grant option;
flush privileges;
2. 授予test数据库给一个用户
grant all privileges on test.* to '用户名'@'ip地址' identified by '密码' with grant option;
flush privileges;