From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 4368 invoked by alias); 6 Nov 2017 06:45:30 -0000 Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm Precedence: bulk List-Id: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner@cygwin.com Mail-Followup-To: cygwin@cygwin.com Received: (qmail 4236 invoked by uid 89); 6 Nov 2017 06:45:13 -0000 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 Received: from sub4.mail.dreamhost.com (HELO homiemail-a72.g.dreamhost.com) (69.163.253.135) by sourceware.org (qpsmtpd/0.93/v0.84-503-g423c35a) with ESMTP; Mon, 06 Nov 2017 06:45:03 +0000 Received: from homiemail-a72.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a72.g.dreamhost.com (Postfix) with ESMTP id E66ADA00CEC0 for ; Sun, 5 Nov 2017 22:45:01 -0800 (PST) Received: from mail-it0-f43.google.com (mail-it0-f43.google.com [209.85.214.43]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: dropbox@opencoder.net) by homiemail-a72.g.dreamhost.com (Postfix) with ESMTPSA id CF99EA000B32 for ; Sun, 5 Nov 2017 22:45:01 -0800 (PST) Received: by mail-it0-f43.google.com with SMTP id j140so3896951itj.1 for ; Sun, 05 Nov 2017 22:45:01 -0800 (PST) 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 Received: by 10.107.9.160 with HTTP; Sun, 5 Nov 2017 22:44:40 -0800 (PST) In-Reply-To: References: From: Wayne Davison Date: Mon, 06 Nov 2017 06:45:00 -0000 X-Gmail-Original-Message-ID: Message-ID: 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 Content-Type: text/plain; charset="UTF-8" X-IsSubscribed: yes X-SW-Source: 2017-11/txt/msg00113.txt.bz2 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