MySQL copy a user
How about inserting into another table, update columns? Something like:
CREATE TABLE user_tmp LIKE user;INSERT INTO user_tmp SELECT * FROM user WHERE host ='localhost' AND USER ='root';UPDATE user_tmp SET user = 'readonlyuser', Insert_priv = 'N', Update_priv = 'N', Delete_priv = 'N', /* TODO: ADAPT TO YOUR SUITS */ LIMIT 1;INSERT INTO user select * FROM user_tmp;DROP TABLE user_tmp;
I found two options.
1st if you are Windows User, you can use MySql Administrator. http://dev.mysql.com/doc/administrator/en/mysql-administrator-user-administration-user-accounts.html
2nd you can use mysquserclone command from Mysql Utilities: http://wb.mysql.com/utilities/man/mysqluserclone.html
Good luck.