Re: Various questions about 10.1.26-MariaDB on CYGWIN_NT-10.0 2.9.0(0.318/5/3) 2017-09-12 10:18 x86_64 Cygwin

[Wayne Davison <wayne@opencoder.net>]

On Sun, Nov 5, 2017 at 4:30 PM, Keith Christian wrote:
> $ mysql -u 'keith'@'localhost'

This is where you're messing up. You want to use "mysql -u keith" to
login as the user "keith" -- you're specifying a username with a
host-like suffix.

In the grant commands, the host suffix indicates where the connection
is coming from, and by default (without using the -h option) that
connection is via a localhost unix-domain socket. If you were instead
to use "mysql -u keith -h 127.0.0.1" then you would have a TCP
connection to the localhost IP that you would need to grant permission
for using 'keith'@'127.0.0.1' in a grant command (or you could choose
to use a wildcard of 'keith'@'%' to match any host, at which point you
should specify a "with password" in the grant). So, it is the combo of
the -u name and the -h host that is matched in the grant command's
user@host syntax.

> How can I get GNU readline back as the editor for the mysql client?

That is a compile-time option, so unless we can convince the mariadb
maintainer to switch back to readline, we have to compile our own
mysql client from the mariadb source.

..wayne..

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple