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
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:
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:
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, Gleb
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 4.0.18,
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 SLAVE,
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,
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 ALL
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