| View previous topic :: View next topic |
| Author |
Message |
keith-f
-
Joined: 27 May 2003
Posts: 18
Location: North East England
|
 Posted: Tue Jan 17, 2006 1:13 am Post subject: phpMyAdmin Global Privileges Help Please!!!!! |
 |
|
Just as I thought I had a handle on MySQL and phpMyAdmin, Built up my database smashing.... 'Cooking with Gas' In my wisdom/folly I decided to change the Global Privileges from the root user on localhost. Mindful of the consequences of the 'DROP' command..... Yep! I removed it !.......
The logic was, that in the event that I would need to use the 'DROP' instruction, I could simply reinstate it. Mmmmm... Well I can't.
When I check the 'DROP' structure in the Global Privileges and then 'GO'
It refuses to reinstate the 'DROP' instruction and reports:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
I'm really 'STUFFED' with this one as I need to drop and rebuild a table.
Does anyone know how I can reinstate the ‘DROP’ instruction?
_________________
Keith
It is sometimes wiser to keep one's mouth shut and look foolish, Than to open it and remove all doubt! |
|
| Back to top |
   |
 |
MonkeyNation
-
Joined: 05 Feb 2005
Posts: 921
Location: Cardiff
|
| Posted: Tue Jan 17, 2006 10:23 am Post subject: |
|
|
Stop the MySQL server if it's running, make a file in C:\ called mysql.txt (The name doesn't really matter though, to be honest.), paste inside the file:
| Code: | REVOKE ALL PRIVILEGES ON *.* FROM 'root'@'localhost';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0; |
Then, at the command line (cmd.exe) type:
| Code: | | C:\mysql\bin\mysqld-nt.exe --init-file=C:\mysql.txt |
Replacing C:\mysql\bin\mysqld-nt.exe with the path to your mysql binary, if incorrect.
Doing that correctly, should restore all privilages to root.
_________________
 |
|
| Back to top |
    |
|
Tom Chapman
-
Joined: 09 Jul 2005
Posts: 933
Location: Australia
|
| Posted: Tue Jan 17, 2006 11:41 am Post subject: |
|
|
| The answer to my preyares *bad spelling* , Thanks MonkeyNation! |
|
| Back to top |
 |
|
keith-f
-
Joined: 27 May 2003
Posts: 18
Location: North East England
|
| Posted: Tue Jan 17, 2006 12:42 pm Post subject: Cured! |
|
|
What a STAR!
That's ANOTHER fine mess you've got me out......
I had mental premonitions of having to restore last weeks tape backup, with allsorts of dread and horror associated.
MANY THANKS…
BTW You don’t want to come up to this part of the Country – They do horrible things to monkeys just down the road from here! (Hartlepool) It would be such a waste of very useful knowledge!
_________________
Keith
It is sometimes wiser to keep one's mouth shut and look foolish, Than to open it and remove all doubt! |
|
| Back to top |
|
|
Tom Chapman
-
Joined: 09 Jul 2005
Posts: 933
Location: Australia
|
|
| Back to top |
|
|
|
