on 9/2/05 4:10 PM, Michael Stassen at [EMAIL PROTECTED] wrote:
> So [EMAIL PROTECTED] is missing something (you can't GRANT a privilege you
> don't have). In that case, I think you need to do as Gleb suggested. Shut
> down mysqld, then start it with --skip-grant-tables and reissue
>
>GRANT
Scott Haneda wrote:
on 9/2/05 9:08 AM, Michael Stassen at [EMAIL PROTECTED] wrote:
Modify them how?
show grants for 'root'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN,
PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, LOCK TABLES,
EXECUTE, RE
on 9/2/05 9:08 AM, Michael Stassen at [EMAIL PROTECTED] wrote:
>> Modify them how?
>> show grants for 'root'@'localhost';
>> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN,
>> PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, LOCK TABLES,
>> EXECUTE, REPLICATION
on 9/2/05 6:54 AM, Gleb Paharenko at [EMAIL PROTECTED] wrote:
>
> I was confused by your "all I have is select privs." phrase in the
>
> previous post. Please, send the output of the 'status' command.
>
> What is in the 'Current user' field?
Sorry about the confusion:
mysql Ver 12.22 Distrib
Hello.
> This looks pretty much full access to me?
I was confused by your "all I have is select privs." phrase in the
previous post. Please, send the output of the 'status' command.
What is in the 'Current user' field?
Scott Haneda <[EMAIL PROTECTED]> wrote:
> on 9/2/05 1:27 AM, Gle
Scott Haneda wrote:
on 9/2/05 1:27 AM, Gleb Paharenko at [EMAIL PROTECTED] wrote:
Recreate grants for the 'root'@'localhost' user manually. For this
purpose restart server with --skip-grant-tables command line options
and modify the grant tables. See:
http://dev.mysql.com/doc/mysql/en/rese
on 9/2/05 1:27 AM, Gleb Paharenko at [EMAIL PROTECTED] wrote:
> Recreate grants for the 'root'@'localhost' user manually. For this
>
> purpose restart server with --skip-grant-tables command line options
>
> and modify the grant tables. See:
>
> http://dev.mysql.com/doc/mysql/en/resetting-per
Hello.
> I am ssh'd int the box, so I am localhost, I am root, and it just does not
> want to let me remove access privs, in this case, all I have is select
Recreate grants for the 'root'@'localhost' user manually. For this
purpose restart server with --skip-grant-tables command line option
Mysql 4.0.18-standard
revoke all on *.* from 'deleteatanytime'@'localhost';
mysql> revoke all on *.* from 'deleteatanytime'@'localhost';
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
mysql> revoke all on *.* from [EMAIL PROTECTED];
ERROR 1045: Access denied for use
