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