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
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. Th
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 grantin
usr/local/bin/myisamchk /var/db/mysql/*/*.MYI
>
> (adjust 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
&g
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
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
[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
