Description:
mysql [localhost] {root} ((none)) > GRANT ALL PRIVILEGES ON *.* TO 'logtest0001'@'127.0.0.2' IDENTIFIED BY 'secure-pwd';
Query OK, 0 rows affected (0.00 sec)
mysql [localhost] {root} ((none)) > GRANT ALL PRIVILEGES ON *.* TO 'logtest0002'@'127.0.0.2' IDENTIFIED BY 'secure-pwd';
Query OK, 0 rows affected (0.01 sec)
mysql [localhost] {root} ((none)) > GRANT ALL PRIVILEGES ON *.* TO 'logtest0003'@'127.0.0.2' IDENTIFIED BY 'secure-pwd';
Query OK, 0 rows affected (0.00 sec)
mysql [localhost] {root} ((none)) > \q
Bye
$ grep 'logtest000' data/msandbox-slow.log
GRANT ALL PRIVILEGES ON *.* TO 'logtest0001'@'127.0.0.2' IDENTIFIED BY PASSWORD '*10B5F2061DEFB160B9B09182F508656CF0FFDCF9';
GRANT ALL PRIVILEGES ON *.* TO 'logtest0002'@'127.0.0.2' IDENTIFIED BY PASSWORD '*10B5F2061DEFB160B9B09182F508656CF0FFDCF9';
GRANT ALL PRIVILEGES ON *.* TO 'logtest0003'@'127.0.0.2' IDENTIFIED BY PASSWORD '*10B5F2061DEFB160B9B09182F508656CF0FFDCF9';
GRANT ALL PRIVILEGES ON *.* TO 'logtest0003'@'127.0.0.2' IDENTIFIED BY PASSWORD '*10B5F2061DEFB160B9B09182F508656CF0FFDCF9';
$ ./my sql -u root -e "GRANT ALL PRIVILEGES ON *.* TO 'logtest0004'@'127.0.0.2' IDENTIFIED BY 'secure-pwd';"
$ ./my sql -u root -e "GRANT ALL PRIVILEGES ON *.* TO 'logtest0005'@'127.0.0.2' IDENTIFIED BY 'secure-pwd';"
$ ./my sql -u root -e "GRANT ALL PRIVILEGES ON *.* TO 'logtest0006'@'127.0.0.2' IDENTIFIED BY 'secure-pwd';"
$ grep 'logtest000' data/msandbox-slow.log
GRANT ALL PRIVILEGES ON *.* TO 'logtest0001'@'127.0.0.2' IDENTIFIED BY PASSWORD '*10B5F2061DEFB160B9B09182F508656CF0FFDCF9';
GRANT ALL PRIVILEGES ON *.* TO 'logtest0002'@'127.0.0.2' IDENTIFIED BY PASSWORD '*10B5F2061DEFB160B9B09182F508656CF0FFDCF9';
GRANT ALL PRIVILEGES ON *.* TO 'logtest0003'@'127.0.0.2' IDENTIFIED BY PASSWORD '*10B5F2061DEFB160B9B09182F508656CF0FFDCF9';
GRANT ALL PRIVILEGES ON *.* TO 'logtest0003'@'127.0.0.2' IDENTIFIED BY PASSWORD '*10B5F2061DEFB160B9B09182F508656CF0FFDCF9';
GRANT ALL PRIVILEGES ON *.* TO 'logtest0004'@'127.0.0.2' IDENTIFIED BY PASSWORD '*10B5F2061DEFB160B9B09182F508656CF0FFDCF9';
GRANT ALL PRIVILEGES ON *.* TO 'logtest0004'@'127.0.0.2' IDENTIFIED BY PASSWORD '*10B5F2061DEFB160B9B09182F508656CF0FFDCF9';
GRANT ALL PRIVILEGES ON *.* TO 'logtest0005'@'127.0.0.2' IDENTIFIED BY PASSWORD '*10B5F2061DEFB160B9B09182F508656CF0FFDCF9';
GRANT ALL PRIVILEGES ON *.* TO 'logtest0005'@'127.0.0.2' IDENTIFIED BY PASSWORD '*10B5F2061DEFB160B9B09182F508656CF0FFDCF9';
GRANT ALL PRIVILEGES ON *.* TO 'logtest0006'@'127.0.0.2' IDENTIFIED BY PASSWORD '*10B5F2061DEFB160B9B09182F508656CF0FFDCF9';
GRANT ALL PRIVILEGES ON *.* TO 'logtest0006'@'127.0.0.2' IDENTIFIED BY PASSWORD '*10B5F2061DEFB160B9B09182F508656CF0FFDCF9';
How to repeat:
Sometimes GRANT statements are logged twice.
This is with long_query_time=0.0