I lost the root password I put when I installed MySQL, but I do not know how to reset / change without knowing the password
I lost the root password I put when I installed MySQL, but I do not know how to reset / change without knowing the password
cmd
into the run window. Within it navigate to the bin folder of MySQL .
Ex: C:\mysql\bin
using the cd
command. mysqld.exe-u root - skip-grant-tables
cd
command.
Type mysql
and press Enter . use mysql;
to select the database mysql
. UPDATE user SET Password = PASSWORD ( 'NOVA_SENHA') WHERE User = 'root';
Source: Resetting MYSQL root password in WINDOWS XP / server 2003