GRANT syntax issue SOLVED:
Log in to the mysql client as root:
$ mysql -u root -p
Enter password:
MariaDB [keithdb]> use keithdb;
Database changed
MariaDB [keithdb]> grant usage on keithdb.* to 'keith'@'localhost'
with grant option;
Query OK, 0 rows affected (0.00 sec)
Thanks to all who re
On Mon, Nov 6, 2017 at 11:33 AM, Yaakov Selkowitz wrote:
> Could you be more specific as to what you think is missing[?]
I've mentioned the deficiencies on a couple occasions so far, but am
happy to do so again. The biggest problem is a total lack of search
(I've seen mention of Ctrl+R working in
On Mon, Nov 6, 2017 at 12:33 PM, Yaakov Selkowitz wrote:
> On 2017-11-06 00:44, Wayne Davison wrote:
>> On Sun, Nov 5, 2017 at 4:30 PM, Keith Christian wrote:
>>> 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
On 2017-11-06 00:44, Wayne Davison wrote:
> On Sun, Nov 5, 2017 at 4:30 PM, Keith Christian wrote:
>> 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 com
Thanks, Wayne. This should help a great deal.
Keith
>
>
--
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
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 th
-
- 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
7 matches
Mail list logo