This may be old news, but it's kinda frustrating and I wonder if
Something Can Be Done:
mysql> grant all on *.* to 'jeff_dev@localhost' identified by
'my^son^daniel';
ERROR 1145: The host or user argument to GRANT is too long
mysql> grant all on *.* to 'q_dev@localhost' identified by
'my^son^daniel';
Query OK, 0 rows affected (0.00 sec)
If memory serves me, a host name in the DNS system can be 255
characters altogether. If you assume that a UNIX username is 8
characters (I know, I know, UNIX usernames have nothing to do with
MySQL usernames), that means that a MySQL username must be at least
264 chars long, and if you assume that the user name will have a
string such as _dev _test _prod, etc., appended then 270 chars is more
reasonable from a user point of view.
Or is there another solution that eludes me?
Many thanks,
Jeff