granting all privileges leads to syntax error

[tsonglew]

creating user and granting select to the user works fine, but granting all privileges to the user failed.

mysql> CREATE USER 'dolt'@'%' IDENTIFIED BY 'dolt';
mysql> GRANT SELECT ON *.* TO 'dolt'@'%';
mysql> GRANT ALL PRIVILEGES  ON *.* TO 'dolt'@'%';
Error 1105: syntax error at position 22 near 'PRIVILEGES'

[fulghum]

Hey @tsonglew, thanks for reporting this gap. We'll dig in and take a look at extending the syntax to support this.

[timsehn]

creating user and granting select to the user works fine, but granting all privileges to the user failed.

mysql> CREATE USER 'dolt'@'%' IDENTIFIED BY 'dolt';
mysql> GRANT SELECT ON *.* TO 'dolt'@'%';
mysql> GRANT ALL PRIVILEGES  ON *.* TO 'dolt'@'%';
Error 1105: syntax error at position 22 near 'PRIVILEGES'

If you leave off PRIVILEGES and just do:

GRANT ALL ON *.* TO 'dolt'@'%';

This will work.

[timsehn]

We should implement ALL PRIVILEGES in addition to ALL ASAP since it is in all the high ranked online examples.

[zachmu]

This is fixed in source. We'll close this when it's in a release.

[timsehn]

Gonna close so we don't forget to when we release.