[Discuss] mysql issue

[jdm at moylan.us (dan moylan)]

setting up mysql has always worked for me using this process
but now, i seem to be denied for some reason.

  root ~[121] mysql -u root

  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.009 sec)

  MariaDB [(none)]>

  moylan ~[1005] uname -a
  Linux alphacent 6.10.11-200.fc40.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Sep 18 21:09:58 UTC 2024 x86_64 GNU/Linux
  moylan ~[1006] mysql -u moylanus_moy -p
  Enter password:
  ERROR 1045 (28000): Access denied for user 'moylanus_moy'@'localhost' (using password: YES)
  moylan ~[1007]

i've tried repeatedly, being careful with the password.  any
suggestions as to what i might now be doing wrong and what i
need to change?

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]