X-Recipient:	archive-cygwin AT delorie DOT com
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=
DKIM-Signature:	v=1; a=rsa-sha1; c=relaxed; 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; s=default; bh=rLQaZpmrgh7NVNHkqTr6HASrM4w=; b=SIU
	NBuld8ds3Gitqf2vAyjJgwcsjUPEAFHHp02ithn8jdrjZJDOpL6dFj1e+z/ODy6k
	pmWGgsbJvGNtDFu2PuS9CtPbqYTxkOg35NH4pmUjco2/nStEr125ZFg2tdDANCHF
	AmT0m4s2mYsNXGLC5C8Tev7FgBiEk5hs5lDNaX1c=
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id:	<cygwin.cygwin.com>
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sourceware.org/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Authentication-Results:	sourceware.org; auth=none
X-Virus-Found:	No
X-Spam-SWARE-Status:	No, score=-6.2 required=5.0 tests=AWL,BAYES_00,FREEMAIL_FROM,GIT_PATCH_2,RCVD_IN_DNSWL_NONE,RCVD_IN_SORBS_SPAM,SPF_PASS autolearn=ham version=3.3.2 spammy=D*localhost, keith, Question, trial
X-HELO:	mail-yw0-f178.google.com
X-Google-DKIM-Signature:	v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=rw7mg5EsQvksAyo1KlGYJC4S8rAEIRFmwktp61TAjZ0=; b=cIhM3R0H/I4NeK/QiNHc7S9WovUczIPBYWREpJzi8FI5xumtx1URNRGC3EoEmY12wR nPKac9b7fNTE7knQUa8oYEeTic/SeccezpxHX5wyEj5BIPXLV7TYt+X8aDbq7qtk5e32 Gl8HKPdfVGi2yc7g6wyHhT7ElvKU6IzjXI7rHPwyqt14p3xleYTPEkxz1aMAD3uZ8Fps Xj8lJ99gjeq3NUfvz9W3S7Xsb4HgDDjsUPaRDyGWrKRjxaIiBdEgsK7UziMdXloOANjf lR7WuwJ4MkST6PX07oS8JQ2CIy7VebPgcuy5oPO5dTCFVmso4T4oiZkvIBxeLkcJZwsa BtZQ==
X-Gm-Message-State:	AMCzsaXhklyU1dVrw+s6/idKzpjsRrz2bPvb2SZ5+CJKB6WO1u9OmlWW xQI0Y0PZQOjLAIdnWxJA9IdyY/F5dupfbSzu3KS7qQ==
X-Google-Smtp-Source:	ABhQp+RvR0ysqy8SWB7M3jaTKA4UZcPfTE7YaaDdWl0jb86uwgRSoGkFSoy1ywgKNNav5BkjquQ6aY8nwzosuCFagi4=
X-Received:	by 10.37.61.129 with SMTP id k123mr8565645yba.44.1509928202887; Sun, 05 Nov 2017 16:30:02 -0800 (PST)
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
X-IsSubscribed:	yes

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

- Raw text -