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 options
and modify the grant tables. See:
http://dev.mysql.com/doc/mysql/en/resetting-permissions.html
http://dev.mysql.com/doc/mysql/en/privileges.html
> Mysql 4.0.18-standard
Your version of MySQL is rather old, I recommend you to upgrade to the
latest release (use 4.1.14 or 4.0.25).
Scott Haneda <lists@stripped> wrote:
> Mysql 4.0.18-standard
>
> revoke all on *.* from 'deleteatanytime'@'localhost';
>
> mysql> revoke all on *.* from 'deleteatanytime'@'localhost';
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
> mysql> revoke all on *.* from deleteatanytime@localhost;
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
>
> 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
> privs. For the longest time I just delete the user and recreate the
> permissions, but I would like to figure out how to make this work.
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
