From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 6880 invoked by alias); 6 Nov 2017 00:30:34 -0000 Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm Precedence: bulk List-Id: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner@cygwin.com Mail-Followup-To: cygwin@cygwin.com Received: (qmail 127399 invoked by uid 89); 6 Nov 2017 00:30:14 -0000 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 Received: from mail-yw0-f178.google.com (HELO mail-yw0-f178.google.com) (209.85.161.178) by sourceware.org (qpsmtpd/0.93/v0.84-503-g423c35a) with ESMTP; Mon, 06 Nov 2017 00:30:04 +0000 Received: by mail-yw0-f178.google.com with SMTP id w5so6538326ywg.11 for ; Sun, 05 Nov 2017 16:30:04 -0800 (PST) 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 Received: by 10.13.231.7 with HTTP; Sun, 5 Nov 2017 16:30:02 -0800 (PST) From: Keith Christian Date: Mon, 06 Nov 2017 00:30:00 -0000 Message-ID: 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@cygwin.com Content-Type: text/plain; charset="UTF-8" X-IsSubscribed: yes X-SW-Source: 2017-11/txt/msg00109.txt.bz2 ----- ----- 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@localhost@localhost? Seems that is should be only "keith@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@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