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
- Date: Sun, 5 Nov 2017 22:44:40 -0800
- From: Wayne Davison <wayne@xxxxxxxxxxxxx>
- 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
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
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
> 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.
Problem reports: http://cygwin.com/problems.html
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple