X-Recipient: archive-cygwin AT delorie DOT com
DomainKey-Signature: a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:mime-version:in-reply-to:references:from:date
	:message-id:subject:to:content-type; q=dns; s=default; b=wTBc6e3
	RvFgAj/eHl3A6mWrr/I7mGxBA2l0kaQZ9r/R1KbodiT+I+Xzppp6FQd/Ll3AJ+JC
	hmXADEKgYZt9/1m5e6LIeVDhbPj7Ot4rYhR2sM9NvcRmI+EwzNtIMQf5EzXnX6kW
	LBUjR5bsUvpUHo1WQmpCxoVJGXjhNwGfwf0w=
DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:mime-version:in-reply-to:references:from:date
	:message-id:subject:to:content-type; s=default; bh=nRVC9r4Gdjq5k
	mTMGfd5oGP/zMM=; b=v5CIndHJrFnJ5cURxEx0BgVB6mlJJE/8R/X4cSQ43ppo4
	B+9ynguDQ+amK0QkRZ+r5tBQ28FWtACgRl1ZZSLc9A5Hbiuslz4YUwqWbhYli2uV
	ThDVuxwoSgHOMFoj6o2x26fsbAai67RHeW7C5cZm7/65M7QTzRs9tCCzNT4FAU=
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id: <cygwin.cygwin.com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
Authentication-Results: sourceware.org; auth=none
X-Virus-Found: No
X-Spam-SWARE-Status: No, score=-1.1 required=5.0 tests=AWL,BAYES_00,RCVD_IN_DNSWL_NONE,RCVD_IN_SORBS_SPAM autolearn=no version=3.3.2 spammy=username, combo, Hx-spam-relays-external:sk:mail-it, H*r:sk:mail-it
X-HELO: homiemail-a72.g.dreamhost.com
X-Gm-Message-State: AJaThX5UISBGiYMvQlv12lYl67Sg/UsbQUWr+5phnUwYVvs0/ifyliNI	x87GioUqozBf9T0VpqLXi0dxQAByWcxRR4wgit8=
X-Google-Smtp-Source: ABhQp+SVUhRQXvVNAQNHfpt+By2UV6FCaJS74a664RtNuyIZJglnNRJGmygGlyzgCo8Aj72wmwLv/CD46a/se8zKL3U=
X-Received: by 10.36.68.13 with SMTP id o13mr7792433ita.56.1509950701165; Sun, 05 Nov 2017 22:45:01 -0800 (PST)
MIME-Version: 1.0
In-Reply-To: <CAFWoy7EyAKRmKxr_DYXAp_enof3ZvCc9rojHy6FZPE_yBp3-Dg@mail.gmail.com>
References: <CAFWoy7EyAKRmKxr_DYXAp_enof3ZvCc9rojHy6FZPE_yBp3-Dg AT mail DOT gmail DOT com>
From: Wayne Davison <wayne AT opencoder DOT net>
Date: Sun, 5 Nov 2017 22:44:40 -0800
X-Gmail-Original-Message-ID: <CAHSx_Stz6i9nBgs3XSAVKRP1s4FBdJ5br8cWuebT9amrGmX74A AT mail DOT gmail DOT com>
Message-ID: <CAHSx_Stz6i9nBgs3XSAVKRP1s4FBdJ5br8cWuebT9amrGmX74A@mail.gmail.com>
Subject: 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
To: cygwin <cygwin AT cygwin DOT com>
Content-Type: text/plain; charset="UTF-8"
X-IsSubscribed: yes

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 AT 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