How do I fetch my MySQL username and also password?
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]';
But DO NOT FORGET to
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.
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:
- Log on to your system as Administrator.
- 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';
FLUSH PRIVILEGES;
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.
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.
You need to currently have the ability to connect to MySQL as origin making use of the new password.
Related questions