I've implemented a full-text index on several of my database fields in a
table, populated those fields with some very simple, yet distinct records,
and have run recommended queries against that table. Alas, I still end up
getting back empty query sets. I have read about having a minimum of 3
recor
MySQL is running as a Service in Windows 2000, as one might expect. Tried to
get the logs up and running with a my.cnf file in multiple locations,
including C:/ and DATADIR\my.cnf, then restarted service, tried logging in,
a few inserts, etc - no luck. Flushed logs using mysqladmin too. Here's my
Hey folks,
I'm looking for a great relational (or ordbms) database modeling & design
book. I wouldn't mind supplementing that with a book or other resources on
some example industry/application specific data models. I've perused Amazon,
but thus far, nothing really stands out for either of
Hey all,
This seems like a silly, but rather fundamental question. Should I have
many databases running inside one instance of Mysql with fewer tables in
each, or should have only a few databases with many tables in each (one to
many or many to one, more or less) Does is matter if the
Sent: Wednesday, June 13, 2001 11:15 AM
To: David Simcik
Cc: Mysql
Subject: Re: GRANT ANNOYANCE REVISITED
Hello.
On Wed, Jun 13, 2001 at 10:16:36AM -0500, [EMAIL PROTECTED] wrote:
> Thank you all for your original suggestions, but I'm still having
problems.
> I copied this verbatim from th
described on page 421 of your book to get around that.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 10:47 AM
To: David Simcik; Mysql
Subject: Re: GRANT ANNOYANCE REVISITED
At 10:16 AM -0500 6/13/01, David Simcik wrote:
>Thank you all for y
Thank you all for your original suggestions, but I'm still having problems.
I copied this verbatim from the MySQL docs and tried it on two seperate
servers:
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
->IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
ERROR 1047: Unknown command
Trying to grant super-user level permissions on my root account, but I keep
getting back an error:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@% IDENTIFIED BY 'user' WITH GRANT
OPTION;
ERROR 1064: You have an error in your SQL syntax near '% IDENTIFIED BY
'user' WITH GRANT OPTION' at line 1
What
