[Discuss] confused as usual

[jdm at moylan.us (dan moylan)]

setting up a new computer.  i'm always confused when
something that has always worked before doesn't.  check this
scenario:

> root ~[122] mysql -u root
> Welcome to the MariaDB monitor.  Commands end with ; or \g.
> Your MariaDB connection id is 10
> Server version: 10.11.8-MariaDB MariaDB Server
> Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
> Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

> MariaDB [(none)]> show grants;
> +-----------------------------------------------------------------------------------------------------------------------------------------+
> | Grants for root at localhost                                                                                                               |
> +-----------------------------------------------------------------------------------------------------------------------------------------+
> | GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` IDENTIFIED VIA mysql_native_password USING 'invalid' OR unix_socket WITH GRANT OPTION |
> | GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION                                                                           |
> +-----------------------------------------------------------------------------------------------------------------------------------------+
> 2 rows in set (0.000 sec)

> MariaDB [(none)]> grant all on *.* to moylanus_moy at localhost identified by 'xxxxxxxxx`;
> Query OK, 0 rows affected (0.011 sec)
> MariaDB [(none)]>

> moylan ~[864] mysql -u moylanus_moy -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'moylanus_moy'@'localhost' (using password: YES)
> moylan ~[865]

what have i missed?

tia,
ole dan

j. daniel moylan
84 harvard ave
brookline, ma 02446-6202
617-777-0207 (cel)
jdm at moylan.us
www.moylan.us
[BLM]