Error with MySQL. Privileges. Please help ^^ menu

User Tag List

Results 1 to 2 of 2
  1. #1
    jadethread1's Avatar Member
    Reputation
    -14
    Join Date
    Dec 2011
    Posts
    64
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Error with MySQL. Privileges. Please help ^^

    Code:
    REVOKE ALL PRIVILEGES ON * . * FROM 'mangos'@'localhost';
    
    REVOKE ALL PRIVILEGES ON `mangos` . * FROM 'mangos'@'localhost';
    
    REVOKE GRANT OPTION ON `mangos` . * FROM 'mangos'@'localhost';
    
    REVOKE ALL PRIVILEGES ON `characters` . * FROM 'mangos'@'localhost';
    
    REVOKE GRANT OPTION ON `characters` . * FROM 'mangos'@'localhost';
    
    REVOKE ALL PRIVILEGES ON `realmd` . * FROM 'mangos'@'localhost';
    
    REVOKE GRANT OPTION ON `realmd` . * FROM 'mangos'@'localhost';
    
    DELETE FROM `user` WHERE CONVERT( User USING utf8 ) = CONVERT( 'mangos' USING utf8 ) AND CONVERT( Host USING utf8 ) = CONVERT( 'localhost' USING utf8 ) ;
    
    DROP DATABASE IF EXISTS `mangos` ;
    
    DROP DATABASE IF EXISTS `characters` ;
    
    DROP DATABASE IF EXISTS `realmd` ;
    I ran that command^ by accident and now I cant do anything. I've tried EVERYTHING (5 hours worth of everthing) possible. And still no results. I've reinstalled Mysql 3+ times. Ran everything you could think of. And Still get this error.


    Code:
    /* SQL Error (1044): Access denied for user 'root'@'localhost' to database 'mysql' */

    When I try to do anything. Please someone help me. This is really frustrating. Thanks

    Edit: Oh, I can connect to the database and all. Just cant alter anything. And also can connect to MySQL 5.5 Command Line Client. (if that helps with anything) Sorry for the inconvienece. Just trying to get it fixed ^^ Thanks again.

    Error with MySQL. Privileges. Please help ^^
  2. #2
    stoneharry's Avatar Moderator Harry


    Reputation
    1618
    Join Date
    Sep 2007
    Posts
    4,564
    Thanks G/R
    151/150
    Trade Feedback
    0 (0%)
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    You lost all permissions -> can't do anything.

    Literally the only way to fix it (as far as I am aware) would be to completely uninstall MySQL, restart your computer, then install it again.

    And this is why you should make backups.

Similar Threads

  1. Help me please!..Error with Noggit 1.2..Help me!
    By litio in forum WoW ME Questions and Requests
    Replies: 4
    Last Post: 01-17-2010, 05:48 PM
  2. Get error with every repack! Please help.
    By Enuf in forum WoW EMU Questions & Requests
    Replies: 13
    Last Post: 09-12-2008, 03:28 AM
  3. How to buy An Item with an Item...Please Help
    By Biden in forum World of Warcraft Emulator Servers
    Replies: 9
    Last Post: 05-23-2008, 06:35 AM
  4. Ac Ultimate Repack Error With Mysql
    By Greatdrak in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 10-03-2007, 08:35 AM
  5. Can't connect to MySQL Server, please help
    By Possum in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 09-27-2007, 01:12 PM
All times are GMT -5. The time now is 11:00 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search