mysql相关命令

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

grant all privileges on *.* to 'root'@'%' identified by 'root';

flush privileges;