Query OK, 1 row affected, 3 warnings (0.10 sec)
mysql> grant select on dht.* to remoteuser@'HOSTIP';
ERROR 1133 (42000): Can't find any matching row in the user table
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.03 sec)
mysql> grant select on dht.* to remoteuser@'HOSTIP';
Query OK, 0 rows affected (0.00 sec)
mysql> show grants for remoteuser@HOSTIP;
+------------------------------------------------------------------------------------------------------------------------+
| Grants for remoteuser@HOSTIP |
+------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'remoteuser'@'HOSTIP' IDENTIFIED BY PASSWORD '*BFCC7D91D976CC430364C6A87CA42917EDF5E631' |
| GRANT SELECT ON `dht`.* TO 'remoteuser'@'HOSTIP' |
+------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)