授权

• 用户权限

  grant all privileges on *.* to 'root'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
  
  grant all          代表赋于所有的权限 select delete .....
  with grant option  可以给其它用户，赋于和自己一样的权限, (新添加的这个用户，拥有了添加新用户权限)
  FLUSH PRIVILEGES;  刷新权限表
  

• 用户列表

  • select CONCAT('User: ''',user,'''@''',host,''';') from mysql.user;

• 新增一个用户,并赋于普通权限

  • grant all privileges on *.* to 'qhkj'@'%' identified by 'qhkj2503';

• 删除一个用户

  • drop user qhkj@'localhost';

• 修改登陆密码

  • 会话中修改:set password for 用户名@localhost = password('123');
  • 会话外修改:mysqladmin -uroot -p password '123'

• 修改host

  • update user set host = "%" where user = "qhkj";