Whoops. a typo there...
mysql> grant all privileges on MyTrialDB.* to ken at localhost;
That's how it was supposed to read...
-tosi
On 29.2.2004, at 19:20, Þór Sigurðsson wrote:
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
| localhost | root | 23e49f2d00abfc2b | Y | Y |
Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y | Y | Y
| | | | |
0 | 0 | 0 |
On 29.2.2004, at 19:02, Ken & Deb Allen wrote:
I recently downloaded and installed MySQL 4.0.15, since I cannot use
the REALdatabase -- too many problems prior to 5.5 and not enough
features in 5.5 for practical use. Since the database built into RB
5.5 is also not sufficient for my needs, I planned to use MySQL
purely for local information.
After installing it and playing with it for a while, I have run into
a problem with the RB code that I cannot understand. I should point
out that I have several years experience with databases, having used
more than 10 different packages, including Microsoft SQL Server,
Sybase, Oracle, Ingres, Emerald, Rdb, DB2, BDB, InterBase, and
others. I have also downloaded and experimented with PostgreSQL, and
I have experimented with MySQL, but the only database I have
experimented with from REALbasic has been the built-in database.
OK, so what is the problem I an having?
As mentioned, I have installed MySQL 4.0.15 and have set the root
password, and I am able to log into the root account. I originally
thought that my problem was related solely to REAL basic, but I have
since found that I also have this problem from the user interface.
The following are the commands that I execute:
$> mysql --user=root --password=xxxx mysql
mysql> CREATE DATABASE MyTrialDB;
mysql> GRANT ALL PRIVILEGES ON MyTrialDB.* TO Ken IDENTIFIED BY
'Allen';
mysql> exit
$> mysql --user=Ken --password=Allen MyTrialDB
ERROR 1045: Access denied for user: 'Ken at localhost' (Using password:
YES)
$>
To clean up after this failed attempt I do the following:
$> mysql --user=root --password=xxxx mysql
mysql> REVOKE ALL PRIVILEGES ON MyTrialDB.* FROM Ken;
mysql> DROP DATABASE IF EXISTS MyTrialDB;
mysql> DELETE FROM user WHERE User = 'Ken';
mysql> FLUSH PRIVILEGES;
mysql> exit
$>
This is the same problem that I was encountering from inside
REALbasic.
I have read the manuals several time and I cannot find any
information that specifically explains this problem. Most database
platforms define the 'user' information to be separate from the
operating system, and the documentation with MySQL seems to confirm
this: <<User names, as used by MySQL for authentication purposes,
have nothing to do with Unix user names (login names) or Windows user
names. Most MySQL clients by default try to log in using the current
Unix user name as the MySQL user name, but that is for convenience
only. Client programs allow a different name to be specified with the
-u or --user options.>>.
I do not see anything that I am doing incorrect! Help!
-Ken
- - -
Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
- - -
Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
- - -
Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|