Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011

    Unanswered: Server 5.1 on Win., Find MySQL User Account Settings to Change Root Password

    Hi All- I'd like to change passwords for users on a 5.1 Windows Server install I did not set up and for which I have no root password.

    Here's what I'm working with:
    a) I can start in --skip-grant-tables mode and run SQL commands in the mysql shell
    b) I have admin access to the Win 2003 server where the install resides
    c) I can create a batch file that changes the --init settings and can apply SQL to update the root password, but I'm not clear on where the root password lives
    d) There is a user.frm file in [install dir]\Databases\data\mysql
    e) I have a particular database I can use, which is where I really need to do the database account password updates, but mysql says the database [db name].users does not exist

    I'm wondering where the root account password is located so I can update it.

    Thanks in advance.


  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain
    I had prepared a mini tutorial on the steps to follow in order to change the password. This is based on a Linux system but the principles apply to Windows. Check out: MySQL - changing lost root password - YouTube
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts