Re: Trouble with revoke all
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 [EMAIL PROTECTED] 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: '[EMAIL PROTECTED]' (Using password: YES) mysql revoke all on *.* from [EMAIL PROTECTED]; ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trouble with revoke all
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-permissions.html http://dev.mysql.com/doc/mysql/en/privileges.html 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, REPLICATION CLIENT ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '' WITH GRANT OPTION This looks pretty much full access to me? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trouble with revoke all
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/resetting-permissions.html http://dev.mysql.com/doc/mysql/en/privileges.html 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, REPLICATION CLIENT ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '' WITH GRANT OPTION This looks pretty much full access to me? I didn't look closely to see if anything's missing in that list, but full access usually looks like this: GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '' WITH GRANT OPTION Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trouble with revoke all
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 Paharenko 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, REPLICATION CLIENT ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '' WITH GRANT OPTION This looks pretty much full access to me? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trouble with revoke all
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, for apple-darwin6.8 (powerpc) Connection id: 5793710 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: stdout Using outfile: '' Server version: 4.0.18-standard Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 311 days 20 hours 8 min 57 sec Threads: 1 Questions: 46821849 Slow queries: 4396 Opens: 694346 Flush tables: 1 Open tables: 64 Queries per second avg: 1.738 -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trouble with revoke all
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, REPLICATION CLIENT ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '' WITH GRANT OPTION This looks pretty much full access to me? I didn't look closely to see if anything's missing in that list, but full access usually looks like this: GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '' WITH GRANT OPTION And that is the odd thing, running that gives me: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trouble with revoke all
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, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '' WITH GRANT OPTION This looks pretty much full access to me? I didn't look closely to see if anything's missing in that list, but full access usually looks like this: GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '' WITH GRANT OPTION And that is the odd thing, running that gives me: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) 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 PRIVILEGES ON *.* TO 'root'@'localhost'; then stop and start the server again. Alternatively, you could try to do this witout stopping mysqld. UPDATE [EMAIL PROTECTED]'s row in the mysql.user table to have the correct values, then FLUSH PRIVILEGES (but I'm suspicious something like that is how this started). Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trouble with revoke all
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 PRIVILEGES ON *.* TO 'root'@'localhost'; then stop and start the server again. I take it my uptime value is going back to zero :-) Alternatively, you could try to do this witout stopping mysqld. UPDATE [EMAIL PROTECTED]'s row in the mysql.user table to have the correct values, then FLUSH PRIVILEGES (but I'm suspicious something like that is how this started). I never fiddle direct like that, but there was that fix_privs_table script mysql provided I had to run at one time during an update. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Trouble with revoke 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 user: '[EMAIL PROTECTED]' (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. -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]