新人老周的专栏

insert into mysql.userSELECT %, admin, PASSWORD(admin), Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv,  Shutdown_priv,  Process_priv, File_priv, Grant_p

SET @NEWUSER='master'; SET @NEWPASS='password'; SELECT @FF:=GROUP_CONCAT(column_name) from information_schema.columns where TABLE_NAME='User' and COLUMN_NAME not in('Host','User','Password');