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