Recreate existing user in Mysql database

 Recreate existing user in Mysql database

SELECT
    CONCAT(
        'CREATE USER ''', user, '''@''', host,
        ''' IDENTIFIED BY PASSWORD ''', authentication_string, ''';'
    ) AS create_user_stmt
FROM mysql.user;

SELECT

    CONCAT(

        'SHOW CREATE USER ''', user, '''@''', host, ''';'

    ) AS show_create_user_stmt

FROM mysql.user;

SELECT

    CONCAT(

        'SHOW GRANTS FOR ''', user, '''@''', host, ''';'

    ) AS show_grants_stmt

FROM mysql.user;