[Discuss] mysql/mariadb

[richb at pioneer.ci.net (Rich Braun)]

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 <jdm at moylan.us> 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)
> jdm at moylan.us
> www.moylan.us
> [no html pls]