SELECT Host,User,Select_priv as S,Insert_priv as I,Update_priv as U,Delete_priv as D,Create_priv as C,Drop_priv as P,Reload_priv as R,Shutdown_priv as W,Process_priv as O,File_priv as F,Grant_priv as G,References_priv as N,Index_priv as X,Alter_priv as A FROM user ORDER BY S,I,U,D,C,P,R,W,O,F,G,N,X,A