This is not a bug. You can already run the grant command using the root
user, which has the grant privilege:
~/sandboxes/rsandbox_mysql-5_6_26/m -u root
master [localhost] {root} ((none)) > show grants for root@'localhost'\G
*************************** 1. row ***************************
Grants for root@localhost: GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost'
WITH GRANT OPTION
*************************** 2. row ***************************
Grants for root@localhost: GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH
GRANT OPTION
2 rows in set (0.00 sec)
master [localhost] {root} ((none)) > show grants for msandbox@'127.%'\G
*************************** 1. row ***************************
Grants for msandbox@127.%: GRANT ALL PRIVILEGES ON *.* TO 'msandbox'@'127.%'
1 row in set (0.00 sec)
master [localhost] {root} ((none)) > show grants for msandbox_rw@'127.%'\G
*************************** 1. row ***************************
Grants for msandbox_rw@127.%: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE,
DROP, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES,
EXECUTE ON *.* TO 'msandbox_rw'@'127.%'
1 row in set (0.00 sec)
master [localhost] {root} ((none)) > show grants for msandbox_ro@'127.%'\G
*************************** 1. row ***************************
Grants for msandbox_ro@127.%: GRANT SELECT, EXECUTE ON *.* TO
'msandbox_ro'@'127.%'
1 row in set (0.00 sec)
Similarly, you can use a less privileged user
~/sandboxes/rsandbox_mysql-5_6_26/m -u msandbox_rw
~/sandboxes/rsandbox_mysql-5_6_26/m -u msandbox_ro
** Changed in: mysql-sandbox
Status: New => Invalid
--
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1485989
Title:
No MySQL Sandbox user seems to have WITH GRANT OPTION
To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-sandbox/+bug/1485989/+subscriptions
--
Mailing list: https://launchpad.net/~enterprise-support
Post to : [email protected]
Unsubscribe : https://launchpad.net/~enterprise-support
More help : https://help.launchpad.net/ListHelp
