mysql5.7 添加用户

创建用户：

	CREATE USER 'cms'@'%' IDENTIFIED BY 'password'; 

控制权限：

	GRANT ALL ON drupal.* TO  'cms'@'%'; 
	GRANT SELECT ON drupal TO 'cms'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

修改plugin：

	select user,host,plugin,password,authentication_string from user;
	update user set plugin = "mysql_native_password" where user = 'test_user';

修改密码 ：

	update user set authentication_string = "" where user = 'test_user';
	update user set password = PASSWORD('test_user') where user = 'test_user';