This is the mail archive of the cygwin mailing list for the Cygwin project.

Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

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
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" then you would have a TCP
connection to the localhost IP that you would need to grant permission
for using 'keith'@'' 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.


Problem reports:
Unsubscribe info:

Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]