Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- root user without privileges?
September 18, 2006, 12:42 pm
rate this thread
privileges from the 'root' user, namely:
[ Data ]
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
How can we restore all the privileges to the root user in such
condition without reinstalling MySql?
Re: root user without privileges?
You can do a lot to restore privileges by following steps documented here:
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum