It should be 'username'@'localhost'
Mark Shade wrote:
Yep...
I am in as root, so I should have rights to everything.
Yep, I have confirmed that the dbname is right, but doublechecking it
multiple times. Plus, this happens even on db that I did the same thing to
only a week ago. The *
Mark,
Thursday, May 09, 2002, 7:31:28 PM, you wrote:
MS I am trying to grant rights to a new db to a new user.
MS I am issuing the following commands (with obvious substitutions):
MS mysql GRANT ALL
MS - ON dbname.*
MS - TO username@localhost
MS - IDENTIFIED BY 'password';
MS I
[snip]
mysql GRANT ALL
- ON dbname.*
- TO username@localhost
- IDENTIFIED BY 'password';
[/snip]
A. Do you have GRANT capability as the user that you are logged on as?
2. Is dbname.* right? Shouldn't it be just dbname?
III. Is user set up as username@localhost?
Jay
Yep...
I am in as root, so I should have rights to everything.
Yep, I have confirmed that the dbname is right, but doublechecking it
multiple times. Plus, this happens even on db that I did the same thing to
only a week ago. The * just says all tables as I understand it.
And, that is what
paths to your install, of course).
- Mark
- Original Message -
From: Mark Shade [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 10, 2002 12:16 AM
Subject: RE: error granting rights
Yep...
I am in as root, so I should have rights to everything.
Yep, I have confirmed
paths to your install, of course).
- Mark
- Original Message -
From: Mark Shade [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 10, 2002 12:16 AM
Subject: RE: error granting rights
Yep...
I am in as root, so I should have rights to everything.
Yep, I have
Subject: RE: error granting rights
Yep...
I am in as root, so I should have rights to everything.
Yep, I have confirmed that the dbname is right, but doublechecking it
multiple times. Plus, this happens even on db that I did the same
thing to only a week ago. The * just says