How do I fetch my MySQL username and also password?

I shed my MySQL username and also password. Just how do I fetch it?

2019-05-13 03:42:26
Source Share
Answers: 2

Stop the MySQL procedure.

Start the MySQL procedure with the - - miss - grant - tables alternative.

Start the MySQL console customer with the - u origin alternative.

Detail all the customers ;

SELECT * FROM mysql.user;

Reset password ;

UPDATE mysql.user SET Password=PASSWORD('[password]') WHERE User='[username]';


Stop the MySQL procedure

Start the MySQL Process generally (i.e. without the - - miss - grant - tables alternative)

when you are ended up. Or else, your data source is protection can be endangered.

2019-05-17 15:04:03

Unfortunately your customer password is irretrievable. It has actually been hashed with a one means hash which if you do not recognize is irreparable. I advise select Xenph Yan over and also simply create an new one.

You can additionally make use of the adhering to procedure from the manual for resetting the password for any kind of MySQL origin accounts on Windows:

  1. Log on to your system as Administrator.
  2. Stop the MySQL web server if it is running. For a web server that is running as a Windows solution, most likely to the Services supervisor:

Start Menu - > Control Panel - > Administrative Tools - > Services

Then locate the MySQL solution in the checklist, and also stop it. If your web server is not running as a solution, you might require to make use of the Task Manager to compel it to stop.

< ol start = "3" >
  • Create a message documents and also area the adhering to declarations in it. Change the password with the password that you intend to make use of.

    UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';

    The UPDATE and also FLUSH declarations each have to be created on a solitary line. The UPDATE declaration resets the password for all existing origin accounts, and also the FLUSH declaration informs the web server to refill the grant tables right into memory.

  • Conserve the documents. For this instance, the documents will certainly be called C :\ mysql - init.txt.
  • Open a console window to reach the command punctual:

    Start Menu - > Run - > cmd

  • Start the MySQL web server with the unique - - init - documents alternative:

    C:\> C:\mysql\bin\mysqld-nt --init-file = C:\mysql-init.txt

    If you mounted MySQL to an area apart from C :\ mysql , readjust the command as necessary.

    The web server implements the materials of the documents called by the - - init - documents alternative at start-up, transforming each origin account password.

    You can additionally add the - - console alternative to the command if you desire web server result to show up in the console window as opposed to in a log documents.

    If you mounted MySQL making use of the MySQL Installation Wizard, you might require to define a - - defaults - documents alternative:

    C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini" --init-file=C:\mysql-init.txt

    The ideal - - defaults - documents setup can be located making use of the Services Manager:

    Start Menu - > Control Panel - > Administrative Tools - > Services

    Find the MySQL solution in the checklist, appropriate - click it, and also pick the Properties alternative. The Path to executable area has the - - defaults - documents setup.

  • After the web server has actually begun efficiently, delete C :\ mysql - init.txt .
  • Stop the MySQL web server, after that reactivate it in regular setting once more. If you run the web server as a solution, start it from the Windows Services window. If you start the web server by hand, make use of whatever command you generally make use of.
  • You need to currently have the ability to connect to MySQL as origin making use of the new password.

    2019-05-17 05:37:22