Actually, the GRABT statement creates the entry almost as specified,
except the record in the [user] table contains '%' for the [Host]
column. The corrected action seems to be to specify the user as
'Ken'@'localhost'.
-Ken
On Feb 29, 2004, at 2:39 PM, REALbasic Network Users Group wrote:
Subject: Re: Problem with MySQL 4.0.15 and REALbasic 5.2.4
From: "Þór Sigurðsson" <tosi at orku dot net>
Date: Sun, 29 Feb 2004 19:20:37 +0000
Your problem is that you think like a dba should, and MySQL is screwed
up and goes at lengths being different. :)
Having said that, try:
# mysql mysql -u root -p
mysql> insert into user values (
'localhost','ken',PASSWORD("Allen"),'N','N','N','N','N','N','N','N','N'
,
'N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0);
mysql> flush privileges;
mysql> grant all privileges on MyTrialDB to ken at localhost;
mysql> flush privileges;
That should do it for ken at localhost dot Repeat as needed for other
hosts/users.
-tosi
- - -
Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|