How did you add the users?
If you inserted them into the user table, you are asking for trouble
unless you
understand exactly what you are doing. That is why the GRANT and REVOKE
statements were added.
Since you did not use 'identified by somepassword'
I'm not sure if you set one, in which case
I must be going so wrong here.
I deleted the users and started again.
added 2 users
dba and matt. Both of these have the host of % (connect from anything yes ?)
I then do a
grant all privileges on *.* to dba@%
flush privileges
and
grant all privileges on *.* to matt@%
flush privileges
.
Quentin
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 January 2002 11:10 p.m.
To: Ho Kam; Gerald Clark
Cc: MySql List
Subject: RE: command mysql -u $user without typing it - getting shafted
and annoyed now.
I must be going so wrong here.
I deleted
PROTECTED]'; Ho Kam; Gerald Clark
Cc: MySql List
Subject: RE: command mysql -u $user without typing it - getting shafted
and annoyed now.
Hi Again
I just did this to check what you did:
SKYROAD#mercury1:/mercury/home/quentin:mysql --user=mercury -p mysql
Enter password:
mysql grant all privileges