Mysql

新建用户  权限 修改密码

create user username@'localhost' indentified by 'password';
SET PASSWORD FOR 'sgadmin'@'localhost' = PASSWORD('password2');
grant all privileges on user.* to sgadminuser;

1.       CREATE USER
语法：CREATE USER 'username'@'host' IDENTIFIED BY 'password';
2.a       授权用户  使用GRANT语句
  语法：mysql> grant 权限1,权限2,...权限n on 数据库名称.表名称 to 用户名@用户地址 identified by '连接口令';
  select,insert,delete,update,index
  b.       取消授权用户:
  语法：REVOKE privilege ON databasename.tablename FROM 'username'@'host';
3.       直接修改user表的用户口令：
语法：update mysql.user set password=password('新密码') where User="phplamp" and Host="localhost";

grant select,insert,update,delete,index on yttladmin.* to yttladmin@'%' identified by 'admin';