The command to manipulate permissions does not work, but the mysql default client does

[ztoiax]

from mycli client

mysql root@localhost:(none)> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
(1142, "SELECT command denied to user 'root'@'localhost' for table 'user'")

[rolandwalker]

Hi!

That's very interesting! But I cannot duplicate the issue:

$ mycli --host localhost --port 3306 --user root
Password:
mysql root@localhost:(none)> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
+---------------------------------------+
| query                                 |
|---------------------------------------|
| User: 'mysql.infoschema'@'localhost'; |
| User: 'mysql.session'@'localhost';    |
| User: 'mysql.sys'@'localhost';        |
| User: 'root'@'localhost';             |
+---------------------------------------+