Click here to get back home

root user without privileges?
 Home | NewsGroups | Search | About
Login Password
Register Now!
 mailing.database.mysql    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
root user without privileges? menoquindici 09-18-2006
Posted by menoquindici on September 18, 2006, 8:42 am
Please log in for more thread options
 We have a situation here where one of my co-workers removed several
privileges from the 'root' user, namely:

[ Data ]

INSERT
UPDATE
DELETE
FILE


Now, every time I enter with the root user and try to re-activate these
privileges I get:

#1045 - Access denied for user 'root'@'localhost' (using password: YES)



If I try to modify the privileges by editing the 'user' table of the
'mysql' database I get:

#1142 - UPDATE command denied to user 'root'@'localhost' for table
'user'


How can we restore all the privileges to the root user in such
condition without reinstalling MySql?


thanks!


Posted by Bill Karwin on September 18, 2006, 1:54 pm
Please log in for more thread options
 menoquindici@luca.su wrote:
> We have a situation here where one of my co-workers removed several
> privileges from the 'root' user, ...

You can do a lot to restore privileges by following steps documented here:

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

Regards,
Bill K.

Similar ThreadsPosted
copy user privileges to a newly created user. June 27, 2005, 6:57 am
how do I reset user "root" password ? February 12, 2006, 8:12 pm
'Access denied for user 'root'@'localhost' (using password: NO)' November 13, 2006, 11:39 pm
installing perl on mysql on suse 9.3 - error because root user has password July 21, 2005, 11:56 am
Privileges August 30, 2006, 10:55 am
Privileges on specific fields in a DB October 31, 2005, 2:14 am
create database privileges May 26, 2006, 4:46 am
MySQL 5 lost all privileges August 10, 2006, 5:04 pm
Forget root password August 30, 2006, 4:53 am
Any way to protect your data files from root? July 14, 2005, 4:20 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap