[Codes]Resetting MySQL password menu

User Tag List

Results 1 to 1 of 1
  1. #1
    1337w33d's Avatar Member
    Reputation
    6
    Join Date
    Jan 2008
    Posts
    42
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [Codes]Resetting MySQL password

    Hello, I am just trying a bit to get out of leecher and to contribute! I hope that someone finds this useful. I use it, I keep accedentally resetting my password to default when trying to set up my private server to live :banghead:

    1) Login to mysql server, type following command at shell prompt:

    $ mysql -u root -p


    2) Use mysql database (type command at mysql> prompt):

    mysql> use mysql;

    3) Change password for user root:

    mysql> update user set password=PASSWORD("NEWPASSWORD") where User='root';

    4) Reload privileges:

    mysql> flush privileges;
    mysql> quit

    This method you need to use while using PHP or Perl scripting.


    More information:

    Sometimes you forget to set your information, the default information for MySQL is:

    Username: root
    Password: empty

    However if you use something like Plesk software use following information:

    User: admin
    Password: admin

    Sometimes, if you downloaded a repack or someone elses programs, you may have their configuration... your best bet is to ask them what the information is or... place these Fresh config files into your C:\Program Files\MySQL\MySQL Server 5.0\data\mysql (Backup old then overwrite) these files reset your username and password to:

    root
    <no password set> (just hit enter in the dos command shell)

    Should be in where the folders of your database backups, in the mysql folder.


    another good command:

    GRANT USAGE ON *.* TO user@host IDENTIFIED BY 'password';

    If no others work, try:

    SET PASSWORD FOR ‘username’@'localhost’=PASSWORD(’new_password’);

    Make sure not to have any databases selected!

    I searched for any posts with this information, but didn't find any. I am sorry if this turns out to be a repost and/or failure.
    Last edited by 1337w33d; 07-22-2008 at 01:25 AM.

    [Codes]Resetting MySQL password

Similar Threads

  1. Reset Password without SMS Protec + code
    By Fermie in forum World of Warcraft General
    Replies: 7
    Last Post: 11-24-2013, 08:55 AM
  2. How to restart mysql password
    By Pieterkii in forum WoW EMU Guides & Tutorials
    Replies: 1
    Last Post: 07-30-2009, 08:17 AM
  3. [MySQL] Password Reset Question.
    By Submit in forum WoW EMU Questions & Requests
    Replies: 3
    Last Post: 04-06-2009, 08:39 PM
  4. How do you delete all MySQL passwords?
    By zwhit in forum WoW EMU Questions & Requests
    Replies: 3
    Last Post: 12-24-2008, 07:06 PM
  5. How To: password reset ?
    By leetnesspur in forum World of Warcraft General
    Replies: 5
    Last Post: 01-19-2008, 03:19 PM
All times are GMT -5. The time now is 03:32 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search