I had read that information, along with the PDf that came with the
installation, but the samples that I saw omitted the "@" portion of the
user name.
Indeed, when I used 'Ken'@'localhost', the subsequent connection
worked. When the "@" part is omitted, the [Host] defaults to "%", but
this does not work. Nor does it work when the only entry is for [Host]
= '%', even though the documentation implies that this should work.
Indeed the documentation indicates that <Ken> and <'Ken'> are short
forms for <'Ken'@'%'>, but there is no mention of the fact that a user
cannot log in if this is the only form in the [user] table!
Ah well, at least it is working now, and from REALbasic as well!
Thanks.
-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: "Mark Lubratt" <mark dot lubratt at indeq dot com>
Date: Sun, 29 Feb 2004 13:22:10 -0600
You need to specify the machine user 'Ken' is logging in from. For the
localhost:
mysql> GRANT ALL PRIVILEGES ON MyTrialDB.* TO 'Ken'@'localhost'
IDENTIFIED BY 'Allen';
If you also want to log in from *any* other machines, you'll also have
to add:
mysql> GRANT ALL PRIVILEGES ON MyTrialDB.* TO 'Ken'@'%' IDENTIFIED BY
'Allen';
Since '%' is a wildcard character for machines, you could also add:
mysql> GRANT ALL PRIVILEGES ON MyTrailDB.* TO 'Ken'@'192.168.2.%'
IDENTIFIED BY 'Allen';
This will allow you to logon from subnet 192.168.2.0.
mysql> flush privileges;
Check out:
<http://www.mysql.com/documentation/mysql/bychapter/
manual_MySQL_Database_Administration.html#Adding_users>
Hope that helps!
Mark
- - -
Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|