[Discuss] mysql/mariadb

[jdm at moylan.us (dan moylan)]

rich braun writes:
> 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.

hmmmm ... there are no .my.cnf on any of the working hosts,
and the /etc/my.cnf.d files are the same on the working and
new hosts.  however, i had created ~/.my.cnf on the new
host with a client for root with a password (in one of my
many fiddles trying to get things to work).  i just deleted
it and now no longer need the -S option -- back in business.
thanks for your help.

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]