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:from:date:message-id:subject:to
	:content-type; q=dns; s=default; b=u3I3rNqqFB9JRwuw3c4GiSjN5xQSA
	Y2sSr8GfVZdWnwaRcRQe/MxJCvDPdA7bvj7MSkArGIYaBxPW8u1/Ro9BZ8E9BwAw
	ZPkuAYcxYaHzdKOIx/c0n+6IpRQIRQUE87vWT0NQ65yMoVxnt2zHkyQqX6mJyeeV
	cgt2ChmTjmcG/w=
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
MIME-Version: 1.0
From: Keith Christian <keith1christian AT gmail DOT com>
Date: Sun, 5 Nov 2017 17:30:02 -0700
Message-ID: <CAFWoy7EyAKRmKxr_DYXAp_enof3ZvCc9rojHy6FZPE_yBp3-Dg@mail.gmail.com>
Subject: 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 AT cygwin DOT com
Content-Type: text/plain; charset="UTF-8"

-----
----- Background:
-----

After much trial and error, I installed MariaDB and its mysql client
on the latest Cygwin.

$ mysql_install_db
$ cd '/usr' ; /usr/bin/mysqld_safe --datadir='/var/lib/mysql'
$ mysql
$ mysql -u root -p

Created a 'keithdb' database as the MySQL/MariaDB 'root' user

Also created a 'keith' user and want to add "full" permission TO the
'keithdb' database for this new 'keith' user.

I've tried all of the following grant commands below and none of them
work.  I'm obviously missing something here.  I see that the grant
syntax has changed from older MySQL to MariaDB;


-----
----- Question 1: Could someone help me with the GRANT syntax for
MariaDB 10.1.26?  Even the web pages for MariaDB did not work, so I
must have a fundamental problem.
-----
     1  show grants;
     2  GRANT ALL PRIVILEGES ON keithdb TO 'keith'@'localhost' WITH
GRANT OPTION;
     3  GRANT ALL PRIVILEGES ON 'keithdb 'to 'keith'@'localhost' WITH
GRANT OPTION;
     4  GRANT ALL PRIVILEGES ON 'keithdb' TO 'keith'@'localhost' WITH
GRANT OPTION;
     5  GRANT ALL ON 'keithdb' TO 'keith'@'localhost' WITH GRANT OPTION;
     6  GRANT ALL ON keithdb TO 'keith'@'localhost' WITH GRANT OPTION;
     7  GRANT ALL ON database keithdb TO 'keith'@'localhost' WITH GRANT OPTION;
     8  GRANT ALL 'keith'@'localhost' ON keithdb WITH GRANT OPTION;


-----
----- Question 2:  Why does the login below show "Current user:"
keith AT localhost@localhost?  Seems that is should be only
"keith AT localhost."
-----
$ mysql -u 'keith'@'localhost'
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 21
Server version: 10.1.26-MariaDB Source distribution

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> status
--------------
mysql  Ver 15.1 Distrib 10.1.26-MariaDB, for CYGWIN (x86_64) using
EditLine wrapper

Connection id:          21
Current database:
Current user:           keith AT localhost@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server:                 MariaDB
Server version:         10.1.26-MariaDB Source distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /var/run/mysql.sock
Uptime:                 1 day 2 hours 7 min 50 sec

Threads: 1  Questions: 110  Slow queries: 0  Opens: 17  Flush tables:
1  Open tables: 11  Queries per second avg: 0.001
--------------

MariaDB [(none)]> quit
Bye


-----
----- Question 3:  How can I get GNU readline back as the editor for
the mysql client?
-----
Someone else asked this question but the answer appeared difficult.


Thanks for your time and suggestions, Cygwin list folks.

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