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@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@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) [email protected] www.moylan.us [BLM] _______________________________________________ Discuss mailing list [email protected] https://lists.blu.org/mailman/listinfo/discuss
