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>
|