weifly 发表于 2013-1-29 16:15:20

mysql创建用户并授权

1、用管理员登陆mysql
2、创建数据库
create database db01;3、创建用户
user01只能本地访问CREATE USER user01@'localhost' IDENTIFIED BY 'password1';user02可以远程访问CREATE USER user02@'%' IDENTIFIED BY 'password1';4、修改user01密码
SET PASSWORD FOR 'user01'@'localhost' = PASSWORD('password2');5、授权
user01管理db01全部权限GRANT ALL PRIVILEGES ON db01.* TO user01;user02查看权限，并修改密码GRANT SELECTON *.* TO 'user02'@'%' IDENTIFIED by 'password2';
页: [1]
查看完整版本: mysql创建用户并授权