Dan-- You probably have a [client] section in a my.cnf or .my.cnf file on those other working hosts, which sets defaults for username / password / host / socket. Or you have explicitly done a grant for 'user'@'localhost'. For historic reasons, the % wildcard character does NOT match the string "localhost", that's probably the mystifying part of this.
Sent from my iPhone > On Jun 27, 2017, at 09:29, dan moylan <[email protected]> wrote: > > > rich braun writes: >>> moylan ~[285] mysql -u moylan_moy -p >>> Enter password: >>> ERROR 1045 (28000): Access denied for user 'moylan_moy'@'localhost' (using >>> password: YES) > >> Reiterating my earlier advice: learn about and use the -S command line >> option. The error message references localhost which is different from >> socket access. > > well, i did use the -S option, and it worked -- thank you > -- but unfortunately i can't say that i learned much. > > i have a number of perl scripts dealing with mysql data > bases. if i append " -S /var/lib/mysql/mysql.sock" to each > mysql command therein, i seem to get success. that's good. > however i have these same scripts working on other computers > using the identical operating system (fc25) and don't need > to resort to this. what's going on? i'm mystefied. > > but thanks, > ole dan > > j. daniel moylan > 84 harvard ave > brookline, ma 02446-6202 > 617-777-0207 (cel) > [email protected] > www.moylan.us > [no html pls] _______________________________________________ Discuss mailing list [email protected] http://lists.blu.org/mailman/listinfo/discuss
