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
