Copying User Privileges
=======================

Author: Momchil Ivanov <momchil@xaxo.eu>
Date  : 2013.12.08

Introduction
------------

  This article describes how to copy the privileges of a user on the
  MySQL server.

Method
------

  The following SQL queries create a new user <NEW USERNAME>@<NEW
  HOSTNAME> on the MySQL server with the same privileges as the user
  <USERNAME>@<HOSTNAME>:

    CREATE TABLE mysql.user_copy SELECT * FROM mysql.user WHERE
    user='USERNAME' AND host='HOSTNAME';

    UPDATE mysql.user_copy SET user='NEW USERNAME',
    password=password('NEW PASSWORD'), host='NEW HOSTNAME';

    INSERT INTO mysql.user SELECT * FROM mysql.user_copy;

    DROP TABLE mysql.user_copy;

    CREATE TABLE mysql.db_copy SELECT * FROM mysql.db WHERE
    user='USERNAME' AND host='HOSTNAME';

    UPDATE mysql.db_copy SET user='NEW USERNAME', host='NEW HOSTNAME';

    INSERT INTO mysql.db SELECT * FROM mysql.db_copy;

    DROP TABLE mysql.db_copy;

  The example uses the temporary tables mysql.user_copy and
  mysql.db_copy to copy the privileges.