mysql创建用户 赋权

//mysql创建用户

create user 'yonghuming'@'localhost' identified by 'mima';

//mysql用户赋权

grant all privileges on *.* to yonghuming@localhost identified by 'mima';

//查mysql所有用户

SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;